APPS.AHL_UA_FLIGHT_SCHEDULES_PVT dependencies on BOM_DEPARTMENTS

Line 332: FROM BOM_DEPARTMENTS BD

328: -- Cursor for getting org id from org name
329: CURSOR dept_name_to_id_csr(p_dept_code IN VARCHAR2, p_org_id IN NUMBER)
330: IS
331: SELECT DEPARTMENT_ID
332: FROM BOM_DEPARTMENTS BD
333: WHERE BD.DEPARTMENT_CODE = p_dept_code AND
334: BD.ORGANIZATION_ID = p_org_id;
335:
336: /* MANESING::Auto Visit Forecasting Project, 17-Oct-2011, added following cursor