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