APPS.OTA_ENROLL_IN_TRAINING_SS dependencies on OTA_FINANCE_HEADERS

Line 866: l_cancel_header_id ota_finance_headers.finance_header_id%TYPE;

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

Line 870: lh_finance_header_id ota_finance_headers.finance_header_id%TYPE;

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

Line 871: lh_cancelled_flag ota_finance_headers.cancelled_flag%TYPE;

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

Line 872: lh_transfer_status ota_finance_headers.transfer_status%TYPE;

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

Line 873: lh_object_version_number ota_finance_headers.object_version_number%TYPE;

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

Line 896: FROM OTA_FINANCE_HEADERS FLH,

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