DBA Data[Home] [Help]

APPS.XLE_BUSINESSINFO_GRP dependencies on XLE_JURISDICTIONS_B

Line 1389: XLE_JURISDICTIONS_B jur

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
1393: and JUR.REGISTRATION_CODE_LE = nvl(l_registration_code,jur.registration_code_le);

Line 1414: XLE_JURISDICTIONS_B jur

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
1418: and JUR.REGISTRATION_CODE_ETB = nvl(l_registration_code,jur.registration_code_etb)