APPS.PAY_FR_SCHEDULE_CALCULATION SQL Statements

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

Line: 42

select trunc(a.effective_start_date) effective_start_date
,      trunc(a.effective_end_date) effective_end_date
,      a.person_id
,      a.business_group_id business_group_id
,      scl.segment5 work_pattern
,      nvl(scl.segment11,g_default_offset) work_pattern_start_day
from per_all_assignments_f a
,    hr_soft_coding_keyflex scl
where a.assignment_id = p_assignment_id
and   a.soft_coding_keyflex_id = scl.soft_coding_keyflex_id(+)
order by a.effective_start_date;

Line: 71

  select ci.value
  from pay_user_tables t
  ,    pay_user_columns c
  ,    pay_user_rows_f r
  ,    pay_user_column_instances_f ci
  where t.user_table_name = g_udt_name
  and c.business_group_id = g_business_group_id
  and   t.user_table_id = r.user_table_id
  and   t.user_table_id = c.user_table_id
  and   c.user_column_name = p_pattern
  and   ci.user_column_id = c.user_column_id
  and   ci.user_row_id = r.user_row_id
  and p_effective_date
      between r.effective_start_date and r.effective_end_date
  and p_effective_date
      between ci.effective_start_date and ci.effective_end_date
  order by r.display_sequence;

Line: 117

   pattern.delete;

Line: 210

select to_number(to_char(holiday_date,'J')) day
from per_standard_holidays
where legislation_code = 'FR'
and holiday_date between p_date_start and p_date_end;

Line: 216

select to_number(to_char(date_not_taken,'J')) day
from per_std_holiday_absences
where person_id = g_person_id
and date_not_taken between p_date_start and p_date_end;

Line: 222

select to_number(to_char(actual_date_taken,'J')) day
from per_std_holiday_absences
where person_id = g_person_id
and actual_date_taken between p_date_start and p_date_end;

Line: 228

select to_number(to_char(
               greatest(a.date_start,p_date_start),'J'))     date_start
,      to_number(to_char(
          least(nvl(a.date_end,p_date_end),p_date_end),'J')) date_end
from per_absence_attendances a
,    per_absence_attendance_types aat
,    per_shared_types nw
where a.person_id = g_person_id
and a.date_start <= p_date_end
and nvl(a.date_end,p_date_end) >= p_date_start
and a.absence_attendance_type_id = aat.absence_attendance_type_id
and aat.absence_category = nw.system_type_cd
and nvl(nw.business_group_id,a.business_group_id) = a.business_group_id
and nw.lookup_type = 'ABSENCE_CATEGORY'
and nw.information1 = 'Y';

Line: 283

days_tab.delete;

Line: 632

         Select Min(effective_start_date)
         From per_all_assignments_f paaf
         Where
              paaf.assignment_id = g_assignment_id;