APPS.OTA_TRNG_ENROLL_SS dependencies on OTA_FINANCE_HEADERS

Line 867: l_cancel_header_id ota_finance_headers.finance_header_id%TYPE;

863: l_sequence_number ota_finance_lines.sequence_number%TYPE;
864: l_raised_date date;
865: l_finance_count number(10);
866: l_cancelled_flag ota_finance_lines.cancelled_flag%type;
867: l_cancel_header_id ota_finance_headers.finance_header_id%TYPE;
868: -- ------------------------
869: -- header_cur Variables
870: -- ------------------------
871: lh_finance_header_id ota_finance_headers.finance_header_id%TYPE;

Line 871: lh_finance_header_id ota_finance_headers.finance_header_id%TYPE;

867: l_cancel_header_id ota_finance_headers.finance_header_id%TYPE;
868: -- ------------------------
869: -- header_cur Variables
870: -- ------------------------
871: lh_finance_header_id ota_finance_headers.finance_header_id%TYPE;
872: lh_cancelled_flag ota_finance_headers.cancelled_flag%TYPE;
873: lh_transfer_status ota_finance_headers.transfer_status%TYPE;
874: lh_object_version_number ota_finance_headers.object_version_number%TYPE;
875:

Line 872: lh_cancelled_flag ota_finance_headers.cancelled_flag%TYPE;

868: -- ------------------------
869: -- header_cur Variables
870: -- ------------------------
871: lh_finance_header_id ota_finance_headers.finance_header_id%TYPE;
872: lh_cancelled_flag ota_finance_headers.cancelled_flag%TYPE;
873: lh_transfer_status ota_finance_headers.transfer_status%TYPE;
874: lh_object_version_number ota_finance_headers.object_version_number%TYPE;
875:
876: CURSOR finance (p_booking_id ota_finance_lines.booking_id%TYPE) IS

Line 873: lh_transfer_status ota_finance_headers.transfer_status%TYPE;

869: -- header_cur Variables
870: -- ------------------------
871: lh_finance_header_id ota_finance_headers.finance_header_id%TYPE;
872: lh_cancelled_flag ota_finance_headers.cancelled_flag%TYPE;
873: lh_transfer_status ota_finance_headers.transfer_status%TYPE;
874: lh_object_version_number ota_finance_headers.object_version_number%TYPE;
875:
876: CURSOR finance (p_booking_id ota_finance_lines.booking_id%TYPE) IS
877: SELECT FLN.finance_line_id finance_line_id,

Line 874: lh_object_version_number ota_finance_headers.object_version_number%TYPE;

870: -- ------------------------
871: lh_finance_header_id ota_finance_headers.finance_header_id%TYPE;
872: lh_cancelled_flag ota_finance_headers.cancelled_flag%TYPE;
873: lh_transfer_status ota_finance_headers.transfer_status%TYPE;
874: lh_object_version_number ota_finance_headers.object_version_number%TYPE;
875:
876: CURSOR finance (p_booking_id ota_finance_lines.booking_id%TYPE) IS
877: SELECT FLN.finance_line_id finance_line_id,
878: FLN.finance_header_id finance_header_id,

Line 897: FROM OTA_FINANCE_HEADERS FLH,

893: SELECT FLH.finance_header_id finance_header_id,
894: FLH.cancelled_flag cancelled_flag,
895: FLH.transfer_status transfer_status,
896: FLH.object_version_number object_version_number
897: FROM OTA_FINANCE_HEADERS FLH,
898: OTA_FINANCE_LINES FLN
899: WHERE FLH.finance_header_id = FLN.finance_header_id
900: AND FLN.booking_id = p_booking_id;
901: