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;
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);
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