APPS.AHL_UA_FLIGHT_SCHEDULES_PVT dependencies on AHL_SPACE_CAPBLTS_V

Line 344: FROM AHL_SPACE_CAPBLTS_V

340: CURSOR space_name_to_id_csr (c_org_id NUMBER,
341: c_dept_id NUMBER,
342: c_space_name VARCHAR2) IS
343: SELECT distinct space_id
344: FROM AHL_SPACE_CAPBLTS_V
345: WHERE status_code = 'Y'
346: AND organization_id = c_org_id
347: AND bom_department_id = c_dept_id
348: AND space_name = c_space_name;

Line 1396: FROM AHL_SPACE_CAPBLTS_V

1392: CURSOR validate_space_id_csr (c_space_id NUMBER,
1393: c_org_id NUMBER,
1394: c_dept_id NUMBER) IS
1395: SELECT 'X'
1396: FROM AHL_SPACE_CAPBLTS_V
1397: WHERE space_id = c_space_id
1398: AND status_code = 'Y'
1399: AND organization_id = c_org_id
1400: AND bom_department_id = c_dept_id;