DBA Data[Home] [Help]

APPS.AR_RECEIPT_VAL_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 267: FROM hz_cust_site_uses_all site_uses,

263: END IF;
264: BEGIN
265: SELECT site_uses.site_use_id
266: INTO l_dummy_cust.site_use_id
267: FROM hz_cust_site_uses_all site_uses,
268: hz_cust_acct_sites acct_site
269: WHERE acct_site.cust_account_id = p_customer_id
270: /*AND acct_site.status = 'A' Bug 4317815*/
271: AND acct_site.cust_acct_site_id =