APPS.AR_AUTOREC_API dependencies on HZ_CUSTOMER_PROFILES

Line 1685: FROM hz_customer_profiles cust_cp,

1681: nvl(nvl(site_cpa.auto_rec_min_receipt_amount,cust_cpa.auto_rec_min_receipt_amount),0)),
1682: p.payment_channel_code,
1683: u.instrument_id,
1684: mod(ct.paying_customer_id,:l_total_workers) + 1 worker_id
1685: FROM hz_customer_profiles cust_cp,
1686: hz_customer_profiles site_cp,
1687: hz_cust_profile_amts cust_cpa,
1688: hz_cust_profile_amts site_cpa,
1689: ra_customer_trx ct,

Line 1686: hz_customer_profiles site_cp,

1682: p.payment_channel_code,
1683: u.instrument_id,
1684: mod(ct.paying_customer_id,:l_total_workers) + 1 worker_id
1685: FROM hz_customer_profiles cust_cp,
1686: hz_customer_profiles site_cp,
1687: hz_cust_profile_amts cust_cpa,
1688: hz_cust_profile_amts site_cpa,
1689: ra_customer_trx ct,
1690: IBY_FNDCPT_TX_EXTENSIONS X,

Line 4277: From hz_customer_profiles cp,

4273: END IF;
4274:
4275: Select cpa.auto_rec_min_receipt_amount
4276: into l_cust_site_min_rec_amt
4277: From hz_customer_profiles cp,
4278: hz_cust_profile_amts cpa
4279: WHERE cp.cust_account_profile_id = cpa.cust_account_profile_id
4280: AND cpa.currency_code = l_currency_code
4281: AND cp.site_use_id = l_rcpt_info_tab(i).paying_site_use_id;