DBA Data[Home] [Help]

APPS.AR_RECEIPT_VAL_PVT dependencies on HZ_CUST_SITE_USES_ALL

Line 266: FROM hz_cust_site_uses_all site_uses,

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