APPS.CS_CHARGE_DETAILS_PVT dependencies on CS_TXN_BILLING_TYPES

Line 13754: cs_txn_billing_types bt

13750: Cursor c_get_billing_flag(p_inv_id IN NUMBER,
13751: p_txn_type_id IN NUMBER) IS
13752: SELECT bc.billing_category
13753: FROM cs_billing_type_categories bc,
13754: cs_txn_billing_types bt
13755: WHERE sysdate between nvl(bc.start_date_active,sysdate)
13756: AND nvl(bc.end_date_active,sysdate)
13757: AND sysdate between nvl(bt.start_date_active,sysdate)
13758: AND nvl(bt.end_date_active,sysdate)

Line 13832: cs_txn_billing_types ctbt

13828: Cursor c_txn_billing_type(p_inventory_item_id IN NUMBER,
13829: p_txn_type_id IN NUMBER) IS
13830: SELECT ctbt.txn_billing_type_id
13831: FROM mtl_system_items_kfv kfv,
13832: cs_txn_billing_types ctbt
13833: WHERE kfv.inventory_item_id = p_inventory_item_id
13834: AND organization_id = cs_std.get_item_valdn_orgzn_id --
13835: AND ctbt.transaction_type_id = p_txn_type_id
13836: AND ctbt.billing_type = kfv.material_billable_flag;

Line 14971: from cs_txn_billing_oetxn_all tb, cs_txn_billing_types tt

14967:
14968: --Fixed Bug # 3325667 added p_org_id to procedure get_line_type
14969: CURSOR get_line_type_csr IS
14970: select tb.line_type_id
14971: from cs_txn_billing_oetxn_all tb, cs_txn_billing_types tt
14972: where tb.txn_billing_type_id = p_txn_billing_type_id
14973: and tb.txn_billing_type_id = tt.txn_billing_type_id and
14974: tb.org_id = p_org_id;
14975: