APPS.OTA_CANCEL_TRAINING_SS dependencies on OTA_BOOKING_STATUS_HISTORIES

Line 683: FROM ota_booking_status_histories bsh

679: p_booking_status_type_id IN NUMBER) RETURN VARCHAR2
680: IS
681: CURSOR comments_cr IS
682: SELECT bsh.comments
683: FROM ota_booking_status_histories bsh
684: WHERE bsh.booking_id = p_booking_id
685: AND bsh.booking_status_type_id = p_booking_status_type_id
686: ORDER BY bsh.start_date ASC;
687: --

Line 689: l_comments ota_booking_status_histories.comments%TYPE := null;

685: AND bsh.booking_status_type_id = p_booking_status_type_id
686: ORDER BY bsh.start_date ASC;
687: --
688: --
689: l_comments ota_booking_status_histories.comments%TYPE := null;
690: l_proc varchar2(72) := 'ota_cancel_enrollment_ss.get_booking_status_comments';
691: --
692: begin
693: --