DBA Data[Home] [Help]

APPS.PAY_IP_RETRO_UPGRADE dependencies on HR_ORGANIZATION_INFORMATION

Line 299: from hr_organization_information hoi,

295:
296: cursor c_get_business_group(cp_element_set_id in number
297: ,cp_legislation_code in varchar2) is
298: select hoi.organization_id
299: from hr_organization_information hoi,
300: hr_organization_information hoi2
301: where hoi.org_information_context = 'CLASS'
302: and hoi.org_information1 = 'HR_BG'
303: and hoi.organization_id = hoi2.organization_id

Line 300: hr_organization_information hoi2

296: cursor c_get_business_group(cp_element_set_id in number
297: ,cp_legislation_code in varchar2) is
298: select hoi.organization_id
299: from hr_organization_information hoi,
300: hr_organization_information hoi2
301: where hoi.org_information_context = 'CLASS'
302: and hoi.org_information1 = 'HR_BG'
303: and hoi.organization_id = hoi2.organization_id
304: and hoi2.org_information_context = 'Business Group Information'