1384:
1385: select ent.legal_entity_id
1386: into l_le_id
1387: from XLE_ENTITY_PROFILES ent,
1388: XLE_REGISTRATIONS reg,
1389: XLE_JURISDICTIONS_B jur
1390: where reg.REGISTRATION_NUMBER = P_REGISTRATION_NUMBER
1391: and REG.jurisdiction_id = jur.jurisdiction_id
1392: and REG.SOURCE_ID = ent.LEGAL_ENTITY_ID
1409: BEGIN
1410: select etb.legal_entity_id
1411: BULK COLLECT into l_le_tbl
1412: from XLE_ETB_PROFILES etb,
1413: XLE_REGISTRATIONS reg,
1414: XLE_JURISDICTIONS_B jur
1415: where reg.REGISTRATION_NUMBER = P_REGISTRATION_NUMBER
1416: and REG.SOURCE_ID = etb.ESTABLISHMENT_ID
1417: and REG.jurisdiction_id = jur.jurisdiction_id