DBA Data[Home] [Help]

APPS.PAY_IN_EOY_REPORTS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 2005: FROM hr_all_organization_units hou

2001:
2002: CURSOR csr_fetch_gre( p_gre_id IN hr_organization_units.organization_id%TYPE)
2003: IS
2004: SELECT hou.organization_id orgid
2005: FROM hr_all_organization_units hou
2006: , hr_organization_information hoi
2007: WHERE hou.organization_id = hoi.organization_id
2008: AND hoi.org_information_context = 'CLASS'
2009: AND hoi.org_information1 = 'HR_LEGAL'