507: SELECT
508: orgtl.name department_name
509: , org.organization_id department_id
510: FROM
511: hr_organization_units org
512: , hr_all_organization_units_tl orgtl
513: WHERE orgtl.organization_id = org.organization_id
514: AND orgtl.LANGUAGE = userenv('LANG')
515: AND org.business_group_id = fnd_profile.VALUE('PER_BUSINESS_GROUP_ID')
989: BETWEEN paf.effective_start_date AND paf.effective_end_date
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')