DBA Data[Home] [Help]

APPS.CS_SERVICE_BILLING_ENGINE_PVT dependencies on CS_STD

Line 22: and organization_id = cs_std.get_item_valdn_orgzn_id;

18: Cursor uom_csr(p_inventory_item_id number) IS
19: Select primary_uom_code
20: from mtl_system_items_kfv
21: where inventory_item_id = p_inventory_item_id
22: and organization_id = cs_std.get_item_valdn_orgzn_id;
23:
24: BEGIN
25: OPEN uom_csr(p_inventory_item_id);
26: FETCH uom_csr INTO x_unit_of_measure_code;

Line 224: and organization_id = cs_std.get_item_valdn_orgzn_id;

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