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.HR_LEGISLATION_ELEMENTS dependencies on PAY_ELEMENT_TYPES_F

Line 840: from pay_element_types_f a

836:
837:
838: select distinct null
839: into l_null_return
840: from pay_element_types_f a
841: where exists
842: (select null
843: from hr_s_element_types_f b
844: where a.element_type_id = b.element_type_id

Line 1124: hr_legislation.insert_hr_stu_exceptions('pay_element_types_f'

1120: ELSE
1121: rollback to new_distinct_id;
1122: END IF;
1123:
1124: hr_legislation.insert_hr_stu_exceptions('pay_element_types_f'
1125: , r_distinct.c_surrogate_key
1126: , exception_type
1127: , r_distinct.c_true_key);
1128:

Line 1190: P_TABLE_NAME => 'PAY_ELEMENT_TYPES_F',

1186: BEGIN
1187: -- Check if we have a pseduo seed clash if enabled
1188: -- Error handling is done in the procedure itself
1189: hr_legislation.PSEUDO_SEED_DATA_CLASH(P_SURROGATE_KEY_NAME => r_distinct.c_true_key,
1190: P_TABLE_NAME => 'PAY_ELEMENT_TYPES_F',
1191: P_LEGISLATION_CODE => r_distinct.legislation_code);
1192: EXCEPTION WHEN OTHERS THEN
1193: raise;
1194: END;

Line 1200: from pay_element_types_f

1196:
1197: BEGIN
1198: select distinct element_type_id
1199: into l_new_element_type_id
1200: from pay_element_types_f
1201: where replace(ltrim(rtrim(upper(element_name))), ' ', '_') =
1202: replace(ltrim(rtrim(upper(r_distinct.c_true_key))), ' ', '_')
1203: and business_Group_id is null
1204: and legislation_code = r_distinct.legislation_code;

Line 1219: hr_utility.trace('sel pay_element_types_f TMR');

1215: v_new_element_type_flag := 'Y';
1216:
1217: WHEN TOO_MANY_ROWS THEN
1218: hr_legislation.hrrunprc_trace_on;
1219: hr_utility.trace('sel pay_element_types_f TMR');
1220: hr_utility.trace('element_name ' ||
1221: r_distinct.c_true_key);
1222: hr_utility.trace(':lc: ' || ':' ||
1223: r_distinct.legislation_code || ':');

Line 1794: from pay_element_types_f pe

1790: IS
1791: -- Cursor to fetch elements with same name
1792:
1793: select /*+ INDEX_FFS(pe) */ business_group_id
1794: from pay_element_types_f pe
1795: where business_group_id is not null
1796: and replace(ltrim(rtrim(upper(element_name))), ' ', '_') =
1797: replace(ltrim(rtrim(upper(r_distinct.c_true_key))), ' ', '_');
1798:

Line 1908: from pay_element_types_f a

1904:
1905:
1906: select distinct null
1907: into l_null_return
1908: from pay_element_types_f a
1909: where a.business_group_id is not null
1910: and replace(ltrim(rtrim(upper(a.element_name))), ' ', '_') =
1911: replace(ltrim(rtrim(upper(r_distinct.c_true_key))), ' ', '_');
1912:

Line 1971: from pay_element_types_f

1967:
1968:
1969: select distinct null
1970: into l_null_return
1971: from pay_element_types_f
1972: where element_name = r_distinct.c_true_key
1973: and nvl (legislation_code, 'x') <>
1974: nvl (r_distinct.legislation_code, 'x')
1975: and (legislation_code is null

Line 1999: P_TABLE_NAME => 'PAY_ELEMENT_TYPES_F',

1995: -- PSEUDO CHECK
1996: -- Check if we have a pseudo seed clash if enabled
1997: -- Error handling is done in the procedure itself
1998: hr_legislation.PSEUDO_SEED_DATA_CLASH(P_SURROGATE_KEY_NAME => r_distinct.c_true_key,
1999: P_TABLE_NAME => 'PAY_ELEMENT_TYPES_F',
2000: P_LEGISLATION_CODE => r_distinct.legislation_code);
2001: END IF;
2002:
2003: else

Line 2034: delete from pay_element_types_f

2030: delete from pay_status_processing_rules_f
2031: where element_type_id = r_distinct.c_surrogate_key
2032: and business_Group_id is null;
2033:
2034: delete from pay_element_types_f
2035: where element_type_id = r_distinct.c_surrogate_key
2036: and business_Group_id is null;
2037:
2038: END delete_live_children;

Line 2189: from pay_element_types_f a

2185: BEGIN
2186:
2187: select distinct null
2188: into l_null_return
2189: from pay_element_types_f a
2190: where a.business_Group_id is null
2191: and a.element_name = p_element_name
2192: and exists
2193: (select null

Line 2194: from pay_element_types_f b

2190: where a.business_Group_id is null
2191: and a.element_name = p_element_name
2192: and exists
2193: (select null
2194: from pay_element_types_f b
2195: where b.element_type_id <> a.element_Type_id
2196: and b.element_name = a.element_name
2197: and b.business_Group_id is null
2198: and b.legislation_code = a.legislation_code

Line 2263: insert into pay_element_types_f

2259: l_formula_id := NULL;
2260: end if;
2261:
2262: BEGIN
2263: insert into pay_element_types_f
2264: (element_type_id
2265: ,effective_start_date
2266: ,effective_end_date
2267: ,business_group_id

Line 2401: hr_utility.trace('ins pay_element_types_f');

2397: ,each_row.TIME_DEFINITION_ID
2398: );
2399: EXCEPTION WHEN OTHERS THEN
2400: hr_legislation.hrrunprc_trace_on;
2401: hr_utility.trace('ins pay_element_types_f');
2402: hr_utility.trace('element type name ' ||
2403: each_row.element_name);
2404: hr_utility.trace('element_type_id ' ||
2405: to_char(each_row.element_type_id));

Line 3167: from pay_element_types_f

3163:
3164:
3165: select null
3166: into l_null_return
3167: from pay_element_types_f
3168: where element_type_id = ele_types.element_type_id;
3169:
3170: BEGIN
3171: insert into pay_element_type_rules