15: /*
16: This cursor is to fetch the Information regarding vendor change from JAI_RCV_CENVAT_CLAIMS.
17: */
18:
19: CURSOR c_fetch_vendor_info(cp_transaction_type rcv_transactions.transaction_type%type)
20: IS
21: SELECT
22: vendor_changed_flag ,
23: vendor_id ,
29: (
30: SELECT
31: transaction_id
32: FROM
33: rcv_transactions
34: WHERE
35: transaction_type = cp_transaction_type /* 'RECEIVE' --Ramananda for removal of SQL LITERALs */
36: START WITH
37: transaction_id = pr_new.receipt_ref