APPS.JG_ZZ_RTCE_DT_PKG dependencies on HZ_PARTIES

Line 55: -- , hz_parties hzp -- Bug 5522964

51: , xle_reg.issuing_authority_id
52: , xle_auth.party_id
53: FROM xle_firstparty_information_v xfpiv
54: , xle_registrations xle_reg
55: -- , hz_parties hzp -- Bug 5522964
56: , xle_legalauth_v xle_auth
57: WHERE xle_reg.source_id = xfpiv.legal_entity_id
58: AND xle_reg.source_table = 'XLE_ENTITY_PROFILES'
59: AND xle_auth.legalauth_id (+) = xle_reg.issuing_authority_id

Line 189: FROM hz_parties hzp

185: SELECT hzp.primary_phone_area_code
186: ||' '|| hzp.primary_phone_country_code
187: ||' '|| hzp.primary_phone_number phone_number
188: INTO gv_repent_phone_number
189: FROM hz_parties hzp
190: WHERE hzp.party_id = lv_party_id;
191: END IF;
192:
193: IF p_debug_flag = 'Y' THEN