APPS.PAY_KR_YEA_MAGTAPE_PKG dependencies on HR_ORGANIZATION_INFORMATION

Line 18: from hr_organization_information hoi2,

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

Line 19: hr_organization_information hoi3,

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

Line 21: hr_organization_information hoi1,

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

Line 32: from hr_organization_information

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