APPS.JAI_JRG_23AC2_TRIGGER_PKG dependencies on RCV_TRANSACTIONS
Line 19: CURSOR c_fetch_vendor_info(cp_transaction_type rcv_transactions.transaction_type%type)
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 ,
Line 33: rcv_transactions
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