DBA Data[Home] [Help]

APPS.PAY_US_RETRO_UPGRADE dependencies on HR_ORGANIZATION_INFORMATION

Line 341: from hr_organization_information hoi,

337:
338: cursor c_get_business_group(cp_element_set_id in number
339: ,cp_legislation_code in varchar2) is
340: select hoi.organization_id
341: from hr_organization_information hoi,
342: hr_organization_information hoi2
343: where hoi.org_information_context = 'CLASS'
344: and hoi.org_information1 = 'HR_BG'
345: and hoi.organization_id = hoi2.organization_id

Line 342: hr_organization_information hoi2

338: cursor c_get_business_group(cp_element_set_id in number
339: ,cp_legislation_code in varchar2) is
340: select hoi.organization_id
341: from hr_organization_information hoi,
342: hr_organization_information hoi2
343: where hoi.org_information_context = 'CLASS'
344: and hoi.org_information1 = 'HR_BG'
345: and hoi.organization_id = hoi2.organization_id
346: and hoi2.org_information_context = 'Business Group Information'