APPS.AHL_APPR_SPACE_UNAVL_PVT dependencies on AHL_SPACE_UNAVAILABLE_B

Line 505: FROM ahl_space_unavailable_b

501: CURSOR space_restirct_date_cur
502: (c_space_unavailability_id IN NUMBER)
503: IS
504: SELECT start_date, end_date
505: FROM ahl_space_unavailable_b
506: WHERE space_unavailability_id = c_space_unavailability_id;
507: --
508: -- Status Local Variables
509: l_return_status VARCHAR2(1);

Line 809: SELECT AHL_SPACE_UNAVAILABLE_B_S.NEXTVAL

805: IS
806: --
807: CURSOR c_seq
808: IS
809: SELECT AHL_SPACE_UNAVAILABLE_B_S.NEXTVAL
810: FROM dual;
811: --
812: CURSOR c_id_exists (x_id IN NUMBER) IS
813: SELECT 1

Line 816: FROM ahl_space_unavailable_b

812: CURSOR c_id_exists (x_id IN NUMBER) IS
813: SELECT 1
814: FROM dual
815: WHERE EXISTS (SELECT 1
816: FROM ahl_space_unavailable_b
817: WHERE space_unavailability_id = x_id);
818: --
819: CURSOR check_duplicate_cur (c_space_id IN NUMBER,
820: c_start_date IN DATE,