APPS.AHL_UA_FLIGHT_SCHEDULES_PVT dependencies on BOM_DEPARTMENTS

Line 266: FROM BOM_DEPARTMENTS BD

262: -- Cursor for getting org id from org name
263: CURSOR dept_name_to_id_csr(p_dept_code IN VARCHAR2, p_org_id IN NUMBER)
264: IS
265: SELECT DEPARTMENT_ID
266: FROM BOM_DEPARTMENTS BD
267: WHERE BD.DEPARTMENT_CODE = p_dept_code AND
268: BD.ORGANIZATION_ID = p_org_id;
269:
270: -- Define all local variables here.