APPS.HZ_ELOCATION_PKG dependencies on HZ_PARTY_SITE_USES

Line 330: FROM hz_party_site_uses hpsu,

326: SELECT hl.location_id, hl.address1, hl.address2, hl.address3, hl.address4,
327: hl.city, hl.postal_code, hl.state, hl.country, hl.county, hl.province
328: FROM hz_locations hl
329: WHERE EXISTS (SELECT 1
330: FROM hz_party_site_uses hpsu,
331: hz_party_sites hps
332: WHERE hpsu.site_use_type = p_site_use_type
333: AND hpsu.party_site_id = hps.party_site_id
334: AND hps.identifying_address_flag = DECODE(p_iden_addr_only, 'Y', 'Y', hps.identifying_address_flag)

Line 348: FROM hz_party_site_uses hpsu,

344: SELECT hl.location_id, hl.address1, hl.address2, hl.address3, hl.address4,
345: hl.city, hl.postal_code, hl.state, hl.country, hl.county, hl.province
346: FROM hz_locations hl
347: WHERE EXISTS (SELECT 1
348: FROM hz_party_site_uses hpsu,
349: hz_party_sites hps
350: WHERE hpsu.site_use_type = p_site_use_type
351: AND hpsu.party_site_id = hps.party_site_id
352: AND hps.identifying_address_flag = DECODE(p_iden_addr_only, 'Y', 'Y', hps.identifying_address_flag)

Line 366: FROM hz_party_site_uses hpsu,

362: SELECT hl.location_id, hl.address1, hl.address2, hl.address3, hl.address4,
363: hl.city, hl.postal_code, hl.state, hl.country, hl.county, hl.province
364: FROM hz_locations hl
365: WHERE EXISTS (SELECT 1
366: FROM hz_party_site_uses hpsu,
367: hz_party_sites hps
368: WHERE hpsu.site_use_type = p_site_use_type
369: AND hpsu.party_site_id = hps.party_site_id
370: AND hps.identifying_address_flag = DECODE(p_iden_addr_only, 'Y', 'Y', hps.identifying_address_flag)

Line 384: FROM hz_party_site_uses hpsu,

380: SELECT hl.location_id, hl.address1, hl.address2, hl.address3, hl.address4,
381: hl.city, hl.postal_code, hl.state, hl.country, hl.county, hl.province
382: FROM hz_locations hl
383: WHERE EXISTS (SELECT 1
384: FROM hz_party_site_uses hpsu,
385: hz_party_sites hps
386: WHERE hpsu.site_use_type = p_site_use_type
387: AND hpsu.party_site_id = hps.party_site_id
388: AND hps.identifying_address_flag = DECODE(p_iden_addr_only, 'Y', 'Y', hps.identifying_address_flag)