APPS.JG_ZZ_RTCE_DT_PKG dependencies on XLE_LEGALAUTH_V

Line 56: , xle_legalauth_v xle_auth

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
60: AND xle_reg.identifying_flag = 'Y'