APPS.PAY_KR_YEA_DON_EFILE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 17: from hr_organization_information hoi3,

13: l_proc varchar2(61) := c_package || 'populate_a';
14: --
15: cursor csr_a is
16: select count(distinct hoi2.org_information2||hoi3.org_information9)
17: from hr_organization_information hoi3,
18: hr_organization_information hoi2,
19: hr_organization_units bp2,
20: hr_organization_information hoi1,
21: hr_organization_units bp1

Line 18: hr_organization_information hoi2,

14: --
15: cursor csr_a is
16: select count(distinct hoi2.org_information2||hoi3.org_information9)
17: from hr_organization_information hoi3,
18: hr_organization_information hoi2,
19: hr_organization_units bp2,
20: hr_organization_information hoi1,
21: hr_organization_units bp1
22: where bp1.organization_id = g_business_place_id

Line 20: hr_organization_information hoi1,

16: select count(distinct hoi2.org_information2||hoi3.org_information9)
17: from hr_organization_information hoi3,
18: hr_organization_information hoi2,
19: hr_organization_units bp2,
20: hr_organization_information hoi1,
21: hr_organization_units bp1
22: where bp1.organization_id = g_business_place_id
23: and hoi1.organization_id = bp1.organization_id
24: and hoi1.org_information_context = 'KR_BUSINESS_PLACE_REGISTRATION'

Line 31: from hr_organization_information

27: or ( (hoi2.organization_id in ( select posev.ORGANIZATION_ID_child
28: from PER_ORG_STRUCTURE_ELEMENTS posev
29: where posev.org_structure_version_id=(pay_magtape_generic.get_parameter_value('ORG_STRUC_VERSION_ID'))
30: and exists ( select null
31: from hr_organization_information
32: where organization_id = posev.ORGANIZATION_ID_child
33: and org_information_context = 'CLASS'
34: and org_information1 = 'KR_BUSINESS_PLACE'
35: )