DBA Data[Home] [Help]

APPS.CSM_TXN_BILL_TYPES_EVENT_PKG dependencies on CS_BILLING_TYPE_CATEGORIES

Line 57: CS_BILLING_TYPE_CATEGORIES cbtc

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
59: AND acc.business_process_id = bpt.business_process_id
60: AND tbt.transaction_type_id = ttb.transaction_type_id
61: AND SYSDATE BETWEEN nvl(tbt.start_date_active, SYSDATE) AND nvl(tbt.end_date_active, SYSDATE)

Line 136: CS_BILLING_TYPE_CATEGORIES cbtc

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
137: where acc.txn_billing_type_id = tbt.txn_billing_type_id
138: AND acc.business_process_id = bpt.business_process_id
139: AND tbt.transaction_type_id = ttb.transaction_type_id
140: AND tbt.billing_type = cbtc.billing_type

Line 197: CS_BILLING_TYPE_CATEGORIES cbtc

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
199: AND SYSDATE BETWEEN nvl(tbt.start_date_active, SYSDATE) AND nvl(tbt.end_date_active, SYSDATE)
200: AND SYSDATE BETWEEN nvl(ttb.start_date_active, SYSDATE) AND nvl(ttb.end_date_active, SYSDATE)
201: AND SYSDATE BETWEEN nvl(bpr.start_date_active, SYSDATE) AND nvl(bpr.end_date_active, SYSDATE)