APPS.ARP_TRX_DEFAULTS_3 dependencies on HZ_PARTY_SITES

Line 81: hz_party_sites party_site,

77: loc.country
78: INTO pg_remit_to_address_rec
79: FROM ra_remit_tos rt,
80: hz_cust_acct_sites acct_site,
81: hz_party_sites party_site,
82: hz_locations loc
83: WHERE rt.state = 'DEFAULT'
84: AND rt.country = 'DEFAULT'
85: AND rt.address_id = acct_site.cust_acct_site_id

Line 193: hz_party_sites party_site,

189: loc.city, loc.state,
190: loc.province, loc.postal_code,
191: territory.territory_short_name --loc.country
192: FROM hz_cust_acct_sites acct_site,
193: hz_party_sites party_site,
194: hz_locations loc,
195: fnd_territories_vl territory,
196: ra_remit_tos rt
197: WHERE NVL( acct_site.status, 'A' ) = 'A'

Line 302: hz_party_sites party_site,

298: INTO l_match_state,
299: l_match_country,
300: l_match_postal_code
301: FROM hz_cust_acct_sites acct_site,
302: hz_party_sites party_site,
303: hz_locations loc
304: WHERE acct_site.cust_acct_site_id = p_match_address_id
305: AND acct_site.party_site_id = party_site.party_site_id
306: AND loc.location_id = party_site.location_id;

Line 329: hz_party_sites party_site,

325: INTO l_match_state,
326: l_match_country,
327: l_match_postal_code
328: FROM hz_cust_acct_sites acct_site,
329: hz_party_sites party_site,
330: hz_locations loc,
331: hz_cust_site_uses su
332: WHERE acct_site.cust_acct_site_id = su.cust_acct_site_id
333: AND su.site_use_id = p_match_site_use_id