eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLE_UTILITIES_GRP dependencies on XLE_ENTITY_PROFILES

Line 11: P_PARTY_ID IN XLE_ENTITY_PROFILES.PARTY_ID%TYPE,

7: PROCEDURE Get_Registration_Info(
8: x_return_status OUT NOCOPY VARCHAR2,
9: x_msg_count OUT NOCOPY NUMBER,
10: x_msg_data OUT NOCOPY VARCHAR2,
11: P_PARTY_ID IN XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
12: P_ENTITY_ID IN XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE,
13: P_ENTITY_TYPE IN VARCHAR2,
14: P_identifying_flag IN VARCHAR2,
15: P_LEGISLATIVE_CATEGORY IN VARCHAR2,

Line 12: P_ENTITY_ID IN XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE,

8: x_return_status OUT NOCOPY VARCHAR2,
9: x_msg_count OUT NOCOPY NUMBER,
10: x_msg_data OUT NOCOPY VARCHAR2,
11: P_PARTY_ID IN XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
12: P_ENTITY_ID IN XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE,
13: P_ENTITY_TYPE IN VARCHAR2,
14: P_identifying_flag IN VARCHAR2,
15: P_LEGISLATIVE_CATEGORY IN VARCHAR2,
16: X_REGISTRATION_INFO OUT NOCOPY Registration_Tbl_Type

Line 63: FROM XLE_ENTITY_PROFILES lep,

59: hrl.region_2,
60: hrl.region_3,
61: hrl.postal_code,
62: hrl.country
63: FROM XLE_ENTITY_PROFILES lep,
64: XLE_REGISTRATIONS reg,
65: HR_LOCATIONS_ALL hrl,
66: XLE_JURISDICTIONS_VL jur
67: WHERE

Line 69: AND reg.source_table = 'XLE_ENTITY_PROFILES'

65: HR_LOCATIONS_ALL hrl,
66: XLE_JURISDICTIONS_VL jur
67: WHERE
68: lep.legal_entity_id = reg.source_id
69: AND reg.source_table = 'XLE_ENTITY_PROFILES'
70: AND hrl.location_id = reg.location_id
71: AND jur.jurisdiction_id = reg.jurisdiction_id
72: AND lep.party_ID like l_party_ID
73: AND lep.legal_entity_id like l_entity_ID

Line 303: P_PARTY_ID IN XLE_ENTITY_PROFILES.PARTY_ID%TYPE,

299: PROCEDURE Get_Establishment_Info(
300: x_return_status OUT NOCOPY VARCHAR2 ,
301: x_msg_count OUT NOCOPY NUMBER ,
302: x_msg_data OUT NOCOPY VARCHAR2 ,
303: P_PARTY_ID IN XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
304: p_establishment_id IN XLE_ETB_PROFILES.ESTABLISHMENT_ID%TYPE,
305: p_legalentity_id IN XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
306: p_etb_reg IN VARCHAR2,
307: X_ESTABLISHMENT_INFO OUT NOCOPY Establishment_Tbl_Type

Line 305: p_legalentity_id IN XLE_ENTITY_PROFILES.legal_entity_id%TYPE,

301: x_msg_count OUT NOCOPY NUMBER ,
302: x_msg_data OUT NOCOPY VARCHAR2 ,
303: P_PARTY_ID IN XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
304: p_establishment_id IN XLE_ETB_PROFILES.ESTABLISHMENT_ID%TYPE,
305: p_legalentity_id IN XLE_ENTITY_PROFILES.legal_entity_id%TYPE,
306: p_etb_reg IN VARCHAR2,
307: X_ESTABLISHMENT_INFO OUT NOCOPY Establishment_Tbl_Type
308: )
309: AS

Line 549: P_PARTY_ID IN XLE_ENTITY_PROFILES.PARTY_ID%TYPE,

545: PROCEDURE Get_LegalEntity_Info(
546: x_return_status OUT NOCOPY VARCHAR2 ,
547: x_msg_count OUT NOCOPY NUMBER ,
548: x_msg_data OUT NOCOPY VARCHAR2 ,
549: P_PARTY_ID IN XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
550: P_LegalEntity_ID IN XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE,
551: X_LEGALENTITY_INFO OUT NOCOPY LegalEntity_Rec
552: )
553: AS

Line 550: P_LegalEntity_ID IN XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE,

546: x_return_status OUT NOCOPY VARCHAR2 ,
547: x_msg_count OUT NOCOPY NUMBER ,
548: x_msg_data OUT NOCOPY VARCHAR2 ,
549: P_PARTY_ID IN XLE_ENTITY_PROFILES.PARTY_ID%TYPE,
550: P_LegalEntity_ID IN XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE,
551: X_LEGALENTITY_INFO OUT NOCOPY LegalEntity_Rec
552: )
553: AS
554: party_id NUMBER;

