APPS.AHL_APPR_DEPT_SHIFTS_PUB dependencies on HR_ALL_ORGANIZATION_UNITS

Line 163: FROM HR_ALL_ORGANIZATION_UNITS

159: as
160: CURSOR get_org_id(C_NAME VARCHAR2)
161: IS
162: SELECT ORGANIZATION_ID
163: FROM HR_ALL_ORGANIZATION_UNITS
164: WHERE NAME=C_NAME;
165:
166: CURSOR get_org_dept_id(C_ORG_ID NUMBER,C_DESCRIPTION VARCHAR2)
167: IS