DBA Data[Home] [Help]

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