APPS.OTA_EL_ENROLL_SS dependencies on OTA_FINANCE_HEADERS

Line 873: l_cancel_header_id ota_finance_headers.finance_header_id%TYPE;

869: l_sequence_number ota_finance_lines.sequence_number%TYPE;
870: l_raised_date date;
871: l_finance_count number(10);
872: l_cancelled_flag ota_finance_lines.cancelled_flag%type;
873: l_cancel_header_id ota_finance_headers.finance_header_id%TYPE;
874: -- ------------------------
875: -- header_cur Variables
876: -- ------------------------
877: lh_finance_header_id ota_finance_headers.finance_header_id%TYPE;

Line 877: lh_finance_header_id ota_finance_headers.finance_header_id%TYPE;

873: l_cancel_header_id ota_finance_headers.finance_header_id%TYPE;
874: -- ------------------------
875: -- header_cur Variables
876: -- ------------------------
877: lh_finance_header_id ota_finance_headers.finance_header_id%TYPE;
878: lh_cancelled_flag ota_finance_headers.cancelled_flag%TYPE;
879: lh_transfer_status ota_finance_headers.transfer_status%TYPE;
880: lh_object_version_number ota_finance_headers.object_version_number%TYPE;
881:

Line 878: lh_cancelled_flag ota_finance_headers.cancelled_flag%TYPE;

874: -- ------------------------
875: -- header_cur Variables
876: -- ------------------------
877: lh_finance_header_id ota_finance_headers.finance_header_id%TYPE;
878: lh_cancelled_flag ota_finance_headers.cancelled_flag%TYPE;
879: lh_transfer_status ota_finance_headers.transfer_status%TYPE;
880: lh_object_version_number ota_finance_headers.object_version_number%TYPE;
881:
882: CURSOR finance (p_booking_id ota_finance_lines.booking_id%TYPE) IS

Line 879: lh_transfer_status ota_finance_headers.transfer_status%TYPE;

875: -- header_cur Variables
876: -- ------------------------
877: lh_finance_header_id ota_finance_headers.finance_header_id%TYPE;
878: lh_cancelled_flag ota_finance_headers.cancelled_flag%TYPE;
879: lh_transfer_status ota_finance_headers.transfer_status%TYPE;
880: lh_object_version_number ota_finance_headers.object_version_number%TYPE;
881:
882: CURSOR finance (p_booking_id ota_finance_lines.booking_id%TYPE) IS
883: SELECT FLN.finance_line_id finance_line_id,

Line 880: lh_object_version_number ota_finance_headers.object_version_number%TYPE;

876: -- ------------------------
877: lh_finance_header_id ota_finance_headers.finance_header_id%TYPE;
878: lh_cancelled_flag ota_finance_headers.cancelled_flag%TYPE;
879: lh_transfer_status ota_finance_headers.transfer_status%TYPE;
880: lh_object_version_number ota_finance_headers.object_version_number%TYPE;
881:
882: CURSOR finance (p_booking_id ota_finance_lines.booking_id%TYPE) IS
883: SELECT FLN.finance_line_id finance_line_id,
884: FLN.finance_header_id finance_header_id,

Line 903: FROM OTA_FINANCE_HEADERS FLH,

899: SELECT FLH.finance_header_id finance_header_id,
900: FLH.cancelled_flag cancelled_flag,
901: FLH.transfer_status transfer_status,
902: FLH.object_version_number object_version_number
903: FROM OTA_FINANCE_HEADERS FLH,
904: OTA_FINANCE_LINES FLN
905: WHERE FLH.finance_header_id = FLN.finance_header_id
906: AND FLN.booking_id = p_booking_id;
907: