APPS.CSI_RMA_RECEIPT_PUB dependencies on HZ_CUST_SITE_USES_ALL

Line 494: FROM hz_cust_site_uses_all HCSU,

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