APPS.CSI_RMA_RECEIPT_PUB dependencies on HZ_CUST_SITE_USES_ALL

Line 493: FROM hz_cust_site_uses_all HCSU,

489: IF l_cust_acct_site_use_id IS NOT NULL THEN
490: BEGIN
491: SELECT HCAS.party_site_id
492: INTO x_src_order_rec.customer_location_id
493: FROM hz_cust_site_uses_all HCSU,
494: hz_cust_acct_sites_all HCAS
495: WHERE HCSU.site_use_id = l_cust_acct_site_use_id
496: AND HCAS.cust_acct_site_id = HCSU.cust_acct_site_id;
497: EXCEPTION