DBA Data[Home] [Help]

APPS.XLE_UTILITIES_GRP dependencies on XLE_JURISDICTIONS_B

Line 2343: from XLE_ENTITY_PROFILES ent, XLE_JURISDICTIONS_B jur, XLE_REGISTRATIONS reg

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:

Line 2381: from XLE_ENTITY_PROFILES ent, XLE_JURISDICTIONS_B jur, XLE_REGISTRATIONS reg

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: