APPS.OTA_CANCEL_TRAINING_SS dependencies on OTA_FINANCE_HEADERS

Line 352: l_cancel_header_id ota_finance_headers.finance_header_id%TYPE;

348: lf_object_version_number ota_finance_lines.object_version_number%TYPE;
349: l_sequence_number ota_finance_lines.sequence_number%TYPE;
350: l_finance_count number(10);
351: l_cancelled_flag ota_finance_lines.cancelled_flag%type;
352: l_cancel_header_id ota_finance_headers.finance_header_id%TYPE;
353: --
354: -- ------------------------
355: -- header_csr Variables
356: -- ------------------------

Line 358: lh_finance_header_id ota_finance_headers.finance_header_id%TYPE;

354: -- ------------------------
355: -- header_csr Variables
356: -- ------------------------
357: --
358: lh_finance_header_id ota_finance_headers.finance_header_id%TYPE;
359: lh_cancelled_flag ota_finance_headers.cancelled_flag%TYPE;
360: lh_transfer_status ota_finance_headers.transfer_status%TYPE;
361: lh_object_version_number ota_finance_headers.object_version_number%TYPE;
362: --

Line 359: lh_cancelled_flag ota_finance_headers.cancelled_flag%TYPE;

355: -- header_csr Variables
356: -- ------------------------
357: --
358: lh_finance_header_id ota_finance_headers.finance_header_id%TYPE;
359: lh_cancelled_flag ota_finance_headers.cancelled_flag%TYPE;
360: lh_transfer_status ota_finance_headers.transfer_status%TYPE;
361: lh_object_version_number ota_finance_headers.object_version_number%TYPE;
362: --
363: -- ------------------------

Line 360: lh_transfer_status ota_finance_headers.transfer_status%TYPE;

356: -- ------------------------
357: --
358: lh_finance_header_id ota_finance_headers.finance_header_id%TYPE;
359: lh_cancelled_flag ota_finance_headers.cancelled_flag%TYPE;
360: lh_transfer_status ota_finance_headers.transfer_status%TYPE;
361: lh_object_version_number ota_finance_headers.object_version_number%TYPE;
362: --
363: -- ------------------------
364: -- other local Variables

Line 361: lh_object_version_number ota_finance_headers.object_version_number%TYPE;

357: --
358: lh_finance_header_id ota_finance_headers.finance_header_id%TYPE;
359: lh_cancelled_flag ota_finance_headers.cancelled_flag%TYPE;
360: lh_transfer_status ota_finance_headers.transfer_status%TYPE;
361: lh_object_version_number ota_finance_headers.object_version_number%TYPE;
362: --
363: -- ------------------------
364: -- other local Variables
365: -- ------------------------

Line 428: FROM ota_finance_headers flh,

424: SELECT flh.finance_header_id finance_header_id,
425: flh.cancelled_flag cancelled_flag,
426: flh.transfer_status transfer_status,
427: flh.object_version_number object_version_number
428: FROM ota_finance_headers flh,
429: ota_finance_lines fln
430: WHERE flh.finance_header_id = fln.finance_header_id
431: AND fln.booking_id = p_booking_id;
432: --