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.PAY_SE_SLSA_ARCHIVE dependencies on PAY_INPUT_VALUES_F

Line 438: FROM pay_input_values_f

434: p_report_end_date DATE,
435: p_input_value VARCHAR2
436: ) IS
437: SELECT input_value_id
438: FROM pay_input_values_f
439: WHERE element_type_id = p_element_type_id
440: AND p_report_end_date BETWEEN effective_start_date AND effective_end_date
441: AND NAME = p_input_value
442: AND legislation_code = 'SE'

Line 560: l_input_value_start_date pay_input_values_f.input_value_id%TYPE;

556: l_leave_to_work_hour_middle NUMBER := 0;
557: l_leave_to_work_hour_upper NUMBER := 0;
558: l_duration NUMBER := 0;
559: l_element_type_id pay_element_types_f.element_type_id%TYPE;
560: l_input_value_start_date pay_input_values_f.input_value_id%TYPE;
561: l_input_value_end_date pay_input_values_f.input_value_id%TYPE;
562: l_input_value_cal_days pay_input_values_f.input_value_id%TYPE;
563: l_input_value_work_days pay_input_values_f.input_value_id%TYPE;
564: l_input_value_work_hours pay_input_values_f.input_value_id%TYPE;

Line 561: l_input_value_end_date pay_input_values_f.input_value_id%TYPE;

557: l_leave_to_work_hour_upper NUMBER := 0;
558: l_duration NUMBER := 0;
559: l_element_type_id pay_element_types_f.element_type_id%TYPE;
560: l_input_value_start_date pay_input_values_f.input_value_id%TYPE;
561: l_input_value_end_date pay_input_values_f.input_value_id%TYPE;
562: l_input_value_cal_days pay_input_values_f.input_value_id%TYPE;
563: l_input_value_work_days pay_input_values_f.input_value_id%TYPE;
564: l_input_value_work_hours pay_input_values_f.input_value_id%TYPE;
565: l_group_date DATE;

Line 562: l_input_value_cal_days pay_input_values_f.input_value_id%TYPE;

558: l_duration NUMBER := 0;
559: l_element_type_id pay_element_types_f.element_type_id%TYPE;
560: l_input_value_start_date pay_input_values_f.input_value_id%TYPE;
561: l_input_value_end_date pay_input_values_f.input_value_id%TYPE;
562: l_input_value_cal_days pay_input_values_f.input_value_id%TYPE;
563: l_input_value_work_days pay_input_values_f.input_value_id%TYPE;
564: l_input_value_work_hours pay_input_values_f.input_value_id%TYPE;
565: l_group_date DATE;
566: l_working_days NUMBER;

Line 563: l_input_value_work_days pay_input_values_f.input_value_id%TYPE;

559: l_element_type_id pay_element_types_f.element_type_id%TYPE;
560: l_input_value_start_date pay_input_values_f.input_value_id%TYPE;
561: l_input_value_end_date pay_input_values_f.input_value_id%TYPE;
562: l_input_value_cal_days pay_input_values_f.input_value_id%TYPE;
563: l_input_value_work_days pay_input_values_f.input_value_id%TYPE;
564: l_input_value_work_hours pay_input_values_f.input_value_id%TYPE;
565: l_group_date DATE;
566: l_working_days NUMBER;
567: l_working_hours NUMBER;

Line 564: l_input_value_work_hours pay_input_values_f.input_value_id%TYPE;

560: l_input_value_start_date pay_input_values_f.input_value_id%TYPE;
561: l_input_value_end_date pay_input_values_f.input_value_id%TYPE;
562: l_input_value_cal_days pay_input_values_f.input_value_id%TYPE;
563: l_input_value_work_days pay_input_values_f.input_value_id%TYPE;
564: l_input_value_work_hours pay_input_values_f.input_value_id%TYPE;
565: l_group_date DATE;
566: l_working_days NUMBER;
567: l_working_hours NUMBER;
568: l_calendar_days NUMBER;