DBA Data[Home] [Help]

APPS.JG_ZZ_SUMMARY_ALL_PKG dependencies on XLE_FIRSTPARTY_INFORMATION_V

Line 158: FROM XLE_FIRSTPARTY_INFORMATION_V xfpiv

154: CURSOR get_legal_auth_info(p_le_id number)
155: IS
156: SELECT xle_auth.city tax_office_location
157: ,xle_auth.address3 tax_office_code
158: FROM XLE_FIRSTPARTY_INFORMATION_V xfpiv
159: , xle_registrations xle_reg
160: , xle_legalauth_v xle_auth
161: WHERE xle_reg.source_id = xfpiv.legal_entity_id
162: AND xle_reg.source_table = 'XLE_ENTITY_PROFILES'