APPS.PAY_KR_YEA_MED_EFILE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 36: hr_organization_information bhoi_primary,

32: per_assignments_f pa,
33: pay_assignment_actions paa,
34: pay_payroll_actions ppa,
35: hr_organization_units hou1,
36: hr_organization_information bhoi_primary,
37: hr_organization_information bhoi,
38: hr_organization_information choi,
39: hr_organization_information ihoi,
40: ff_archive_items ar

Line 37: hr_organization_information bhoi,

33: pay_assignment_actions paa,
34: pay_payroll_actions ppa,
35: hr_organization_units hou1,
36: hr_organization_information bhoi_primary,
37: hr_organization_information bhoi,
38: hr_organization_information choi,
39: hr_organization_information ihoi,
40: ff_archive_items ar
41: where

Line 38: hr_organization_information choi,

34: pay_payroll_actions ppa,
35: hr_organization_units hou1,
36: hr_organization_information bhoi_primary,
37: hr_organization_information bhoi,
38: hr_organization_information choi,
39: hr_organization_information ihoi,
40: ff_archive_items ar
41: where
42: bhoi_primary.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')

Line 39: hr_organization_information ihoi,

35: hr_organization_units hou1,
36: hr_organization_information bhoi_primary,
37: hr_organization_information bhoi,
38: hr_organization_information choi,
39: hr_organization_information ihoi,
40: ff_archive_items ar
41: where
42: bhoi_primary.organization_id = pay_magtape_generic.get_parameter_value('PRIMARY_BP_ID')
43: and bhoi_primary.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'

Line 56: from hr_organization_information

52: or ( (bhoi.organization_id in ( select posev.ORGANIZATION_ID_child
53: from PER_ORG_STRUCTURE_ELEMENTS posev
54: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
55: and exists ( select null
56: from hr_organization_information
57: where organization_id = posev.ORGANIZATION_ID_child
58: and org_information_context = 'CLASS'
59: and org_information1 = 'KR_BUSINESS_PLACE'
60: )