APPS.JG_ZZ_SUMMARY_ALL_PKG dependencies on XLE_ENTITY_PROFILES

Line 162: AND xle_reg.source_table = 'XLE_ENTITY_PROFILES'

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'
163: AND xle_auth.legalauth_id (+) = xle_reg.issuing_authority_id
164: AND xle_reg.identifying_flag = 'Y'
165: AND xfpiv.legislative_cat_code = 'INCOME_TAX'
166: AND xfpiv.legal_entity_id = p_le_id;

Line 362: FROM xle_entity_profiles

358: END;
359: BEGIN
360: SELECT activity_code
361: INTO l_activity_code
362: FROM xle_entity_profiles
363: WHERE legal_entity_id = l_legal_entity_id;
364: EXCEPTION
365: WHEN NO_DATA_FOUND THEN
366: fnd_file.put_line(fnd_file.log,'Cannot find Activity Code (Standard Inductry Classification Code for Legal Entity:'||l_legal_entity_id);