APPS.AHL_APPR_DEPT_SHIFTS_PUB dependencies on BOM_DEPARTMENTS_V

Line 156: FROM BOM_DEPARTMENTS_V

152:
153: CURSOR get_org_dept_id(C_ORG_ID NUMBER,C_DESCRIPTION VARCHAR2)
154: IS
155: SELECT DEPARTMENT_ID
156: FROM BOM_DEPARTMENTS_V
157: WHERE ORGANIZATION_ID=C_ORG_ID
158: AND DESCRIPTION=C_DESCRIPTION;
159:
160: CURSOR get_bom_calendar(C_CALENDAR VARCHAR2)