APPS.POS_BATCH_IMPORT_PKG dependencies on HZ_LOCATIONS

Line 9011: hz_locations hzl,

9007: hzl.state, hzl.province, hzl.county, hzl.country, fvl.territory_short_name as country_name
9008: , hzl.city , hzl.postal_code*/
9009: INTO l_party_site_id
9010: FROM hz_party_sites hps,
9011: hz_locations hzl,
9012: fnd_territories_vl fvl
9013: WHERE hps.party_id = l_party_id
9014: AND hzl.location_id = hps.location_id
9015: AND hps.status = 'A'

Line 9023: ' Message: Get the party site id from hz_locations' ||

9019: END IF;
9020: END IF;
9021:
9022: fnd_file.put_line(fnd_file.log,
9023: ' Message: Get the party site id from hz_locations' ||
9024: ' party_site_id :' || l_party_site_id ||
9025: ' l_party_id : ' || l_party_id ||
9026: ' vendor_site_code : ' ||
9027: bank_account_dtls_rec.vendor_site_code ||