APPS.HR_RU_UTILITY dependencies on HR_ORGANIZATION_INFORMATION

Line 192: FROM hr_organization_information o1, hr_organization_information o2

188: AND p_spifn = pp.per_information13
189: AND pp.business_group_id IN (
190: --Select all business groups having leg. code RU
191: SELECT o1.organization_id
192: FROM hr_organization_information o1, hr_organization_information o2
193: WHERE o1.org_information9 = 'RU'
194: AND o1.organization_id = o2.organization_id
195: AND o1.org_information_context = 'Business Group Information'
196: AND o2.org_information_context = 'CLASS'

Line 467: FROM hr_organization_units hou, hr_organization_information hoi

463: SELECT 'Y'
464: FROM SYS.dual
465: WHERE EXISTS (
466: SELECT '1'
467: FROM hr_organization_units hou, hr_organization_information hoi
468: WHERE (p_org_id <> hoi.organization_id)
469: AND hou.organization_id = hoi.organization_id
470: AND hou.business_group_id IN (
471: SELECT o3.organization_id

Line 472: FROM hr_organization_information o3, hr_organization_information o4

468: WHERE (p_org_id <> hoi.organization_id)
469: AND hou.organization_id = hoi.organization_id
470: AND hou.business_group_id IN (
471: SELECT o3.organization_id
472: FROM hr_organization_information o3, hr_organization_information o4
473: WHERE o3.org_information9 = 'RU'
474: AND o3.organization_id = o4.organization_id
475: AND o3.org_information_context = 'Business Group Information'
476: AND o4.org_information_context = 'CLASS'

Line 959: FROM hr_organization_information o1, hr_organization_information o2

955: AND paaf.soft_coding_keyflex_id = scl.soft_coding_keyflex_id
956: AND paaf.business_group_id IN (
957: --Select all business groups having leg. code RU
958: SELECT o1.organization_id
959: FROM hr_organization_information o1, hr_organization_information o2
960: WHERE o1.org_information9 = 'RU'
961: AND o1.organization_id = o2.organization_id
962: AND o1.org_information_context = 'Business Group Information'
963: AND o2.org_information_context = 'CLASS'