APPS.AHL_VWP_DEPT_SHIFTS_PUB dependencies on BOM_DEPARTMENTS_V

Line 136: FROM BOM_DEPARTMENTS_V

132:
133: CURSOR get_org_dept_id(C_ORG_ID NUMBER,C_DESCRIPTION VARCHAR2)
134: IS
135: SELECT DEPARTMENT_ID
136: FROM BOM_DEPARTMENTS_V
137: WHERE ORGANIZATION_ID=C_ORG_ID
138: AND DESCRIPTION=C_DESCRIPTION;
139:
140: CURSOR get_bom_calendar(C_CALENDAR VARCHAR2)