DBA Data[Home] [Help]

APPS.POA_REPORT_UTIL dependencies on HR_ORGANIZATION_UNITS

Line 746: FROM hr_organization_units hr

742: p_org_id OUT NOCOPY NUMBER) RETURN BOOLEAN IS
743: l_global_check NUMBER;
744: CURSOR c0 IS
745: SELECT hr.organization_id
746: FROM hr_organization_units hr
747: WHERE hr.name = p_org_name;
748: CURSOR c1 IS
749: SELECT hr.organization_id
750: FROM hr_organization_units hr

Line 750: FROM hr_organization_units hr

746: FROM hr_organization_units hr
747: WHERE hr.name = p_org_name;
748: CURSOR c1 IS
749: SELECT hr.organization_id
750: FROM hr_organization_units hr
751: WHERE hr.name = p_org_name
752: AND (hr.organization_id IN
753: (SELECT organization_id FROM org_organization_definitions
754: WHERE set_of_books_id IN