APPS.FTE_PROCESS_REQUESTS dependencies on HZ_PARTY_SITES

Line 138: hz_party_sites hps,

134:
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