DBA Data[Home] [Help]

APPS.AHL_LTP_SPACE_SCHEDULE_PVT dependencies on AHL_SPACE_UNAVAILABLE_B

Line 638: FROM ahl_space_unavailable_b

634: c_start_date IN DATE,
635: c_end_date IN DATE)
636: IS
637: SELECT space_unavailability_id
638: FROM ahl_space_unavailable_b
639: WHERE space_id = c_space_id
640: AND (trunc(start_date) between c_start_date and c_end_date
641: or trunc(end_date) between c_start_date and c_end_date);
642: --

Line 724: FROM AHL_SPACE_UNAVAILABLE_B

720: CURSOR space_un_cur (c_space_id IN NUMBER,
721: c_date in DATE)
722: IS
723: SELECT space_id
724: FROM AHL_SPACE_UNAVAILABLE_B
725: WHERE space_id = c_space_id
726: AND trunc(c_date) between trunc(start_date) and trunc(end_date);
727:
728: --