eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_TXN_BILL_TYPES_EVENT_PKG dependencies on CS_TRANSACTION_TYPES_B

Line 54: cs_transaction_types_b ttb,

50: FROM CSM_TXN_BILLING_TYPES_ACC acc
51: WHERE NOT EXISTS
52: (select tbt.TXN_BILLING_TYPE_ID
53: from cs_txn_billing_types tbt,
54: cs_transaction_types_b ttb,
55: cs_business_processes bpr,
56: cs_bus_process_txns bpt,
57: CS_BILLING_TYPE_CATEGORIES cbtc
58: where acc.txn_billing_type_id = tbt.txn_billing_type_id

Line 75: CURSOR l_txn_types_tl_cur (p_transaction_type_id IN cs_transaction_types_b.transaction_type_id%TYPE)

71: );
72:
73: l_temp_date date;
74:
75: CURSOR l_txn_types_tl_cur (p_transaction_type_id IN cs_transaction_types_b.transaction_type_id%TYPE)
76: IS
77: SELECT tt_tl.LANGUAGE
78: FROM cs_transaction_types_tl tt_tl
79: WHERE tt_tl.transaction_type_id = p_transaction_type_id;

Line 132: cs_transaction_types_b ttb,

128: --generate sql for updates
129: l_dsql := 'select acc.access_id, tt_tl.language
130: from csm_txn_billing_types_acc acc,
131: cs_txn_billing_types tbt,
132: cs_transaction_types_b ttb,
133: cs_transaction_types_tl tt_tl,
134: cs_business_processes bpr,
135: cs_bus_process_txns bpt,
136: CS_BILLING_TYPE_CATEGORIES cbtc

Line 194: cs_transaction_types_b ttb,

190: /****** INSERTS **********/
191: --generate sql for inserts
192: l_dsql := 'select tbt.TXN_BILLING_TYPE_ID, bpt.business_process_id, tbt.transaction_type_id
193: from cs_txn_billing_types tbt,
194: cs_transaction_types_b ttb,
195: cs_business_processes bpr,
196: cs_bus_process_txns bpt,
197: CS_BILLING_TYPE_CATEGORIES cbtc
198: where tbt.transaction_type_id = ttb.transaction_type_id