277: PENALTY_RATE,
278: MIN_INTEREST_CHARGE,
279: PENALTY_FIXED_AMOUNT,
280: PENALTY_SCHEDULE_ID
281: from hz_cust_prof_class_amts
282: where profile_class_id = x_customer_profile_class_id;
283:
284: --
285: begin
406: --
407: delete from hz_cust_profile_amts
408: where cust_account_profile_id = x_customer_profile_id
409: and currency_code in ( select currency_code
410: from hz_cust_prof_class_amts
411: where profile_class_id = x_customer_profile_class_id
412: );
413: --
414: -- copy profile amount records from class to customer profile