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;