APPS.AHL_LTP_SPACE_ASSIGN_PVT dependencies on AHL_SPACE_UNAVAILABLE_B

Line 494: FROM ahl_space_unavailable_b

490: CURSOR space_available_cur(c_space_id IN NUMBER)
491: IS
492: SELECT trunc(start_date) start_date,
493: trunc(end_date) end_date
494: FROM ahl_space_unavailable_b
495: WHERE space_id = c_space_id;
496: --
497: CURSOR space_capable_cur (c_space_id IN NUMBER,
498: c_visit_type IN VARCHAR2,

Line 513: FROM ahl_space_unavailable_b

509: c_start_date IN DATE,
510: c_end_date IN DATE)
511: IS
512: SELECT trunc(start_date),trunc(end_date)
513: FROM ahl_space_unavailable_b
514: WHERE space_id = c_space_id
515: -- AND ((c_start_date between trunc(start_date) and trunc(end_date))
516: -- or (c_end_date between trunc(start_date) and trunc(end_date)));
517: AND ((trunc(start_date) between c_start_date and c_end_date)

Line 1485: FROM ahl_space_unavailable_b

1481: c_start_date IN DATE,
1482: c_end_date IN DATE)
1483: IS
1484: SELECT 1
1485: FROM ahl_space_unavailable_b
1486: WHERE space_id = space_id
1487: AND (c_start_date between trunc(start_date) and trunc(end_date)
1488: OR
1489: c_end_date between trunc(start_date) and trunc(end_date));