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_ETB_PROFILES

Line 112: FROM XLE_ETB_PROFILES etb,

108: hrl.region_2,
109: hrl.region_3,
110: hrl.postal_code,
111: hrl.country
112: FROM XLE_ETB_PROFILES etb,
113: XLE_REGISTRATIONS reg,
114: HR_LOCATIONS_ALL hrl,
115: XLE_JURISDICTIONS_VL jur
116: WHERE

Line 118: AND reg.source_table = 'XLE_ETB_PROFILES'

114: HR_LOCATIONS_ALL hrl,
115: XLE_JURISDICTIONS_VL jur
116: WHERE
117: etb.establishment_id = reg.source_id
118: AND reg.source_table = 'XLE_ETB_PROFILES'
119: AND hrl.location_id = reg.location_id
120: AND jur.jurisdiction_id = reg.jurisdiction_id
121: AND etb.party_ID like l_party_ID
122: AND etb.establishment_id like l_entity_ID

Line 304: p_establishment_id IN XLE_ETB_PROFILES.ESTABLISHMENT_ID%TYPE,

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
308: )

Line 327: l_establishment_name xle_etb_profiles.name%type;

323: l_registration_info XLE_UTILITIES_GRP.Registration_Tbl_Type;
324: l_msg_data VARCHAR2(1000);
325: l_msg_count number;
326: l_return_status varchar2(10);
327: l_establishment_name xle_etb_profiles.name%type;
328: l_legalentity_id varchar2(100);
329: legalentity_id number;
330:
331: rowcount_flag BOOLEAN := false;

Line 334: from xle_etb_profiles */

330:
331: rowcount_flag BOOLEAN := false;
332:
333: /* The following cursor selects establishment specific legal information
334: from xle_etb_profiles */
335:
336: CURSOR ETB_Reg_c IS
337: SELECT etb.party_id,
338: etb.establishment_id,

Line 347: FROM XLE_ETB_PROFILES etb

343: etb.sub_activity_code,
344: etb.type_of_company,
345: etb.effective_from etb_effective_from,
346: etb.effective_to etb_effective_to
347: FROM XLE_ETB_PROFILES etb
348: WHERE etb.party_ID like l_party_ID
349: AND etb.establishment_id like l_establishment_id
350: AND etb.legal_entity_id like l_legalentity_id
351: ;

Line 401: Legal Entity ID is retrieved from the table XLE_ETB_PROFILES in the

397:
398: BEGIN
399:
400: /* Establishment information for the given party ID or ETB ID or
401: Legal Entity ID is retrieved from the table XLE_ETB_PROFILES in the
402: following cursor */
403:
404: FOR ETB_Reg_r in ETB_Reg_c LOOP
405:

Line 812: l_source_table := 'XLE_ETB_PROFILES';

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';
815: END IF;
816:

Line 1384: FROM XLE_ETB_PROFILES

1380:
1381: BEGIN
1382: SELECT 'Y'
1383: INTO l_establishment_flag
1384: FROM XLE_ETB_PROFILES
1385: WHERE party_id = p_party_id
1386: AND ( effective_to >= sysdate OR effective_to is null);
1387:
1388: EXCEPTION

Line 1848: FROM XLE_ETB_PROFILES etbp

1844: BEGIN
1845:
1846: SELECT etbp.party_id
1847: INTO x_me_party_id
1848: FROM XLE_ETB_PROFILES etbp
1849: WHERE etbp.main_establishment_flag = 'Y'
1850: AND etbp.legal_entity_id = p_legal_entity_id
1851: AND TRUNC(sysdate) BETWEEN TRUNC(NVL(main_effective_from,sysdate))
1852: AND TRUNC(NVL(main_effective_to,sysdate));

Line 1926: FROM XLE_ETB_PROFILES etbp,

1922: l_init_msg_list VARCHAR2(100);
1923: l_commit VARCHAR2(100);
1924: CURSOR regnum_c IS
1925: SELECT reg.registration_number,jur.legislative_cat_code
1926: FROM XLE_ETB_PROFILES etbp,
1927: XLE_REGISTRATIONS reg,
1928: XLE_JURISDICTIONS_VL jur
1929: WHERE etbp.establishment_id = reg.source_id
1930: AND trunc(reg.source_table) = 'XLE_ETB_PROFILES'