Line 559: l_legalentity_name xle_entity_profiles.name%type;

555: legalentity_id NUMBER;
556:
557: l_party_ID number;
558: l_legal_entity_id number;
559: l_legalentity_name xle_entity_profiles.name%type;
560: l_legal_identifier xle_entity_profiles.legal_entity_identifier%type;
561: l_transacting_flag xle_entity_profiles.transacting_entity_flag%type;
562: l_activity_code xle_entity_profiles.activity_code%type;
563: l_type_of_company xle_entity_profiles.type_of_company%type;

Line 560: l_legal_identifier xle_entity_profiles.legal_entity_identifier%type;

556:
557: l_party_ID number;
558: l_legal_entity_id number;
559: l_legalentity_name xle_entity_profiles.name%type;
560: l_legal_identifier xle_entity_profiles.legal_entity_identifier%type;
561: l_transacting_flag xle_entity_profiles.transacting_entity_flag%type;
562: l_activity_code xle_entity_profiles.activity_code%type;
563: l_type_of_company xle_entity_profiles.type_of_company%type;
564: l_sub_activity_code xle_entity_profiles.sub_activity_code%type;

Line 561: l_transacting_flag xle_entity_profiles.transacting_entity_flag%type;

557: l_party_ID number;
558: l_legal_entity_id number;
559: l_legalentity_name xle_entity_profiles.name%type;
560: l_legal_identifier xle_entity_profiles.legal_entity_identifier%type;
561: l_transacting_flag xle_entity_profiles.transacting_entity_flag%type;
562: l_activity_code xle_entity_profiles.activity_code%type;
563: l_type_of_company xle_entity_profiles.type_of_company%type;
564: l_sub_activity_code xle_entity_profiles.sub_activity_code%type;
565: l_le_effective_from xle_entity_profiles.effective_from%type;

Line 562: l_activity_code xle_entity_profiles.activity_code%type;

558: l_legal_entity_id number;
559: l_legalentity_name xle_entity_profiles.name%type;
560: l_legal_identifier xle_entity_profiles.legal_entity_identifier%type;
561: l_transacting_flag xle_entity_profiles.transacting_entity_flag%type;
562: l_activity_code xle_entity_profiles.activity_code%type;
563: l_type_of_company xle_entity_profiles.type_of_company%type;
564: l_sub_activity_code xle_entity_profiles.sub_activity_code%type;
565: l_le_effective_from xle_entity_profiles.effective_from%type;
566: l_le_effective_to xle_entity_profiles.effective_to%type;

Line 563: l_type_of_company xle_entity_profiles.type_of_company%type;

559: l_legalentity_name xle_entity_profiles.name%type;
560: l_legal_identifier xle_entity_profiles.legal_entity_identifier%type;
561: l_transacting_flag xle_entity_profiles.transacting_entity_flag%type;
562: l_activity_code xle_entity_profiles.activity_code%type;
563: l_type_of_company xle_entity_profiles.type_of_company%type;
564: l_sub_activity_code xle_entity_profiles.sub_activity_code%type;
565: l_le_effective_from xle_entity_profiles.effective_from%type;
566: l_le_effective_to xle_entity_profiles.effective_to%type;
567:

Line 564: l_sub_activity_code xle_entity_profiles.sub_activity_code%type;

560: l_legal_identifier xle_entity_profiles.legal_entity_identifier%type;
561: l_transacting_flag xle_entity_profiles.transacting_entity_flag%type;
562: l_activity_code xle_entity_profiles.activity_code%type;
563: l_type_of_company xle_entity_profiles.type_of_company%type;
564: l_sub_activity_code xle_entity_profiles.sub_activity_code%type;
565: l_le_effective_from xle_entity_profiles.effective_from%type;
566: l_le_effective_to xle_entity_profiles.effective_to%type;
567:
568: l_index NUMBER := 1;

