DBA Data[Home] [Help]

APPS.AHL_APPR_DEPT_SHIFTS_PUB dependencies on BOM_DEPARTMENTS_V

Line 169: FROM BOM_DEPARTMENTS_V

165:
166: CURSOR get_org_dept_id(C_ORG_ID NUMBER,C_DESCRIPTION VARCHAR2)
167: IS
168: SELECT DEPARTMENT_ID
169: FROM BOM_DEPARTMENTS_V
170: WHERE ORGANIZATION_ID=C_ORG_ID
171: AND DESCRIPTION=C_DESCRIPTION;
172:
173: CURSOR get_bom_calendar(C_CALENDAR VARCHAR2)