APPS.PAY_KR_YEA_DON_EFILE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 35: hr_organization_information bhoi_primary,

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

Line 36: hr_organization_information bhoi,

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

Line 37: hr_organization_information choi,

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

Line 38: hr_organization_information ihoi,

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

Line 55: from hr_organization_information

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