APPS.XLE_UTILITIES_GRP dependencies on HZ_PARTY_SITES

Line 48: from hz_locations hzl, hz_party_sites hps

44: where party_id = reg.issuing_authority_id) LEGALAUTH_NAME,
45: (select hzl.address1 || ' ' || hzl.address2 || ' '
46: || hzl.city || ',' || hzl.state
47: || ',' || hzl.country || ' ' || hzl.postal_code
48: from hz_locations hzl, hz_party_sites hps
49: where hps.location_id = hzl.location_id
50: and hps.party_site_id = reg.issuing_authority_site_id) LEGALAUTH_ADDRESS,
51: reg.effective_from,
52: reg.effective_to,

Line 97: from hz_locations hzl, hz_party_sites hps

93: where party_id = reg.issuing_authority_id) LEGALAUTH_NAME,
94: (select hzl.address1 || ' ' || hzl.address2 || ' '
95: || hzl.city || ',' || hzl.state
96: || ',' || hzl.country || ' ' || hzl.postal_code
97: from hz_locations hzl, hz_party_sites hps
98: where hps.location_id = hzl.location_id
99: and hps.party_site_id = reg.issuing_authority_site_id) LEGALAUTH_ADDRESS,
100: reg.effective_from,
101: reg.effective_to,