eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSP_CUSTOMER_ACCOUNT_PVT dependencies on HZ_CUST_PROFILE_AMTS

Line 199: hz_cust_profile_amts_s.nextval,

195:
196:
197: cursor c_prof_class_amts is
198: select
199: hz_cust_profile_amts_s.nextval,
200: x_customer_profile_id,
201: currency_code,
202: trx_credit_limit,
203: overall_credit_limit,

Line 373: delete from hz_cust_profile_amts

369: --
370: -- Delete only the profile_amounts that match the currency that is
371: -- present in the profile_amounts of the new customer profile class.
372: --
373: delete from hz_cust_profile_amts
374: where cust_account_profile_id = x_customer_profile_id
375: and currency_code in ( select currency_code
376: from hz_cust_prof_class_amts
377: where profile_class_id = x_customer_profile_class_id

Line 448: update hz_cust_profile_amts

444: x_return_status => x_return_status,
445: x_msg_count => x_msg_count,
446: x_msg_data => x_msg_data);
447:
448: update hz_cust_profile_amts
449: set site_use_id = null
450: where cust_acct_profile_amt_id = x_cust_acct_profile_amt_id
451: and site_use_id = -1;
452: