:$PROFILES$.XXXX 如何转换SELECTNameFROMHR_ORGANIZATION_UNITS houWHERE(1 1) ANDbusiness_group_id
:$PROFILES$.XXXX 如何转换
SELECT Name
FROM HR_ORGANIZATION_UNITS hou
WHERE (1 = 1)
AND business_group_id =:$PROFILES$.PER_BUSINESS_GROUP_ID
AND hou.type =:$FLEX$.ITS_PAYORG_TYPE
?
w/c can be similar to :
SELECT Name
FROM HR_ORGANIZATION_UNITS hou
WHERE (1 = 1)
AND business_group_id =FND_PROFILE.VALUE('PER_BUSINESS_GROUP_ID')
AND hou.type =:$FLEX$.ITS_PAYORG_TYPE
?