APPS.AHL_VWP_DEPT_SHIFTS_PUB dependencies on HR_ALL_ORGANIZATION_UNITS

Line 130: FROM HR_ALL_ORGANIZATION_UNITS

126: as
127: CURSOR get_org_id(C_NAME VARCHAR2)
128: IS
129: SELECT ORGANIZATION_ID
130: FROM HR_ALL_ORGANIZATION_UNITS
131: WHERE NAME=C_NAME;
132:
133: CURSOR get_org_dept_id(C_ORG_ID NUMBER,C_DESCRIPTION VARCHAR2)
134: IS