2339:
2340: IF P_INTERFACE_ATTRIBUTE = 'LEGISLATIVE_CAT' THEN
2341:
2342: select ent.LEGAL_ENTITY_ID into x_legal_entity_id
2343: from XLE_ENTITY_PROFILES ent, XLE_JURISDICTIONS_B jur, XLE_REGISTRATIONS reg
2344: where jur.LEGISLATIVE_CAT_CODE = P_INTERFACE_VALUE
2345: and jur.JURISDICTION_ID = reg.JURISDICTION_ID
2346: and reg.SOURCE_ID = ent.LEGAL_ENTITY_ID;
2347:
2377:
2378: IF P_INTERFACE_ATTRIBUTE = 'GEOGRAPHY_ID' THEN
2379:
2380: select ent.LEGAL_ENTITY_ID into x_legal_entity_id
2381: from XLE_ENTITY_PROFILES ent, XLE_JURISDICTIONS_B jur, XLE_REGISTRATIONS reg
2382: where jur.GEOGRAPHY_ID = TO_NUMBER(P_INTERFACE_VALUE)
2383: and jur.JURISDICTION_ID = reg.JURISDICTION_ID
2384: and reg.SOURCE_ID = ent.LEGAL_ENTITY_ID;
2385: