APPS.HR_INPUT_VALUES dependencies on PAY_LINK_INPUT_VALUES_F

Line 493: from pay_link_input_values_f

489: p_input_value_id number) is
490: select element_link_id,
491: effective_start_date,
492: effective_end_date
493: from pay_link_input_values_f
494: where input_value_id = p_input_value_id
495: and default_value is null
496: and effective_end_date >= p_val_start_date
497: and effective_start_date <= p_val_end_date;

Line 531: from pay_link_input_values_f

527: begin
528: --
529: select 'Y'
530: into null_links_found
531: from pay_link_input_values_f
532: where input_value_id = p_input_value_id
533: and min_value is null
534: and effective_end_date >= p_val_start_date
535: and effective_start_date <= p_val_end_date;

Line 556: from pay_link_input_values_f

552: begin
553: --
554: select 'Y'
555: into null_links_found
556: from pay_link_input_values_f
557: where input_value_id = p_input_value_id
558: and max_value is null
559: and effective_end_date >= p_val_start_date
560: and effective_start_date <= p_val_end_date;

Line 1034: from pay_link_input_values_f liv

1030: into l_link_inputs_exist
1031: from sys.dual
1032: where exists
1033: (select 1
1034: from pay_link_input_values_f liv
1035: where liv.input_value_id = p_input_value_id);
1036: --
1037: exception
1038: when NO_DATA_FOUND then NULL;

Line 1109: insert into pay_link_input_values_f

1105: from sys.dual;
1106: --
1107: -- Copy the date effective rows from the input value to the link input
1108: -- value where they overlap
1109: insert into pay_link_input_values_f
1110: (LINK_INPUT_VALUE_ID,
1111: EFFECTIVE_START_DATE,
1112: EFFECTIVE_END_DATE,
1113: ELEMENT_LINK_ID,

Line 1167: insert into pay_link_input_values_f

1163: --
1164: -- insert link input values when an new input value has been inserted and
1165: -- links already exist.
1166: --
1167: insert into pay_link_input_values_f
1168: (LINK_INPUT_VALUE_ID,
1169: EFFECTIVE_START_DATE,
1170: EFFECTIVE_END_DATE,
1171: ELEMENT_LINK_ID,

Line 1378: from pay_link_input_values_f

1374: -- Delete link input values
1375: --
1376: if p_delete_mode = 'ZAP' then
1377: delete
1378: from pay_link_input_values_f
1379: where input_value_id = p_input_value_id;
1380: --
1381: elsif p_delete_mode = 'DELETE_NEXT_CHANGE' then
1382: --

Line 1408: update pay_link_input_values_f lv1

1404: if l_on_final_record = 'Y' then
1405: --
1406: v_end_of_time := to_date('31/12/4712', 'DD/MM/YYYY');
1407: --
1408: update pay_link_input_values_f lv1
1409: set lv1.effective_end_date = v_end_of_time
1410: where p_input_value_id = lv1.input_value_id
1411: and lv1.effective_end_date =
1412: (select max(lv2.effective_end_date)

Line 1413: from pay_link_input_values_f lv2

1409: set lv1.effective_end_date = v_end_of_time
1410: where p_input_value_id = lv1.input_value_id
1411: and lv1.effective_end_date =
1412: (select max(lv2.effective_end_date)
1413: from pay_link_input_values_f lv2
1414: where lv2.link_input_value_id = lv1.link_input_value_id
1415: and lv2.input_value_id = p_input_value_id);
1416: --
1417: end if;