[Home] [Help]
990: AND EXISTS (SELECT
991: 1
992: FROM
993: hr_organization_units hou
994: , hr_soft_coding_keyflex scl
995: WHERE paf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
996: AND scl.segment1 = hou.organization_id
997: AND paf.business_group_id = FND_PROFILE.value('PER_BUSINESS_GROUP_ID')
998: )