APPS.AHL_APPR_DEPT_SHIFTS_PUB dependencies on HR_ALL_ORGANIZATION_UNITS

Line 150: FROM HR_ALL_ORGANIZATION_UNITS

146: as
147: CURSOR get_org_id(C_NAME VARCHAR2)
148: IS
149: SELECT ORGANIZATION_ID
150: FROM HR_ALL_ORGANIZATION_UNITS
151: WHERE NAME=C_NAME;
152:
153: CURSOR get_org_dept_id(C_ORG_ID NUMBER,C_DESCRIPTION VARCHAR2)
154: IS