DBA Data[Home] [Help]

APPS.JG_ZZ_SUMMARY_ALL_PKG dependencies on XLE_FIRSTPARTY_INFORMATION_V

Line 130: FROM XLE_FIRSTPARTY_INFORMATION_V xfpiv

126: CURSOR get_legal_auth_info(p_le_id number)
127: IS
128: SELECT xle_auth.city tax_office_location
129: ,xle_auth.address3 tax_office_code
130: FROM XLE_FIRSTPARTY_INFORMATION_V xfpiv
131: , xle_registrations xle_reg
132: , xle_legalauth_v xle_auth
133: WHERE xle_reg.source_id = xfpiv.legal_entity_id
134: AND xle_reg.source_table = 'XLE_ENTITY_PROFILES'