117: WHERE cust_trx_type_id = DECODE(parm_transaction_type,NULL, cust_trx_type_id,parm_transaction_type)
118: )
119: AND rct.bill_to_customer_id IN
120: (SELECT DISTINCT cust_account_id 121: FROM hz_customer_profiles 122: WHERE profile_class_id = DECODE(parm_profile_class_id,NULL, profile_class_id, parm_profile_class_id)
123: )
124: AND hzca.cust_account_id IN
125: (