DBA Data[Home] [Help]

APPS.JG_ZZ_SUMMARY_ALL_PKG dependencies on XLE_ENTITY_PROFILES

Line 134: AND xle_reg.source_table = 'XLE_ENTITY_PROFILES'

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'
135: AND xle_auth.legalauth_id (+) = xle_reg.issuing_authority_id
136: AND xle_reg.identifying_flag = 'Y'
137: AND xfpiv.legislative_cat_code = 'INCOME_TAX'
138: AND xfpiv.legal_entity_id = p_le_id;

Line 293: FROM xle_entity_profiles

289: END;
290: BEGIN
291: SELECT activity_code
292: INTO l_activity_code
293: FROM xle_entity_profiles
294: WHERE legal_entity_id = l_legal_entity_id;
295: EXCEPTION
296: WHEN NO_DATA_FOUND THEN
297: fnd_file.put_line(fnd_file.log,'Cannot find Activity Code (Standard Inductry Classification Code for Legal Entity:'||l_legal_entity_id);