APPS.XLE_UTILITIES_GRP dependencies on HZ_PARTIES

Line 43: from hz_parties

39: reg.alternate_registered_name,
40: reg.identifying_flag identifying_flag,
41: jur.legislative_cat_code LEGISLATIVE_CATEGORY,
42: (select party_name
43: from hz_parties
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

Line 92: from hz_parties

88: reg.alternate_registered_name,
89: reg.identifying_flag identifying_flag,
90: jur.legislative_cat_code LEGISLATIVE_CATEGORY,
91: (select party_name
92: from hz_parties
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

Line 2321: from XLE_ETB_PROFILES etb, HZ_PARTIES parties

2317: where name = P_INTERFACE_VALUE;
2318:
2319: IF l_cnt = 0 THEN
2320: select etb.legal_entity_id into x_legal_entity_id
2321: from XLE_ETB_PROFILES etb, HZ_PARTIES parties
2322: where parties.party_name = P_INTERFACE_VALUE
2323: and parties.party_id = etb.party_id;
2324: ELSE
2325: select legal_entity_id into x_legal_entity_id