DBA Data[Home] [Help]

APPS.PAY_KR_YEA_DON_EFILE_PKG dependencies on HR_ORGANIZATION_UNITS

Line 19: hr_organization_units bp2,

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

Line 21: hr_organization_units bp1

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'
25: and bp2.business_group_id = bp1.business_group_id