Line 1930: AND trunc(reg.source_table) = 'XLE_ETB_PROFILES'

1926: FROM XLE_ETB_PROFILES etbp,
1927: XLE_REGISTRATIONS reg,
1928: XLE_JURISDICTIONS_VL jur
1929: WHERE etbp.establishment_id = reg.source_id
1930: AND trunc(reg.source_table) = 'XLE_ETB_PROFILES'
1931: AND reg.jurisdiction_id = jur.jurisdiction_id
1932: AND etbp.party_id = p_party_id;
1933:
1934: BEGIN

Line 2040: FROM XLE_ETB_PROFILES etbp,

2036: SELECT etbp.etb_information1 activity_code,
2037: fndlookup.lookup_type class_category,
2038: fndlookup.lookup_code class_code,
2039: fndlookup.meaning meaning
2040: FROM XLE_ETB_PROFILES etbp,
2041: XLE_LOOKUPS fndlookup
2042: WHERE etbp.party_id = p_party_id
2043: AND fndlookup.lookup_code = etbp.etb_information1
2044: AND NVL(fndlookup.START_DATE_ACTIVE, SYSDATE) <= SYSDATE

Line 2055: FROM XLE_ETB_PROFILES etbp,

2051: SELECT etbp.etb_information2 sub_activity_code,
2052: fndlookup.lookup_type class_category,
2053: fndlookup.lookup_code class_code,
2054: fndlookup.meaning meaning
2055: FROM XLE_ETB_PROFILES etbp,
2056: XLE_LOOKUPS fndlookup
2057: WHERE etbp.party_id = p_party_id
2058: AND fndlookup.lookup_code = etbp.etb_information2
2059: AND NVL(fndlookup.START_DATE_ACTIVE, SYSDATE) <= SYSDATE

Line 2316: from XLE_ETB_PROFILES

2312: where name = P_INTERFACE_VALUE;
2313:
2314: IF l_cnt = 0 THEN
2315: select count(legal_entity_id) into l_cnt
2316: from XLE_ETB_PROFILES
2317: where name = P_INTERFACE_VALUE;
2318:
2319: IF l_cnt = 0 THEN
2320: select etb.legal_entity_id into x_legal_entity_id

Line 2321: from XLE_ETB_PROFILES etb, HZ_PARTIES parties

2317: where name = P_INTERFACE_VALUE;
2318:
2319: IF l_cnt = 0 THEN
2320: select etb.legal_entity_id into x_legal_entity_id
2321: from XLE_ETB_PROFILES etb, HZ_PARTIES parties
2322: where parties.party_name = P_INTERFACE_VALUE
2323: and parties.party_id = etb.party_id;
2324: ELSE
2325: select legal_entity_id into x_legal_entity_id

Line 2326: from XLE_ETB_PROFILES

2322: where parties.party_name = P_INTERFACE_VALUE
2323: and parties.party_id = etb.party_id;
2324: ELSE
2325: select legal_entity_id into x_legal_entity_id
2326: from XLE_ETB_PROFILES
2327: where name = P_INTERFACE_VALUE;
2328: END IF;
2329:
2330: ELSE

Line 2364: from XLE_ETB_PROFILES etb, XLE_REGISTRATIONS reg

2360: and reg.SOURCE_ID = ent.LEGAL_ENTITY_ID;
2361:
2362: IF l_cnt = 0 THEN
2363: select etb.legal_entity_id into x_legal_entity_id
2364: from XLE_ETB_PROFILES etb, 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

Line 2400: from XLE_ETB_PROFILES etb, XLE_REGISTRATIONS reg

2396: and reg.SOURCE_ID = ent.LEGAL_ENTITY_ID;
2397:
2398: IF l_cnt = 0 THEN
2399: select etb.legal_entity_id into x_legal_entity_id
2400: from XLE_ETB_PROFILES etb, 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