Line 565: l_le_effective_from xle_entity_profiles.effective_from%type;

561: l_transacting_flag xle_entity_profiles.transacting_entity_flag%type;
562: l_activity_code xle_entity_profiles.activity_code%type;
563: l_type_of_company xle_entity_profiles.type_of_company%type;
564: l_sub_activity_code xle_entity_profiles.sub_activity_code%type;
565: l_le_effective_from xle_entity_profiles.effective_from%type;
566: l_le_effective_to xle_entity_profiles.effective_to%type;
567:
568: l_index NUMBER := 1;
569:

Line 566: l_le_effective_to xle_entity_profiles.effective_to%type;

562: l_activity_code xle_entity_profiles.activity_code%type;
563: l_type_of_company xle_entity_profiles.type_of_company%type;
564: l_sub_activity_code xle_entity_profiles.sub_activity_code%type;
565: l_le_effective_from xle_entity_profiles.effective_from%type;
566: l_le_effective_to xle_entity_profiles.effective_to%type;
567:
568: l_index NUMBER := 1;
569:
570: l_registration_info XLE_UTILITIES_GRP.Registration_Tbl_Type;

Line 618: FROM XLE_ENTITY_PROFILES lep

614: l_sub_activity_code,
615: l_type_of_company,
616: l_le_effective_from,
617: l_le_effective_to
618: FROM XLE_ENTITY_PROFILES lep
619: WHERE lep.legal_entity_id = p_legalentity_id;
620:
621: ELSIF p_legalentity_id IS NULL and p_party_ID IS NOT null THEN
622:

Line 643: FROM XLE_ENTITY_PROFILES lep

639: l_sub_activity_code,
640: l_type_of_company,
641: l_le_effective_from,
642: l_le_effective_to
643: FROM XLE_ENTITY_PROFILES lep
644: WHERE lep.party_ID = p_party_id;
645:
646:
647: ELSE

Line 669: FROM XLE_ENTITY_PROFILES lep

665: l_sub_activity_code,
666: l_type_of_company,
667: l_le_effective_from,
668: l_le_effective_to
669: FROM XLE_ENTITY_PROFILES lep
670: WHERE lep.party_ID = p_party_id
671: and lep.legal_entity_id = p_legalentity_id;
672:
673: END IF;

Line 753: P_ENTITY_ID IN XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE,

749: PROCEDURE Get_History_Info(
750: x_return_status OUT NOCOPY VARCHAR2 ,
751: x_msg_count OUT NOCOPY NUMBER ,
752: x_msg_data OUT NOCOPY VARCHAR2 ,
753: P_ENTITY_ID IN XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE,
754: P_ENTITY_TYPE IN VARCHAR2,
755: P_EFFECTIVE_DATE IN VARCHAR2,
756: X_HISTORY_INFO OUT NOCOPY History_Tbl_Type
757: )

Line 810: l_source_table := 'XLE_ENTITY_PROFILES';

806: return;
807: END IF;
808:
809: IF P_ENTITY_TYPE = 'LEGAL_ENTITY' THEN
810: l_source_table := 'XLE_ENTITY_PROFILES';
811: ELSIF P_ENTITY_TYPE = 'ESTABLISHMENT' THEN
812: l_source_table := 'XLE_ETB_PROFILES';
813: ELSIF P_ENTITY_TYPE = 'REGISTRATIONS' THEN
814: l_source_table := 'XLE_REGISTRATIONS';

Line 919: l_legal_entity_id XLE_ENTITY_PROFILES.legal_entity_id%TYPE;

915: l_api_name CONSTANT VARCHAR2(30):= 'Get_LegalEntityID_OU';
916: l_api_version CONSTANT NUMBER:= 1.0;
917: l_ledger_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE;
918: l_le_list GL_MC_INFO.LE_BSV_TBL_TYPE := gl_mc_info.le_bsv_tbl_type();
919: l_legal_entity_id XLE_ENTITY_PROFILES.legal_entity_id%TYPE;
920: l_index NUMBER := 0;
921: l_ledger_flag BOOLEAN;
922:
923: l_init_msg_list VARCHAR2(100);

