APPS.CS_SERVICE_BILLING_ENGINE_PVT dependencies on CS_TXN_BILLING_TYPES

Line 229: from cs_txn_billing_types ctbt, cs_billing_type_categories cbtc

225: and organization_id = cs_std.get_item_valdn_orgzn_id;
226:
227: Cursor txn_billing_type_csr(p_transaction_type_id number,p_billing_type varchar2) IS
228: Select ctbt.txn_billing_type_id
229: from cs_txn_billing_types ctbt, cs_billing_type_categories cbtc
230: where ctbt.transaction_type_id = p_transaction_type_id
231: and ctbt.billing_type = cbtc.billing_type
232: and cbtc.billing_type = p_billing_type; -- bug 14040051
233: /*

Line 236: from cs_txn_billing_types

232: and cbtc.billing_type = p_billing_type; -- bug 14040051
233: /*
234: Cursor txn_billing_type_csr(p_transaction_type_id number) IS
235: /*Select txn_billing_type_id
236: from cs_txn_billing_types
237: -where transaction_type_id = p_transaction_type_id
238: and billing_type = 'L';
239: Select ctbt.txn_billing_type_id
240: from cs_txn_billing_types ctbt, cs_billing_type_categories cbtc

Line 240: from cs_txn_billing_types ctbt, cs_billing_type_categories cbtc

236: from cs_txn_billing_types
237: -where transaction_type_id = p_transaction_type_id
238: and billing_type = 'L';
239: Select ctbt.txn_billing_type_id
240: from cs_txn_billing_types ctbt, cs_billing_type_categories cbtc
241: where ctbt.transaction_type_id = p_transaction_type_id
242: and ctbt.billing_type = cbtc.billing_type
243: and cbtc.billing_category = 'L';
244: */

Line 289: cs_txn_billing_types bt

285: -- bugfix#5443461
286: Cursor get_billing_category(p_txn_billing_type_id NUMBER) IS
287: SELECT bc.billing_category
288: FROM cs_billing_type_categories bc,
289: cs_txn_billing_types bt
290: WHERE bt.billing_type = bc.billing_type
291: AND bt.txn_billing_type_id = p_txn_billing_type_id;
292:
293: l_billing_category VARCHAR2(30);