APPS.AR_ARXCCS_XMLP_PKG dependencies on HZ_CUST_PROFILE_AMTS

Line 380: from hz_cust_profile_amts

376:
377: CURSOR C_CREDIT_LIMIT2 IS
378: select overall_credit_limit,
379: last_update_date
380: from hz_cust_profile_amts
381: where cust_account_profile_id = c_customer_profile_id
382: and currency_code = CP_limit_currency;
383:
384:

Line 881: from hz_cust_profile_amts cpa,

877:
878:
879: select count(*)
880: into ct_prof
881: from hz_cust_profile_amts cpa,
882: hz_customer_profiles cp
883: where cp.cust_account_id = customer_id
884: -- and cp.site_use_id = site_use_id
885: and cp.site_use_id = site_use_id_1

Line 3870: hz_cust_profile_amts where cust_account_id=p_cust_acct_id

3866: BEGIN
3867: l_ret_string:=NULL;
3868: l_cnt:=0;
3869: for i in (select distinct currency_code from
3870: hz_cust_profile_amts where cust_account_id=p_cust_acct_id
3871: and NVL(site_use_id,-9) = NVL(p_site_use_id,NVL(site_use_id,-9)))
3872: Loop
3873: l_cnt:=l_cnt+1;
3874: IF l_cnt=1 THEN NULL;