DBA Data[Home] [Help]

APPS.AR_IREC_PAYMENTS dependencies on HZ_CUST_SITE_USES

Line 4500: FROM hz_cust_site_uses site_use,

4496: IF arp_global.sysparam.site_required_flag = 'Y' THEN
4497:
4498: BEGIN
4499: SELECT site_use.site_use_id into l_site_use_id
4500: FROM hz_cust_site_uses site_use,
4501: hz_cust_acct_sites acct_site
4502: WHERE acct_site.cust_account_id = p_customer_id
4503: AND acct_site.status = 'A'
4504: AND site_use.cust_acct_site_id = acct_site.cust_acct_site_id

Line 6772: hz_cust_site_uses hzcsite

6768:
6769: SELECT usite.customer_site_use_id
6770: INTO l_customer_site_use_id
6771: FROM ar_irec_user_acct_sites_all usite,
6772: hz_cust_site_uses hzcsite
6773: WHERE
6774: usite.session_id = p_session_id
6775: AND usite.customer_id = p_customer_id
6776: AND usite.user_id = FND_GLOBAL.user_id