APPS.CSM_MTL_TXN_REASONS_EVENT_PKG dependencies on MTL_TRANSACTION_REASONS

Line 39: FROM mtl_transaction_reasons

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 (
43: SELECT reason_id

Line 51: , mtl_transaction_reasons mtr

47: CURSOR l_upd_mtl_txn_reasons_csr( p_lastrundate IN DATE)
48: IS
49: SELECT access_id
50: FROM csm_mtl_txn_reasons_acc acc
51: , mtl_transaction_reasons mtr
52: WHERE mtr.reason_id = acc.reason_id
53: AND NVL(disable_date, SYSDATE) >= SYSDATE
54: AND mtr.last_update_date >= p_lastrundate;
55:

Line 62: FROM mtl_transaction_reasons

58: SELECT access_id
59: FROM csm_mtl_txn_reasons_acc
60: WHERE reason_id IN
61: (SELECT reason_id
62: FROM mtl_transaction_reasons
63: WHERE last_update_date >= nvl(p_lastrundate, last_update_date)
64: AND NVL(disable_date, sysdate) < SYSDATE
65: )
66: UNION

Line 71: FROM mtl_transaction_reasons

67: SELECT access_id
68: FROM csm_mtl_txn_reasons_acc
69: WHERE reason_id NOT IN
70: (SELECT reason_id
71: FROM mtl_transaction_reasons
72: );
73:
74: CURSOR l_last_run_date_csr
75: IS

Line 82: TYPE reason_id_tbl_typ IS TABLE OF mtl_transaction_reasons.reason_id%TYPE INDEX BY BINARY_INTEGER;

78: WHERE package_name = 'CSM_MTL_TXN_REASONS_EVENT_PKG'
79: AND procedure_name = 'REFRESH_MTL_TXN_REASONS_ACC';
80:
81: TYPE access_id_tbl_typ IS TABLE OF csm_mtl_txn_reasons_acc.access_id%TYPE INDEX BY BINARY_INTEGER;
82: TYPE reason_id_tbl_typ IS TABLE OF mtl_transaction_reasons.reason_id%TYPE INDEX BY BINARY_INTEGER;
83:
84: l_access_id_tbl access_id_tbl_typ;
85: l_reason_id_tbl reason_id_tbl_typ;
86: