APPS.PAY_KR_NONSTAT_SPAY_EFILE dependencies on HR_ORGANIZATION_INFORMATION

Line 80: from hr_organization_information hoi

76:
77: cursor c_business_place_count
78: is
79: select count(distinct hoi.org_information2||ihoi.org_information9) bp_count
80: from hr_organization_information hoi
81: ,hr_organization_units hou
82: ,hr_organization_units phou
83: ,hr_organization_information phoi
84: ,hr_organization_information ihoi

Line 83: ,hr_organization_information phoi

79: select count(distinct hoi.org_information2||ihoi.org_information9) bp_count
80: from hr_organization_information hoi
81: ,hr_organization_units hou
82: ,hr_organization_units phou
83: ,hr_organization_information phoi
84: ,hr_organization_information ihoi
85: where hou.organization_id = hoi.organization_id
86: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
87: and hoi.org_information10 = phoi.org_information10

Line 84: ,hr_organization_information ihoi

80: from hr_organization_information hoi
81: ,hr_organization_units hou
82: ,hr_organization_units phou
83: ,hr_organization_information phoi
84: ,hr_organization_information ihoi
85: where hou.organization_id = hoi.organization_id
86: and hoi.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'
87: and hoi.org_information10 = phoi.org_information10
88: and phou.organization_id = primary_business_place_id

Line 96: from hr_organization_information

92: or ( (hoi.organization_id in (select posev.ORGANIZATION_ID_child
93: from PER_ORG_STRUCTURE_ELEMENTS posev
94: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
95: and exists ( select null
96: from hr_organization_information
97: where organization_id = posev.ORGANIZATION_ID_child
98: and org_information_context = 'CLASS'
99: and org_information1 = 'KR_BUSINESS_PLACE'
100: )