APPS.FV_1099_TRANSACTION dependencies on HZ_PARTY_SITES

Line 170: FROM hz_locations hzl, hz_cust_acct_sites hzcas, hz_party_sites hzps

166: SELECT address1, address2, address3, address4, city, state,
167: postal_code, country, province
168: INTO v_address1, v_address2, v_address3, v_address4, v_city,
169: v_state, v_postal_code, v_country, v_province
170: FROM hz_locations hzl, hz_cust_acct_sites hzcas, hz_party_sites hzps
171: WHERE hzcas.cust_account_id = v_customer_id
172: AND hzcas.party_site_id = hzps.party_site_id
173: AND hzps.location_id = hzl.location_id;
174: