DBA Data[Home] [Help]

APPS.XLE_BUSINESSINFO_GRP dependencies on XLE_REGISTRATIONS

Line 1388: XLE_REGISTRATIONS reg,

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

Line 1413: XLE_REGISTRATIONS reg,

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