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 1258: P_TABLE_NAME => 'PAY_INPUT_VALUES_F',

1254: --PSEUDO
1255: -- Error if we clash on delivered data to pseudo data present
1256: IF hr_legislation.g_pseudo_enabled = 'Y' THEN
1257: hr_legislation.PSEUDO_SEED_DATA_CLASH(P_SURROGATE_KEY_NAME => i_vals.name,
1258: P_TABLE_NAME => 'PAY_INPUT_VALUES_F',
1259: P_ADDL_SURROGATE_KEY_NAME1 => r_distinct.c_true_key,
1260: P_LEGISLATION_CODE => r_distinct.legislation_code);
1261: END IF;
1262:

Line 1271: from pay_input_values_f

1267: -- version of the input values row.
1268:
1269: select distinct input_value_id
1270: into v_new_input_id
1271: from pay_input_values_f
1272: where replace(ltrim(rtrim(upper(name))), ' ', '_') =
1273: replace(ltrim(rtrim(upper(i_vals.name))), ' ', '_')
1274: and business_group_id is null
1275: and element_type_id = l_new_element_Type_id;

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

1285: v_new_input_value_flag := 'Y';
1286:
1287: WHEN TOO_MANY_ROWS THEN
1288: hr_legislation.hrrunprc_trace_on;
1289: hr_utility.trace('sel pay_input_values_f TMR');
1290: hr_utility.trace('iv name ' ||
1291: i_vals.name);
1292: hr_utility.trace('element_type_id ' ||
1293: to_char(l_new_element_Type_id));

Line 1461: l_input_value_id pay_input_values_f.input_value_id%type;

1457: -- checks must be performed to check to validity of the data that has
1458: -- just been installed.
1459:
1460: l_iv_exists boolean;
1461: l_input_value_id pay_input_values_f.input_value_id%type;
1462:
1463: BEGIN
1464:
1465:

Line 1474: , pay_input_values_f b

1470: -- Check balance feeds
1471: select distinct null
1472: into l_null_return
1473: from pay_balance_feeds_f a
1474: , pay_input_values_f b
1475: where b.element_type_id = l_new_element_type_id
1476: and a.input_value_id = b.input_value_id
1477: and a.effective_end_Date > r_distinct.c_end
1478: and a.business_group_id is not null;

Line 1543: from pay_input_values_f

1539: BEGIN
1540:
1541: select input_value_id
1542: into l_input_value_id
1543: from pay_input_values_f
1544: where element_type_id = l_new_element_type_id
1545: and rownum = 1;
1546:
1547: l_iv_exists := TRUE;

Line 2051: delete from pay_input_values_f

2047: IF p_phase = 2 THEN
2048:
2049: FOR i_values IN inputs(l_new_element_type_id) LOOP
2050:
2051: delete from pay_input_values_f
2052: where business_group_id is null
2053: and input_value_id = i_values.input_value_id;
2054:
2055: BEGIN

Line 2072: insert into pay_input_values_f

2068: l_flex_value_set_id := null;
2069: END;
2070:
2071: BEGIN
2072: insert into pay_input_values_f
2073: (input_value_id
2074: ,effective_start_date
2075: ,effective_end_date
2076: ,element_type_id

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

2124: from hr_s_input_values_f
2125: where input_value_id = i_values.input_value_id;
2126: EXCEPTION WHEN OTHERS THEN
2127: hr_legislation.hrrunprc_trace_on;
2128: hr_utility.trace('ins pay_input_values_f');
2129: hr_utility.trace('iv id ' ||
2130: to_char(i_values.input_value_id));
2131: hr_utility.trace('iv name ' ||
2132: i_values.name);