Line 1008: FROM XLE_ENTITY_PROFILES lep

1004: -- Waiting for Ledger API.
1005:
1006: SELECT lep.name
1007: INTO x_legal_entity_name
1008: FROM XLE_ENTITY_PROFILES lep
1009: WHERE lep.party_id=p_party_id;
1010:
1011: -- End of API body.
1012: -- Standard call to get message count and if count is 1, get message info.

Line 1073: l_legal_entity_id XLE_ENTITY_PROFILES.legal_entity_id%TYPE;

1069: l_api_name CONSTANT VARCHAR2(30):= 'Get_FP_CountryCode_LID';
1070: l_api_version CONSTANT NUMBER:= 1.0;
1071: l_ledger_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE;
1072: l_le_list GL_MC_INFO.LE_BSV_TBL_TYPE := gl_mc_info.le_bsv_tbl_type();
1073: l_legal_entity_id XLE_ENTITY_PROFILES.legal_entity_id%TYPE;
1074: l_index NUMBER;
1075: l_ledger_flag BOOLEAN;
1076: l_country_code HZ_GEOGRAPHIES.COUNTRY_CODE%TYPE;
1077:

Line 1127: FROM XLE_ENTITY_PROFILES lep,

1123: l_legal_entity_id := l_le_list(x).legal_entity_id;
1124:
1125: SELECT DISTINCT hrl.country
1126: INTO l_country_code
1127: FROM XLE_ENTITY_PROFILES lep,
1128: HR_LOCATIONS_ALL hrl,
1129: XLE_REGISTRATIONS reg
1130: WHERE lep.legal_entity_id = l_legal_entity_id
1131: AND reg.source_id = lep.legal_entity_id

Line 1132: AND reg.source_table = 'XLE_ENTITY_PROFILES'

1128: HR_LOCATIONS_ALL hrl,
1129: XLE_REGISTRATIONS reg
1130: WHERE lep.legal_entity_id = l_legal_entity_id
1131: AND reg.source_id = lep.legal_entity_id
1132: AND reg.source_table = 'XLE_ENTITY_PROFILES'
1133: AND reg.location_id = hrl.location_id;
1134:
1135:
1136: FOR i IN 1..l_index loop

Line 1215: l_legal_entity_id XLE_ENTITY_PROFILES.legal_entity_id%TYPE;

1211: l_api_name CONSTANT VARCHAR2(30):= 'Get_FP_CountryCode_OU';
1212: l_api_version CONSTANT NUMBER:= 1.0;
1213: l_ledger_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE;
1214: l_le_list GL_MC_INFO.LE_BSV_TBL_TYPE;
1215: l_legal_entity_id XLE_ENTITY_PROFILES.legal_entity_id%TYPE;
1216: l_index NUMBER;
1217: l_ledger_flag BOOLEAN;
1218: l_country_code HZ_GEOGRAPHIES.COUNTRY_CODE%TYPE;
1219:

Line 1261: FROM XLE_ENTITY_PROFILES xlep,

1257:
1258: IF l_legal_entity_id IS NOT NULL THEN
1259: SELECT hrl.country
1260: INTO x_country_code
1261: FROM XLE_ENTITY_PROFILES xlep,
1262: XLE_REGISTRATIONS reg,
1263: HR_LOCATIONS_ALL hrl
1264: WHERE xlep.legal_entity_id = reg.source_id
1265: AND reg.source_table = 'XLE_ENTITY_PROFILES'

Line 1265: AND reg.source_table = 'XLE_ENTITY_PROFILES'

1261: FROM XLE_ENTITY_PROFILES xlep,
1262: XLE_REGISTRATIONS reg,
1263: HR_LOCATIONS_ALL hrl
1264: WHERE xlep.legal_entity_id = reg.source_id
1265: AND reg.source_table = 'XLE_ENTITY_PROFILES'
1266: AND reg.identifying_flag = 'Y'
1267: AND nvl(reg.effective_from,sysdate) <= sysdate
1268: AND nvl(reg.effective_to, sysdate) >= sysdate
1269: AND reg.location_id = hrl.location_id

Line 1492: FROM xle_entity_profiles

