APPS.PY_ZA_COIDA_PKG SQL Statements

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

Line: 63

   Select
        sum(absence_days)
   From
         per_absence_attendances      paa
   ,     per_absence_attendance_types pat
   Where
         pat.absence_attendance_type_id = paa.absence_attendance_type_id
   And   upper(pat.name) = upper(p_type)
   And   paa.date_start >= p_start_date
   And   paa.date_end   <= p_end_date
   And   paa.date_end   >= p_start_date
   And   paa.date_end   <= p_end_date;

Line: 124

   Select
         paf.assignment_id,
         paf.effective_start_date,
         paf.effective_end_date,
         paf.assignment_status_type_id
   From
         per_assignments_f paf,
         per_assignment_status_types past,
         pay_payrolls_f ppaf,
         per_periods_of_service pos
   Where
-------------------------------------------------------------------------------------
         pos.PERSON_ID = paf.PERSON_ID
   and   nvl(pos.actual_termination_date, paf.effective_end_date) >= paf.EFFECTIVE_END_DATE
   and   paf.ASSIGNMENT_TYPE = 'E'
-------------------------------------------------------------------------------------
-- Per_Assignments_F
--       paf.person_id  = nvl(p_person_id,paf.person_id)
   And   paf.person_id  = p_person_id
   And   paf.payroll_id = p_payroll_id
   And   p_start_date <= paf.effective_end_date
   And   p_end_date >= paf.effective_start_date

   And   paf.assignment_status_type_id = past.assignment_status_type_id
   And   past.per_system_status = 'ACTIVE_ASSIGN'

-- Per_Payrolls_F
   And   paf.payroll_id = ppaf.payroll_id
   And   p_start_date <= ppaf.effective_end_date
   And   p_end_date >= ppaf.effective_start_date
   Order by
        2;