APPS.OTA_LEARNER_ENROLL_SS dependencies on OTA_FINANCE_HEADERS

Line 703: l_cancel_header_id ota_finance_headers.finance_header_id%TYPE;

699: l_sequence_number ota_finance_lines.sequence_number%TYPE;
700: l_raised_date date;
701: l_finance_count number(10);
702: l_cancelled_flag ota_finance_lines.cancelled_flag%type;
703: l_cancel_header_id ota_finance_headers.finance_header_id%TYPE;
704: -- ------------------------
705: -- header_cur Variables
706: -- ------------------------
707: lh_finance_header_id ota_finance_headers.finance_header_id%TYPE;

Line 707: lh_finance_header_id ota_finance_headers.finance_header_id%TYPE;

703: l_cancel_header_id ota_finance_headers.finance_header_id%TYPE;
704: -- ------------------------
705: -- header_cur Variables
706: -- ------------------------
707: lh_finance_header_id ota_finance_headers.finance_header_id%TYPE;
708: lh_cancelled_flag ota_finance_headers.cancelled_flag%TYPE;
709: lh_transfer_status ota_finance_headers.transfer_status%TYPE;
710: lh_object_version_number ota_finance_headers.object_version_number%TYPE;
711:

Line 708: lh_cancelled_flag ota_finance_headers.cancelled_flag%TYPE;

704: -- ------------------------
705: -- header_cur Variables
706: -- ------------------------
707: lh_finance_header_id ota_finance_headers.finance_header_id%TYPE;
708: lh_cancelled_flag ota_finance_headers.cancelled_flag%TYPE;
709: lh_transfer_status ota_finance_headers.transfer_status%TYPE;
710: lh_object_version_number ota_finance_headers.object_version_number%TYPE;
711:
712: l_hours_until_class_starts NUMBER;

Line 709: lh_transfer_status ota_finance_headers.transfer_status%TYPE;

705: -- header_cur Variables
706: -- ------------------------
707: lh_finance_header_id ota_finance_headers.finance_header_id%TYPE;
708: lh_cancelled_flag ota_finance_headers.cancelled_flag%TYPE;
709: lh_transfer_status ota_finance_headers.transfer_status%TYPE;
710: lh_object_version_number ota_finance_headers.object_version_number%TYPE;
711:
712: l_hours_until_class_starts NUMBER;
713: l_minimum_advance_notice NUMBER;

Line 710: lh_object_version_number ota_finance_headers.object_version_number%TYPE;

706: -- ------------------------
707: lh_finance_header_id ota_finance_headers.finance_header_id%TYPE;
708: lh_cancelled_flag ota_finance_headers.cancelled_flag%TYPE;
709: lh_transfer_status ota_finance_headers.transfer_status%TYPE;
710: lh_object_version_number ota_finance_headers.object_version_number%TYPE;
711:
712: l_hours_until_class_starts NUMBER;
713: l_minimum_advance_notice NUMBER;
714: l_event_id ota_events.event_id%TYPE;

Line 747: FROM OTA_FINANCE_HEADERS FLH,

743: SELECT FLH.finance_header_id finance_header_id,
744: FLH.cancelled_flag cancelled_flag,
745: FLH.transfer_status transfer_status,
746: FLH.object_version_number object_version_number
747: FROM OTA_FINANCE_HEADERS FLH,
748: OTA_FINANCE_LINES FLN
749: WHERE FLH.finance_header_id = FLN.finance_header_id
750: AND FLN.booking_id = p_booking_id;
751:

Line 1830: l_cancel_header_id ota_finance_headers.finance_header_id%TYPE;

1826: lf_object_version_number ota_finance_lines.object_version_number%TYPE;
1827: l_sequence_number ota_finance_lines.sequence_number%TYPE;
1828: l_finance_count number(10);
1829: l_cancelled_flag ota_finance_lines.cancelled_flag%type;
1830: l_cancel_header_id ota_finance_headers.finance_header_id%TYPE;
1831:
1832: -- ------------------------
1833: -- header_csr Variables
1834: -- ------------------------

Line 1835: lh_finance_header_id ota_finance_headers.finance_header_id%TYPE;

1831:
1832: -- ------------------------
1833: -- header_csr Variables
1834: -- ------------------------
1835: lh_finance_header_id ota_finance_headers.finance_header_id%TYPE;
1836: lh_cancelled_flag ota_finance_headers.cancelled_flag%TYPE;
1837: lh_transfer_status ota_finance_headers.transfer_status%TYPE;
1838: lh_object_version_number ota_finance_headers.object_version_number%TYPE;
1839: -- ------------------------

Line 1836: lh_cancelled_flag ota_finance_headers.cancelled_flag%TYPE;

1832: -- ------------------------
1833: -- header_csr Variables
1834: -- ------------------------
1835: lh_finance_header_id ota_finance_headers.finance_header_id%TYPE;
1836: lh_cancelled_flag ota_finance_headers.cancelled_flag%TYPE;
1837: lh_transfer_status ota_finance_headers.transfer_status%TYPE;
1838: lh_object_version_number ota_finance_headers.object_version_number%TYPE;
1839: -- ------------------------
1840: -- other local Variables

Line 1837: lh_transfer_status ota_finance_headers.transfer_status%TYPE;

1833: -- header_csr Variables
1834: -- ------------------------
1835: lh_finance_header_id ota_finance_headers.finance_header_id%TYPE;
1836: lh_cancelled_flag ota_finance_headers.cancelled_flag%TYPE;
1837: lh_transfer_status ota_finance_headers.transfer_status%TYPE;
1838: lh_object_version_number ota_finance_headers.object_version_number%TYPE;
1839: -- ------------------------
1840: -- other local Variables
1841: -- ------------------------

Line 1838: lh_object_version_number ota_finance_headers.object_version_number%TYPE;

1834: -- ------------------------
1835: lh_finance_header_id ota_finance_headers.finance_header_id%TYPE;
1836: lh_cancelled_flag ota_finance_headers.cancelled_flag%TYPE;
1837: lh_transfer_status ota_finance_headers.transfer_status%TYPE;
1838: lh_object_version_number ota_finance_headers.object_version_number%TYPE;
1839: -- ------------------------
1840: -- other local Variables
1841: -- ------------------------
1842: l_hours_until_class_starts NUMBER;

Line 1899: FROM ota_finance_headers flh,

1895: SELECT flh.finance_header_id finance_header_id,
1896: flh.cancelled_flag cancelled_flag,
1897: flh.transfer_status transfer_status,
1898: flh.object_version_number object_version_number
1899: FROM ota_finance_headers flh,
1900: ota_finance_lines fln
1901: WHERE flh.finance_header_id = fln.finance_header_id
1902: AND fln.booking_id = p_booking_id;
1903: