DBA Data[Home] [Help]

APPS.CS_CHARGE_DETAILS_PVT dependencies on CS_BILLING_TYPE_CATEGORIES

Line 13753: FROM cs_billing_type_categories bc,

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