APPS.PAY_NO_ABSENCE_USER SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 43

SELECT
	peef.element_entry_id
FROM
	pay_element_entry_values_f peevf
	,pay_input_values_f pivf
	,pay_element_entries_f peef
WHERE
	peevf.screen_entry_value = p_creator_id
	AND pivf.input_value_id = peevf.input_value_id
	AND pivf.NAME = 'CREATOR_ID'
	AND pivf.legislation_code = 'NO'
	AND peef.element_entry_id  = peevf.element_entry_id
	AND peef.assignment_id = p_assignment_id;

Line: 60

SELECT paa.absence_attendance_id
       ,paa.date_start
       ,paa.date_end
  FROM per_absence_attendances paa, per_absence_attendance_types pat
 WHERE paa.person_id = l_person_id
   AND paa.date_start < l_abs_st_date
   AND paa.date_end < l_abs_st_date
   AND paa.date_start IS NOT NULL AND paa.date_end IS NOT NULL
   AND paa.absence_attendance_type_id = pat.absence_attendance_type_id
   AND pat.absence_category IN ('S','PTS')
 ORDER BY paa.date_end desc ;

Line: 74

SELECT to_number(global_value)
FROM  ff_globals_f
WHERE global_name = p_global_name
AND   legislation_code = 'NO'
AND   p_effective_date BETWEEN effective_start_date AND effective_end_date;

Line: 98

          SELECT abs.date_start
                 ,abs.date_end
                 ,abs.ABS_ATTENDANCE_REASON_ID
                 ,abs.TIME_START
                 ,abs.TIME_END
                 ,abs.abs_information15
                 ,abs.abs_information16
          INTO   l_start_date
                 ,l_end_date
                 ,l_absent_reason
                 ,l_start_time
                 ,l_end_time
                 ,l_intial_absence
                 ,l_initial_abs_creator_id
          FROM   per_absence_attendances      abs
          WHERE  abs.absence_attendance_id      = p_absence_attendance_id;

Line: 163

		     -- To select absence category meaning by passing code
		     BEGIN
		        SELECT MEANING
			INTO   l_abs_cat_meaning
			--FROM   FND_LOOKUP_VALUES
			-- Version 115.1 , Changed query to get value from hr_lookups
			FROM   HR_LOOKUPS
			WHERE  LOOKUP_TYPE = 'ABSENCE_CATEGORY'
			  AND  ENABLED_FLAG = 'Y'
			  AND  LOOKUP_CODE = p_absence_category;