DBA Data[Home] [Help]

APPS.PAY_KR_YEA_MAGTAPE_PKG dependencies on HR_ORGANIZATION_UNITS

Line 20: hr_organization_units bp2,

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
24: and hoi1.organization_id = bp1.organization_id

Line 22: hr_organization_units bp1

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'
26: --Bug 5069923