DBA Data[Home] [Help]

APPS.CSM_TXN_BILL_TYPES_EVENT_PKG dependencies on CS_BUSINESS_PROCESSES

Line 55: cs_business_processes bpr,

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
59: AND acc.business_process_id = bpt.business_process_id

Line 134: cs_business_processes bpr,

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
137: where acc.txn_billing_type_id = tbt.txn_billing_type_id
138: AND acc.business_process_id = bpt.business_process_id

Line 195: cs_business_processes bpr,

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