APPS.HR_ES_UTILITY dependencies on HR_ALL_ORGANIZATION_UNITS

Line 508: FROM hr_organization_information hoi,hr_all_organization_units hou

504: ,p_business_group_id NUMBER
505: ,p_effective_date DATE) IS
506: CURSOR get_cac_wc IS
507: SELECT 'x'
508: FROM hr_organization_information hoi,hr_all_organization_units hou
509: WHERE hoi.org_information_context = 'ES_WORK_CENTER_DETAILS'
510: AND hou.organization_id = hoi.organization_id
511: AND org_information1 = p_org_info
512: AND hou.business_group_id = p_business_group_id

Line 523: FROM hr_organization_information hoi,hr_all_organization_units hou

519: and hoi1.org_information2 = 'Y');
520:
521: CURSOR get_cac_statutory IS
522: SELECT 'x'
523: FROM hr_organization_information hoi,hr_all_organization_units hou
524: WHERE hoi.org_information_context = 'ES_STATUTORY_INFO'
525: AND hou.organization_id = hoi.organization_id
526: AND org_information8 = p_org_info
527: AND hou.business_group_id = p_business_group_id

Line 589: FROM hr_organization_information hoi,hr_all_organization_units hou

585: ,p_business_group_id NUMBER
586: ,p_effective_date DATE) IS
587: CURSOR get_ss_code IS
588: SELECT 'x'
589: FROM hr_organization_information hoi,hr_all_organization_units hou
590: WHERE hoi.org_information_context in('ES_SS_PROVINCE_DETAILS','ES_SS_OFFICE_DETAILS')
591: AND hou.organization_id = hoi.organization_id
592: AND org_information1 = p_org_info
593: AND hou.business_group_id = p_business_group_id

Line 628: FROM hr_organization_information hoi,hr_all_organization_units hou

624: ,p_business_group_id NUMBER
625: ,p_effective_date DATE) IS
626: CURSOR get_cif IS
627: SELECT 'x'
628: FROM hr_organization_information hoi,hr_all_organization_units hou
629: WHERE hoi.org_information_context = 'ES_STATUTORY_INFO'
630: AND hou.organization_id = hoi.organization_id
631: AND org_information5 = p_org_info
632: AND hou.business_group_id = p_business_group_id

Line 663: ,hr_all_organization_units hou

659:
660: CURSOR csr_chk_wc_sec_ref IS
661: SELECT 'x'
662: FROM hr_organization_information hoi
663: ,hr_all_organization_units hou
664: WHERE hoi.org_information_context = p_context
665: AND hoi.org_information1 = p_org_information1
666: AND hoi.organization_id = hou.organization_id
667: AND hou.business_group_id = p_business_group_id