APPS.CS_SERVICE_BILLING_ENGINE_PVT dependencies on CS_BILLING_TYPE_CATEGORIES

Line 221: From mtl_system_items_kfv kfv, cs_billing_type_categories cbtc

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

Line 228: from cs_txn_billing_types ctbt, cs_billing_type_categories cbtc

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

Line 239: from cs_txn_billing_types ctbt, cs_billing_type_categories cbtc

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

Line 287: FROM cs_billing_type_categories bc,

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