1488: -- API body
1489: BEGIN
1490: SELECT transacting_entity_flag
1491: INTO l_TransEntity
1492: FROM xle_entity_profiles
1493: WHERE party_id = p_party_id;
1494: EXCEPTION
1495: WHEN NO_DATA_FOUND THEN
1496: l_TransEntity := 'N';

Line 1564: l_legal_entity_id XLE_ENTITY_PROFILES.legal_entity_id%TYPE;

1560: l_api_name CONSTANT VARCHAR2(30):= 'Get_PartyID_OU';
1561: l_api_version CONSTANT NUMBER:= 1.0;
1562: l_ledger_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE;
1563: l_le_list GL_MC_INFO.LE_BSV_TBL_TYPE;
1564: l_legal_entity_id XLE_ENTITY_PROFILES.legal_entity_id%TYPE;
1565: l_index NUMBER;
1566: l_party_id HR_ALL_ORGANIZATION_UNITS.PARTY_ID%TYPE;
1567: l_ledger_flag BOOLEAN;
1568:

Line 1638: FROM XLE_ENTITY_PROFILES

1634: l_legal_entity_id := l_le_list(x).legal_entity_id;
1635:
1636: SELECT party_id
1637: INTO l_party_id
1638: FROM XLE_ENTITY_PROFILES
1639: WHERE legal_entity_id = l_legal_entity_id;
1640:
1641: x_party_tbl(l_index) := l_party_id;
1642: l_index :=l_index + 1;

Line 2169: l_legal_entity_id XLE_ENTITY_PROFILES.legal_entity_id%TYPE;

2165: l_api_name CONSTANT VARCHAR2(30):= 'Get_LegalEntity_LGER_BSV';
2166: l_api_version CONSTANT NUMBER := 1.0;
2167: l_ledger_id HR_OPERATING_UNITS.SET_OF_BOOKS_ID%TYPE;
2168: l_le_list GL_MC_INFO.LE_BSV_TBL_TYPE;
2169: l_legal_entity_id XLE_ENTITY_PROFILES.legal_entity_id%TYPE;
2170: l_index NUMBER;
2171: l_ledger_flag BOOLEAN;
2172: l_country_code HZ_GEOGRAPHIES.COUNTRY_CODE%TYPE;
2173:

Line 2177: l_legal_entity_name XLE_ENTITY_PROFILES.NAME%TYPE;

2173:
2174: l_init_msg_list VARCHAR2(100);
2175: l_commit VARCHAR2(100);
2176:
2177: l_legal_entity_name XLE_ENTITY_PROFILES.NAME%TYPE;
2178: l_return_var VARCHAR2(1000);
2179: BEGIN
2180: -- Standard Start of API savepoint
2181:

Line 2289: X_LEGAL_ENTITY_ID OUT NOCOPY XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE

2285: x_msg_count OUT NOCOPY NUMBER,
2286: x_msg_data OUT NOCOPY VARCHAR2,
2287: P_INTERFACE_ATTRIBUTE IN VARCHAR2,
2288: P_INTERFACE_VALUE IN VARCHAR2,
2289: X_LEGAL_ENTITY_ID OUT NOCOPY XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE
2290: ) IS
2291:
2292:
2293: /* Local Variable */

Line 2311: select count(legal_entity_id) into l_cnt from xle_entity_profiles

2307:
2308: /* If Company Name is passed by the interface */
2309:
2310: IF P_INTERFACE_ATTRIBUTE = 'COMPANY_NAME' THEN
2311: select count(legal_entity_id) into l_cnt from xle_entity_profiles
2312: where name = P_INTERFACE_VALUE;
2313:
2314: IF l_cnt = 0 THEN
2315: select count(legal_entity_id) into l_cnt

Line 2332: from XLE_ENTITY_PROFILES

2328: END IF;
2329:
2330: ELSE
2331: select legal_entity_id into x_legal_entity_id
2332: from XLE_ENTITY_PROFILES
2333: where name = P_INTERFACE_VALUE;
2334: END IF;
2335:
2336: END IF;

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 2358: XLE_ENTITY_PROFILES ent, XLE_REGISTRATIONS reg

2354:
2355: /* Check if the Registration Number belongs to Legal Entity or an Establishment */
2356:
2357: select count(ent.legal_entity_id) into l_cnt from
2358: XLE_ENTITY_PROFILES ent, XLE_REGISTRATIONS reg
2359: where reg.REGISTRATION_NUMBER = P_INTERFACE_VALUE
2360: and reg.SOURCE_ID = ent.LEGAL_ENTITY_ID;
2361:
2362: IF l_cnt = 0 THEN

