APPS.FTE_PROCESS_REQUESTS dependencies on HZ_CUST_ACCT_SITES_ALL

Line 139: hz_cust_acct_sites_all hcas

135: CURSOR c_get_shipto_cust_from_loc (p_location_id IN NUMBER) IS
136: SELECT hcas.cust_account_id
137: FROM wsh_locations wl,
138: hz_party_sites hps,
139: hz_cust_acct_sites_all hcas
140: WHERE wl.wsh_location_id = p_location_id
141: AND wl.location_source_code = 'HZ'
142: AND wl.source_location_id = hps.location_id
143: AND hps.party_site_id = hcas.party_site_id;

Line 148: hz_cust_acct_sites_all hcas

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:
152: l_cust_tab WSH_UTIL_CORE.ID_TAB_TYPE;