75: and transaction_header_id_out is null;
76:
77: CURSOR c_get_thid is
78: select fa_transaction_headers_s.nextval
79: from dual;
80:
81: CURSOR c_get_primary_thid is
82: select transaction_header_id
83: from fa_transaction_headers
777:
778:
779: CURSOR c_get_thid is
780: select fa_transaction_headers_s.nextval
781: from dual;
782:
783: CURSOR c_get_primary_thid is
784: select transaction_header_id
785: from fa_transaction_headers
2856: return boolean IS
2857:
2858: CURSOR c_get_thid is
2859: select fa_transaction_headers_s.nextval
2860: from dual;
2861:
2862: /* Bug - 7011548 Cursor Added to fetch Current value of the Sequence for MRC book.
2863: Earlier the Transaction_Header_id was missing for MRC Book. For MRC it
2864: is the Current Value of the Sequence.
2864: is the Current Value of the Sequence.
2865: */
2866: CURSOR c_get_thid_mrc is
2867: select fa_transaction_headers_s.currval
2868: from dual;
2869:
2870: CURSOR c_get_thx is
2871: select trx.transaction_date_entered
2872: , trx.last_update_date
3425: return boolean IS
3426:
3427: CURSOR c_get_thid is
3428: select fa_transaction_headers_s.nextval
3429: from dual;
3430:
3431: CURSOR c_get_thx is
3432: select trx.transaction_header_id
3433: , trx.transaction_date_entered