DBA Data[Home] [Help]

APPS.OTA_CANCEL_API dependencies on OTA_FINANCE_HEADERS

Line 440: l_header_ovn ota_finance_headers.object_version_number%type;

436: l_Sequence_Number ota_finance_lines.sequence_number%type;
437: l_Date_raised ota_finance_lines.date_raised%type;
438:
439: -- Define local variable for header;
440: l_header_ovn ota_finance_headers.object_version_number%type;
441: l_header_Transfer_status ota_finance_headers.transfer_status%type;
442: -- Define local variable for other
443: l_auto_waitlist varchar2(1);
444: l_sysdate date;

Line 441: l_header_Transfer_status ota_finance_headers.transfer_status%type;

437: l_Date_raised ota_finance_lines.date_raised%type;
438:
439: -- Define local variable for header;
440: l_header_ovn ota_finance_headers.object_version_number%type;
441: l_header_Transfer_status ota_finance_headers.transfer_status%type;
442: -- Define local variable for other
443: l_auto_waitlist varchar2(1);
444: l_sysdate date;
445: l_count number(6);

Line 525: ota_finance_headers

521: SELECT
522: Object_version_number,
523: Transfer_status
524: FROM
525: ota_finance_headers
526: WHERE
527: finance_header_id = l_finance_header_id;
528:
529: -- define caount finance line cursor