APPS.PAY_SE_SLSA_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 426: FROM pay_element_types_f

422: p_element_name VARCHAR2,
423: p_report_end_date DATE
424: ) IS
425: SELECT element_type_id
426: FROM pay_element_types_f
427: WHERE element_name = p_element_name
428: AND legislation_code = 'SE'
429: AND business_group_id IS NULL
430: AND p_report_end_date BETWEEN effective_start_date AND effective_end_date;

Line 559: l_element_type_id pay_element_types_f.element_type_id%TYPE;

555: l_leave_to_work_hour_lower NUMBER := 0;
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;