DBA Data[Home] [Help]

APPS.CSM_MTL_TXN_REASONS_EVENT_PKG dependencies on CSM_MTL_TXN_REASONS_ACC_S

Line 38: SELECT csm_mtl_txn_reasons_acc_s.nextval, reason_id

34: l_mark_dirty boolean;
35:
36: CURSOR l_ins_mtl_txn_reasons_csr(p_lastrundate IN date)
37: IS
38: SELECT csm_mtl_txn_reasons_acc_s.nextval, reason_id
39: FROM mtl_transaction_reasons
40: WHERE NVL(disable_date, SYSDATE) >= SYSDATE
41: AND last_update_date >= nvl(p_lastrundate, last_update_date )
42: AND ( reason_id ) NOT IN (