Line 2369: XLE_ENTITY_PROFILES ent,XLE_REGISTRATIONS reg

2365: where reg.REGISTRATION_NUMBER = P_INTERFACE_VALUE
2366: and reg.SOURCE_ID = etb.ESTABLISHMENT_ID;
2367: ELSE
2368: select ent.legal_entity_id into x_legal_entity_id from
2369: XLE_ENTITY_PROFILES ent,XLE_REGISTRATIONS reg
2370: where reg.REGISTRATION_NUMBER = P_INTERFACE_VALUE
2371: and reg.SOURCE_ID = ent.LEGAL_ENTITY_ID;
2372: END IF;
2373:

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:

Line 2394: from XLE_ENTITY_PROFILES ent, XLE_REGISTRATIONS reg

2390: IF P_INTERFACE_ATTRIBUTE = 'LOCATION_ID' THEN
2391:
2392: /* Check if the Registration Number belongs to Legal Entity or an Establishment */
2393: select count(ent.legal_entity_id) into l_cnt
2394: from XLE_ENTITY_PROFILES ent, XLE_REGISTRATIONS reg
2395: where reg.LOCATION_ID = TO_NUMBER(P_INTERFACE_VALUE)
2396: and reg.SOURCE_ID = ent.LEGAL_ENTITY_ID;
2397:
2398: IF l_cnt = 0 THEN

Line 2405: XLE_ENTITY_PROFILES ent, XLE_REGISTRATIONS reg

2401: where reg.LOCATION_ID = TO_NUMBER(P_INTERFACE_VALUE)
2402: and reg.SOURCE_ID = etb.ESTABLISHMENT_ID;
2403: ELSE
2404: select ent.legal_entity_id into x_legal_entity_id from
2405: XLE_ENTITY_PROFILES ent, XLE_REGISTRATIONS reg
2406: where reg.LOCATION_ID = TO_NUMBER(P_INTERFACE_VALUE)
2407: and reg.SOURCE_ID = ent.LEGAL_ENTITY_ID;
2408: END IF;
2409: END IF;

Line 2696: FROM XLE_ENTITY_PROFILES

2692:
2693: BEGIN
2694: SELECT 'Y'
2695: INTO l_le_flag
2696: FROM XLE_ENTITY_PROFILES
2697: WHERE legal_entity_id = p_legal_entity_id
2698: AND ( effective_to >= sysdate OR effective_to is null);
2699: EXCEPTION
2700: WHEN NO_DATA_FOUND THEN

Line 2774: AND reg.source_table = 'XLE_ENTITY_PROFILES'

2770: lkp.lookup_type = 'XLE_LE_FUNCTION'
2771: AND lkp.lookup_code = reg_func.function_code
2772: AND lkp.lookup_code = 'ICINV'
2773: AND reg.source_id = p_legal_entity_id
2774: AND reg.source_table = 'XLE_ENTITY_PROFILES'
2775: AND reg.registration_id = reg_func.registration_id;
2776:
2777: if l_count >= 1 then
2778: l_ic_inv := 'Y';

Line 2797: xle_entity_profiles ent_prof

2793: FROM
2794: xle_reg_functions reg_func,
2795: xle_registrations reg,
2796: xle_lookups lkp ,
2797: xle_entity_profiles ent_prof
2798: WHERE
2799: lkp.lookup_type = 'XLE_LE_FUNCTION'
2800: AND lkp.lookup_code = reg_func.function_code
2801: AND lkp.lookup_code = 'ICINV'

Line 2804: AND reg.source_table = 'XLE_ENTITY_PROFILES'

2800: AND lkp.lookup_code = reg_func.function_code
2801: AND lkp.lookup_code = 'ICINV'
2802: AND reg.registration_id = reg_func.registration_id
2803: AND reg.source_id = ent_prof.legal_entity_id
2804: AND reg.source_table = 'XLE_ENTITY_PROFILES'
2805: AND ent_prof.party_id = p_party_id;
2806:
2807: if l_count >= 1 then
2808: l_ic_inv := 'Y';