The following lines contain the word 'select', 'insert', 'update' or 'delete':
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;
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;
pattern.delete;
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;
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;
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;
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';
days_tab.delete;
Select Min(effective_start_date)
From per_all_assignments_f paaf
Where
paaf.assignment_id = g_assignment_id;