DBA Data[Home] [Help]

APPS.PAY_KR_YEA_MED_EFILE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 39: hr_organization_information bhoi_primary,

35: per_assignments_f pa,
36: pay_assignment_actions paa,
37: pay_payroll_actions ppa,
38: hr_organization_units hou1,
39: hr_organization_information bhoi_primary,
40: hr_organization_information bhoi,
41: hr_organization_information choi,
42: hr_organization_information ihoi,
43: ff_archive_items ar

Line 40: hr_organization_information bhoi,

36: pay_assignment_actions paa,
37: pay_payroll_actions ppa,
38: hr_organization_units hou1,
39: hr_organization_information bhoi_primary,
40: hr_organization_information bhoi,
41: hr_organization_information choi,
42: hr_organization_information ihoi,
43: ff_archive_items ar
44: where

Line 41: hr_organization_information choi,

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

Line 42: hr_organization_information ihoi,

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

Line 59: from hr_organization_information

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