APPS.CS_SERVICE_BILLING_ENGINE_PVT dependencies on CS_BILLING_TYPE_CATEGORIES

Line 222: From mtl_system_items_kfv kfv, cs_billing_type_categories cbtc

218:
219: -- Bug 7229344
220: Cursor billing_category IS
221: Select cbtc.billing_category, cbtc.billing_type -- Bug 13247672
222: From mtl_system_items_kfv kfv, cs_billing_type_categories cbtc
223: Where kfv.inventory_item_id = p_sbe_record.inventory_item_id
224: and kfv.material_billable_flag = cbtc.billing_type
225: and organization_id = cs_std.get_item_valdn_orgzn_id;
226:

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 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 288: FROM cs_billing_type_categories bc,

284:
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: