APPS.FTE_PROCESS_REQUESTS dependencies on HZ_CUST_SITE_USES_ALL

Line 147: FROM hz_cust_site_uses_all hcsu,

143: AND hps.party_site_id = hcas.party_site_id;
144:
145: CURSOR c_get_shipto_cust_from_site (p_site_id IN NUMBER) IS
146: SELECT distinct hcas.cust_account_id
147: FROM hz_cust_site_uses_all hcsu,
148: hz_cust_acct_sites_all hcas
149: WHERE hcsu.cust_acct_site_id = hcas.cust_acct_site_id
150: AND hcsu.site_use_id = p_site_id;
151: