DBA Data[Home] [Help]

APPS.CSP_CUSTOMER_ACCOUNT_PVT dependencies on HZ_CUST_PROF_CLASS_AMTS

Line 281: from hz_cust_prof_class_amts

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

Line 410: from hz_cust_prof_class_amts

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