DBA Data[Home] [Help]

APPS.PAY_IN_EOY_REPORTS dependencies on HR_ALL_ORGANIZATION_UNITS

Line 2308: FROM hr_all_organization_units hou

2304:
2305: CURSOR csr_fetch_gre( p_gre_id IN hr_organization_units.organization_id%TYPE)
2306: IS
2307: SELECT hou.organization_id orgid
2308: FROM hr_all_organization_units hou
2309: , hr_organization_information hoi
2310: WHERE hou.organization_id = hoi.organization_id
2311: AND hoi.org_information_context = 'CLASS'
2312: AND hoi.org_information1 = 'HR_LEGAL'

Line 2565: FROM hr_all_organization_units hou

2561:
2562: CURSOR csr_fetch_gre( p_gre_id IN hr_organization_units.organization_id%TYPE)
2563: IS
2564: SELECT hou.organization_id orgid
2565: FROM hr_all_organization_units hou
2566: , hr_organization_information hoi
2567: WHERE hou.organization_id = hoi.organization_id
2568: AND hoi.org_information_context = 'CLASS'
2569: AND hoi.org_information1 = 'HR_LEGAL'