DBA Data[Home] [Help]

APPS.XLE_BUSINESSINFO_GRP dependencies on XLE_REGISTRATIONS

Line 1389: XLE_REGISTRATIONS reg,

1385:
1386: select ent.legal_entity_id
1387: into l_le_id
1388: from XLE_ENTITY_PROFILES ent,
1389: XLE_REGISTRATIONS reg,
1390: XLE_JURISDICTIONS_B jur
1391: where reg.REGISTRATION_NUMBER = P_REGISTRATION_NUMBER
1392: and REG.jurisdiction_id = jur.jurisdiction_id
1393: and REG.SOURCE_ID = ent.LEGAL_ENTITY_ID

Line 1414: XLE_REGISTRATIONS reg,

1410: BEGIN
1411: select etb.legal_entity_id
1412: BULK COLLECT into l_le_tbl
1413: from XLE_ETB_PROFILES etb,
1414: XLE_REGISTRATIONS reg,
1415: XLE_JURISDICTIONS_B jur
1416: where reg.REGISTRATION_NUMBER = P_REGISTRATION_NUMBER
1417: and REG.SOURCE_ID = etb.ESTABLISHMENT_ID
1418: and REG.jurisdiction_id = jur.jurisdiction_id