DBA Data[Home] [Help]

APPS.CSI_RMA_RECEIPT_PUB dependencies on HZ_CUST_ACCT_SITES_ALL

Line 494: hz_cust_acct_sites_all HCAS

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
498: WHEN no_data_found THEN