DBA Data[Home] [Help]

APPS.PAY_AU_RETRO_UPGRADE dependencies on HR_ORGANIZATION_INFORMATION

Line 1800: from hr_organization_information hoi,

1796:
1797: cursor c_get_business_group(cp_element_set_id in number
1798: ,cp_legislation_code in varchar2) is
1799: select hoi.organization_id
1800: from hr_organization_information hoi,
1801: hr_organization_information hoi2
1802: where hoi.org_information_context = 'CLASS'
1803: and hoi.org_information1 = 'HR_BG'
1804: and hoi.organization_id = hoi2.organization_id

Line 1801: hr_organization_information hoi2

1797: cursor c_get_business_group(cp_element_set_id in number
1798: ,cp_legislation_code in varchar2) is
1799: select hoi.organization_id
1800: from hr_organization_information hoi,
1801: hr_organization_information hoi2
1802: where hoi.org_information_context = 'CLASS'
1803: and hoi.org_information1 = 'HR_BG'
1804: and hoi.organization_id = hoi2.organization_id
1805: and hoi2.org_information_context = 'Business Group Information'