DBA Data[Home] [Help]

APPS.CS_CHARGE_DETAILS_PVT dependencies on CS_BILLING_TYPE_CATEGORIES

Line 15290: FROM cs_billing_type_categories bc,

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