APPS.HR_LEGISLATION_ELEMENTS dependencies on PAY_INPUT_VALUES_F

Line 883: from pay_input_values_f a

879:
880:
881: select distinct null
882: into l_null_return
883: from pay_input_values_f a
884: where exists
885: (select null
886: from hr_s_input_values_f b
887: where a.input_value_id = b.input_value_id

Line 1250: from pay_input_values_f

1246: -- version of the input values row.
1247:
1248: select distinct input_value_id
1249: into v_new_input_id
1250: from pay_input_values_f
1251: where replace(ltrim(rtrim(upper(name))), ' ', '_') =
1252: replace(ltrim(rtrim(upper(i_vals.name))), ' ', '_')
1253: and business_group_id is null
1254: and element_type_id = l_new_element_Type_id;

Line 1268: hr_utility.trace('sel pay_input_values_f TMR');

1264: v_new_input_value_flag := 'Y';
1265:
1266: WHEN TOO_MANY_ROWS THEN
1267: hr_legislation.hrrunprc_trace_on;
1268: hr_utility.trace('sel pay_input_values_f TMR');
1269: hr_utility.trace('iv name ' ||
1270: i_vals.name);
1271: hr_utility.trace('element_type_id ' ||
1272: to_char(l_new_element_Type_id));

Line 1440: l_input_value_id pay_input_values_f.input_value_id%type;

1436: -- checks must be performed to check to validity of the data that has
1437: -- just been installed.
1438:
1439: l_iv_exists boolean;
1440: l_input_value_id pay_input_values_f.input_value_id%type;
1441:
1442: BEGIN
1443:
1444:

Line 1453: , pay_input_values_f b

1449: -- Check balance feeds
1450: select distinct null
1451: into l_null_return
1452: from pay_balance_feeds_f a
1453: , pay_input_values_f b
1454: where b.element_type_id = l_new_element_type_id
1455: and a.input_value_id = b.input_value_id
1456: and a.effective_end_Date > r_distinct.c_end
1457: and a.business_group_id is not null;

Line 1522: from pay_input_values_f

1518: BEGIN
1519:
1520: select input_value_id
1521: into l_input_value_id
1522: from pay_input_values_f
1523: where element_type_id = l_new_element_type_id
1524: and rownum = 1;
1525:
1526: l_iv_exists := TRUE;

Line 2019: delete from pay_input_values_f

2015: IF p_phase = 2 THEN
2016:
2017: FOR i_values IN inputs(l_new_element_type_id) LOOP
2018:
2019: delete from pay_input_values_f
2020: where business_group_id is null
2021: and input_value_id = i_values.input_value_id;
2022:
2023: BEGIN

Line 2040: insert into pay_input_values_f

2036: l_flex_value_set_id := null;
2037: END;
2038:
2039: BEGIN
2040: insert into pay_input_values_f
2041: (input_value_id
2042: ,effective_start_date
2043: ,effective_end_date
2044: ,element_type_id

Line 2096: hr_utility.trace('ins pay_input_values_f');

2092: from hr_s_input_values_f
2093: where input_value_id = i_values.input_value_id;
2094: EXCEPTION WHEN OTHERS THEN
2095: hr_legislation.hrrunprc_trace_on;
2096: hr_utility.trace('ins pay_input_values_f');
2097: hr_utility.trace('iv id ' ||
2098: to_char(i_values.input_value_id));
2099: hr_utility.trace('iv name ' ||
2100: i_values.name);