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;
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 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 2167: l_legal_entity_id XLE_ENTITY_PROFILES.legal_entity_id%TYPE;

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

Line 2175: l_legal_entity_name XLE_ENTITY_PROFILES.NAME%TYPE;

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

Line 2287: X_LEGAL_ENTITY_ID OUT NOCOPY XLE_ENTITY_PROFILES.LEGAL_ENTITY_ID%TYPE

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

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

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

Line 2330: from XLE_ENTITY_PROFILES

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

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

2337:
2338: IF P_INTERFACE_ATTRIBUTE = 'LEGISLATIVE_CAT' THEN
2339:
2340: select ent.LEGAL_ENTITY_ID into x_legal_entity_id
2341: from XLE_ENTITY_PROFILES ent, XLE_JURISDICTIONS_B jur, XLE_REGISTRATIONS reg
2342: where jur.LEGISLATIVE_CAT_CODE = P_INTERFACE_VALUE
2343: and jur.JURISDICTION_ID = reg.JURISDICTION_ID
2344: and reg.SOURCE_ID = ent.LEGAL_ENTITY_ID;
2345:

Line 2356: XLE_ENTITY_PROFILES ent, XLE_REGISTRATIONS reg

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

Line 2367: XLE_ENTITY_PROFILES ent,XLE_REGISTRATIONS reg

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

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

2375:
2376: IF P_INTERFACE_ATTRIBUTE = 'GEOGRAPHY_ID' THEN
2377:
2378: select ent.LEGAL_ENTITY_ID into x_legal_entity_id
2379: from XLE_ENTITY_PROFILES ent, XLE_JURISDICTIONS_B jur, XLE_REGISTRATIONS reg
2380: where jur.GEOGRAPHY_ID = TO_NUMBER(P_INTERFACE_VALUE)
2381: and jur.JURISDICTION_ID = reg.JURISDICTION_ID
2382: and reg.SOURCE_ID = ent.LEGAL_ENTITY_ID;
2383:

Line 2392: from XLE_ENTITY_PROFILES ent, XLE_REGISTRATIONS reg

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

Line 2403: XLE_ENTITY_PROFILES ent, XLE_REGISTRATIONS reg

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

Line 2694: FROM XLE_ENTITY_PROFILES

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

Line 2772: AND reg.source_table = 'XLE_ENTITY_PROFILES'

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

Line 2795: xle_entity_profiles ent_prof

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

Line 2802: AND reg.source_table = 'XLE_ENTITY_PROFILES'

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