DBA Data[Home] [Help]

APPS.PAY_AU_RETRO_UPGRADE dependencies on HR_ORGANIZATION_INFORMATION

Line 2003: from hr_organization_information hoi,

1999:
2000: cursor c_get_business_group(cp_element_set_id in number
2001: ,cp_legislation_code in varchar2) is
2002: select hoi.organization_id
2003: from hr_organization_information hoi,
2004: hr_organization_information hoi2
2005: where hoi.org_information_context = 'CLASS'
2006: and hoi.org_information1 = 'HR_BG'
2007: and hoi.organization_id = hoi2.organization_id

Line 2004: hr_organization_information hoi2

2000: cursor c_get_business_group(cp_element_set_id in number
2001: ,cp_legislation_code in varchar2) is
2002: select hoi.organization_id
2003: from hr_organization_information hoi,
2004: hr_organization_information hoi2
2005: where hoi.org_information_context = 'CLASS'
2006: and hoi.org_information1 = 'HR_BG'
2007: and hoi.organization_id = hoi2.organization_id
2008: and hoi2.org_information_context = 'Business Group Information'