APPS.AHL_LTP_SPACE_ASSIGN_PVT dependencies on AHL_SPACE_UNAVAILABLE_B

Line 767: FROM ahl_space_unavailable_b

763: CURSOR space_available_cur(c_space_id IN NUMBER)
764: IS
765: SELECT trunc(start_date) start_date,
766: trunc(end_date) end_date
767: FROM ahl_space_unavailable_b
768: WHERE space_id = c_space_id;
769: --
770: CURSOR space_capable_cur (c_space_id IN NUMBER,
771: c_visit_type IN VARCHAR2,

Line 787: FROM ahl_space_unavailable_b

783: c_start_date IN DATE,
784: c_end_date IN DATE)
785: IS
786: SELECT trunc(start_date),trunc(end_date)
787: FROM ahl_space_unavailable_b
788: WHERE space_id = c_space_id
789: -- AND ((c_start_date between trunc(start_date) and trunc(end_date))
790: -- or (c_end_date between trunc(start_date) and trunc(end_date)));
791: AND ((trunc(start_date) between c_start_date and c_end_date)

Line 798: FROM ahl_space_unavailable_b

794: CURSOR space_unavailable_cur(c_space_id IN NUMBER,
795: c_start_date IN DATE,c_end_date IN DATE)
796: IS
797: SELECT trunc(start_date),trunc(end_date)
798: FROM ahl_space_unavailable_b
799: WHERE space_id = c_space_id
800: AND (((trunc(start_date) between trunc(c_start_date) and trunc(c_end_date))
801: OR (trunc(end_date) between trunc(c_start_date) and trunc(c_end_date)))
802: OR ((trunc(c_start_date) between trunc(start_date) and trunc(end_date))

Line 1879: FROM ahl_space_unavailable_b

1875: c_start_date IN DATE,
1876: c_end_date IN DATE)
1877: IS
1878: SELECT 1
1879: FROM ahl_space_unavailable_b
1880: WHERE space_id = space_id
1881: AND ((trunc(c_start_date) between trunc(start_date) and trunc(end_date)
1882: OR
1883: trunc(c_end_date) between trunc(start_date) and trunc(end_date))