APPS.PAY_NO_ABS_VALIDATION SQL Statements

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

Line: 21

 SELECT sex FROM per_all_people_f
  WHERE person_id = l_person_id
    AND l_date BETWEEN EFFECTIVE_START_DATE AND EFFECTIVE_END_DATE;

Line: 27

SELECT fnd_number.canonical_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: 34

SELECT start_date,PER_INFORMATION7 FROM per_all_people_f where
person_id = p_person_id
AND P_EFFECTIVE_DATE BETWEEN EFFECTIVE_START_DATE
     AND EFFECTIVE_END_DATE;

Line: 40

SELECT (PAA.DATE_END - PAA.DATE_START) + 1 AS DAYS,PAA.DATE_START, PAA.DATE_END
 FROM PER_ABSENCE_ATTENDANCES PAA, PER_ABSENCE_ATTENDANCE_TYPES PAT
WHERE PAA.ABSENCE_ATTENDANCE_TYPE_ID = PAT.ABSENCE_ATTENDANCE_TYPE_ID
  AND PAT.ABSENCE_CATEGORY = 'UN'
  AND PAA.DATE_START IS NOT NULL
  AND PAA.DATE_END IS NOT NULL
  AND PAA.PERSON_ID = personid
  ORDER BY DATE_START ;

Line: 50

select name from PER_ABS_ATTENDANCE_REASONS  par
WHERE PAR.ABS_ATTENDANCE_REASON_ID = attn_reason_id ;

Line: 54

   SELECT DATE_START
         ,DATE_END
    FROM PER_ABSENCE_ATTENDANCES
   WHERE PERSON_ID = personid
     AND DATE_END BETWEEN (abs_start_date - abs_link_period) AND (abs_start_date -1)
     AND ABS_INFORMATION1 = 'SC'
     AND DATE_START IS NOT NULL
     AND DATE_END IS NOT NULL;

Line: 188

             SELECT count(1)
               INTO l_abs_count
               FROM PER_ABSENCE_ATTENDANCES PAA
              WHERE PAA.PERSON_ID = l_person_id
                AND PAA.DATE_END BETWEEN add_months(l_abs_start_date, -12) AND (l_abs_start_date-1)
                AND PAA.ABS_INFORMATION1 = 'SC'
                AND PAA.DATE_START IS NOT NULL
                AND PAA.DATE_END IS NOT NULL;

Line: 281

procedure UPDATE_ABS_VALIDATION (P_ABS_INFORMATION_CATEGORY in varchar2
                                    ,P_ABSENCE_ATTENDANCE_ID in NUMBER
                                    ,P_EFFECTIVE_DATE in DATE
                                    ,P_ABS_INFORMATION1 in VARCHAR2
                                    ,P_ABS_INFORMATION2 in VARCHAR2
                                    ,P_ABS_INFORMATION3 in VARCHAR2
                                    ,P_ABS_INFORMATION5 in VARCHAR2
                                    ,P_ABS_INFORMATION6 in VARCHAR2
                                    ,P_ABS_INFORMATION15 in VARCHAR2
                                    ,P_ABS_INFORMATION16 in VARCHAR2
                                    ,P_DATE_START in DATE
                                    ,P_DATE_END in DATE
				    ,P_DATE_PROJECTED_START in DATE
				    ,P_DATE_PROJECTED_END in DATE
                                    ,P_ABS_ATTENDANCE_REASON_ID in NUMBER) is

-- Get the person Id
CURSOR get_person_id (p_abs_attendance_id in NUMBER) is
SELECT person_id
  FROM PER_ABSENCE_ATTENDANCES
 WHERE ABSENCE_ATTENDANCE_ID = p_abs_attendance_id;

Line: 327

END UPDATE_ABS_VALIDATION;