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 1187: from pay_element_types_f

1183:
1184: BEGIN
1185: select distinct element_type_id
1186: into l_new_element_type_id
1187: from pay_element_types_f
1188: where replace(ltrim(rtrim(upper(element_name))), ' ', '_') =
1189: replace(ltrim(rtrim(upper(r_distinct.c_true_key))), ' ', '_')
1190: and business_Group_id is null
1191: and legislation_code = r_distinct.legislation_code;

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

1202: v_new_element_type_flag := 'Y';
1203:
1204: WHEN TOO_MANY_ROWS THEN
1205: hr_legislation.hrrunprc_trace_on;
1206: hr_utility.trace('sel pay_element_types_f TMR');
1207: hr_utility.trace('element_name ' ||
1208: r_distinct.c_true_key);
1209: hr_utility.trace(':lc: ' || ':' ||
1210: r_distinct.legislation_code || ':');

Line 1773: from pay_element_types_f pe

1769: IS
1770: -- Cursor to fetch elements with same name
1771:
1772: select /*+ INDEX_FFS(pe) */ business_group_id
1773: from pay_element_types_f pe
1774: where business_group_id is not null
1775: and replace(ltrim(rtrim(upper(element_name))), ' ', '_') =
1776: replace(ltrim(rtrim(upper(r_distinct.c_true_key))), ' ', '_');
1777:

Line 1887: from pay_element_types_f a

1883:
1884:
1885: select distinct null
1886: into l_null_return
1887: from pay_element_types_f a
1888: where a.business_group_id is not null
1889: and replace(ltrim(rtrim(upper(a.element_name))), ' ', '_') =
1890: replace(ltrim(rtrim(upper(r_distinct.c_true_key))), ' ', '_');
1891:

Line 1950: from pay_element_types_f

1946:
1947:
1948: select distinct null
1949: into l_null_return
1950: from pay_element_types_f
1951: where element_name = r_distinct.c_true_key
1952: and nvl (legislation_code, 'x') <>
1953: nvl (r_distinct.legislation_code, 'x')
1954: and (legislation_code is null

Line 2002: delete from pay_element_types_f

1998: delete from pay_status_processing_rules_f
1999: where element_type_id = r_distinct.c_surrogate_key
2000: and business_Group_id is null;
2001:
2002: delete from pay_element_types_f
2003: where element_type_id = r_distinct.c_surrogate_key
2004: and business_Group_id is null;
2005:
2006: END delete_live_children;

Line 2157: from pay_element_types_f a

2153: BEGIN
2154:
2155: select distinct null
2156: into l_null_return
2157: from pay_element_types_f a
2158: where a.business_Group_id is null
2159: and a.element_name = p_element_name
2160: and exists
2161: (select null

Line 2162: from pay_element_types_f b

2158: where a.business_Group_id is null
2159: and a.element_name = p_element_name
2160: and exists
2161: (select null
2162: from pay_element_types_f b
2163: where b.element_type_id <> a.element_Type_id
2164: and b.element_name = a.element_name
2165: and b.business_Group_id is null
2166: and b.legislation_code = a.legislation_code

Line 2231: insert into pay_element_types_f

2227: l_formula_id := NULL;
2228: end if;
2229:
2230: BEGIN
2231: insert into pay_element_types_f
2232: (element_type_id
2233: ,effective_start_date
2234: ,effective_end_date
2235: ,business_group_id

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

2365: ,each_row.TIME_DEFINITION_ID
2366: );
2367: EXCEPTION WHEN OTHERS THEN
2368: hr_legislation.hrrunprc_trace_on;
2369: hr_utility.trace('ins pay_element_types_f');
2370: hr_utility.trace('element type name ' ||
2371: each_row.element_name);
2372: hr_utility.trace('element_type_id ' ||
2373: to_char(each_row.element_type_id));

Line 3135: from pay_element_types_f

3131:
3132:
3133: select null
3134: into l_null_return
3135: from pay_element_types_f
3136: where element_type_id = ele_types.element_type_id;
3137:
3138: BEGIN
3139: insert into pay_element_type_rules