DBA Data[Home] [Help]

APPS.PAY_GB_RETRO_UPGRADE dependencies on HR_ORGANIZATION_INFORMATION

Line 382: from hr_organization_information hoi,

378:
379: cursor c_get_business_group(cp_element_set_id in number
380: ,cp_legislation_code in varchar2) is
381: select hoi.organization_id
382: from hr_organization_information hoi,
383: hr_organization_information hoi2
384: where hoi.org_information_context = 'CLASS'
385: and hoi.org_information1 = 'HR_BG'
386: and hoi.organization_id = hoi2.organization_id

Line 383: hr_organization_information hoi2

379: cursor c_get_business_group(cp_element_set_id in number
380: ,cp_legislation_code in varchar2) is
381: select hoi.organization_id
382: from hr_organization_information hoi,
383: hr_organization_information hoi2
384: where hoi.org_information_context = 'CLASS'
385: and hoi.org_information1 = 'HR_BG'
386: and hoi.organization_id = hoi2.organization_id
387: and hoi2.org_information_context = 'Business Group Information'