APPS.JAI_JRG_PLA_TRIGGER_PKG dependencies on RCV_TRANSACTIONS

Line 18: CURSOR c_fetch_vendor_info(cp_transaction_type IN rcv_transactions.transaction_type%type)

14: /*
15: This cursor is to fetch the Information regarding vendor change from JAI_RCV_CENVAT_CLAIMS.
16: */
17:
18: CURSOR c_fetch_vendor_info(cp_transaction_type IN rcv_transactions.transaction_type%type)
19: IS
20: SELECT
21: vendor_changed_flag ,
22: vendor_id ,

Line 32: rcv_transactions

28: (
29: SELECT
30: transaction_id
31: FROM
32: rcv_transactions
33: WHERE
34: transaction_type = cp_transaction_type /* 'RECEIVE' --Ramananda for removal of SQL LITERALs */
35: START WITH
36: transaction_id = pr_new.ref_document_id