DBA Data[Home] [Help]

APPS.JG_ZZ_COMMON_PKG dependencies on XLE_JURISDICTIONS_B

Line 323: from XLE_REGISTRATIONS xler, XLE_JURISDICTIONS_B xlej, xle_entity_profiles xlee

319:
320: /* Added for GLOBE-006 ER*/
321: CURSOR lc_commercial_num IS
322: select nvl(xler.registration_number,'') commercial_number
323: from XLE_REGISTRATIONS xler, XLE_JURISDICTIONS_B xlej, xle_entity_profiles xlee
324: where xlej.JURISDICTION_ID= xler.JURISDICTION_ID
325: and xlej.LEGISLATIVE_CAT_CODE = 'COMMERCIAL_LAW'
326: AND xler.source_id = xlee.LEGAL_ENTITY_ID
327: AND xler.source_TABLE = 'XLE_ENTITY_PROFILES'