[Home] [Help]
3383:
3384: cursor crs_enrollment_change_reason
3385: is
3386: SELECT bsh.comments
3387: FROM ota_booking_status_histories bsh
3388: WHERE bsh.booking_id = p_booking_id
3389: AND bsh.start_date =
3390: (SELECT MAX(start_date)
3391: FROM ota_booking_status_histories
3387: FROM ota_booking_status_histories bsh
3388: WHERE bsh.booking_id = p_booking_id
3389: AND bsh.start_date =
3390: (SELECT MAX(start_date)
3391: FROM ota_booking_status_histories
3392: WHERE booking_id = p_booking_id);
3393:
3394: CURSOR crs_enr_change_reason_lang(p_lookup_code in varchar2) IS
3395: SELECT meaning