APPS.CS_CHARGE_DETAILS_PVT dependencies on CS_TXN_BILLING_TYPES

Line 15291: cs_txn_billing_types bt

15287: Cursor c_get_billing_flag(p_inv_id IN NUMBER,
15288: p_txn_type_id IN NUMBER) IS
15289: SELECT bc.billing_category
15290: FROM cs_billing_type_categories bc,
15291: cs_txn_billing_types bt
15292: WHERE sysdate between nvl(bc.start_date_active,sysdate)
15293: AND nvl(bc.end_date_active,sysdate)
15294: AND sysdate between nvl(bt.start_date_active,sysdate)
15295: AND nvl(bt.end_date_active,sysdate)

Line 15369: cs_txn_billing_types ctbt

15365: Cursor c_txn_billing_type(p_inventory_item_id IN NUMBER,
15366: p_txn_type_id IN NUMBER) IS
15367: SELECT ctbt.txn_billing_type_id
15368: FROM mtl_system_items_kfv kfv,
15369: cs_txn_billing_types ctbt
15370: WHERE kfv.inventory_item_id = p_inventory_item_id
15371: AND organization_id = cs_std.get_item_valdn_orgzn_id --
15372: AND ctbt.transaction_type_id = p_txn_type_id
15373: AND ctbt.billing_type = kfv.material_billable_flag;

Line 16542: from cs_txn_billing_oetxn_all tb, cs_txn_billing_types tt

16538:
16539: --Fixed Bug # 3325667 added p_org_id to procedure get_line_type
16540: CURSOR get_line_type_csr IS
16541: select tb.line_type_id
16542: from cs_txn_billing_oetxn_all tb, cs_txn_billing_types tt
16543: where tb.txn_billing_type_id = p_txn_billing_type_id
16544: and tb.txn_billing_type_id = tt.txn_billing_type_id and
16545: tb.org_id = p_org_id;
16546: