APPS.OTA_LEARNER_ENROLL_SS dependencies on OTA_FINANCE_HEADERS

Line 704: l_cancel_header_id ota_finance_headers.finance_header_id%TYPE;

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

Line 708: lh_finance_header_id ota_finance_headers.finance_header_id%TYPE;

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

Line 709: lh_cancelled_flag ota_finance_headers.cancelled_flag%TYPE;

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

Line 710: lh_transfer_status ota_finance_headers.transfer_status%TYPE;

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

Line 711: lh_object_version_number ota_finance_headers.object_version_number%TYPE;

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

Line 748: FROM OTA_FINANCE_HEADERS FLH,

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

Line 1831: l_cancel_header_id ota_finance_headers.finance_header_id%TYPE;

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

Line 1836: lh_finance_header_id ota_finance_headers.finance_header_id%TYPE;

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

Line 1837: lh_cancelled_flag ota_finance_headers.cancelled_flag%TYPE;

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

Line 1838: lh_transfer_status ota_finance_headers.transfer_status%TYPE;

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

Line 1839: lh_object_version_number ota_finance_headers.object_version_number%TYPE;

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

Line 1900: FROM ota_finance_headers flh,

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