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:
1852: EXCEPTION

Line 1924: FROM XLE_ETB_PROFILES etbp,

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

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

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

Line 2038: FROM XLE_ETB_PROFILES etbp,

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

Line 2053: FROM XLE_ETB_PROFILES etbp,

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

Line 2314: from XLE_ETB_PROFILES

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

Line 2319: from XLE_ETB_PROFILES etb, HZ_PARTIES parties

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

Line 2324: from XLE_ETB_PROFILES

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

Line 2362: from XLE_ETB_PROFILES etb, XLE_REGISTRATIONS reg

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

Line 2398: from XLE_ETB_PROFILES etb, XLE_REGISTRATIONS reg

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