APPS.PER_PDS_UTILS SQL Statements

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

Line: 48

  select 'Y'
  from ben_per_in_ler pil
  where pil.person_id = p_person_id
  and pil.per_in_ler_stat_cd in ('STRTD','PROCD')
  and pil.lf_evt_ocrd_dt < p_effective_date;

Line: 57

  select 'Y'
  from ben_per_in_ler pil
  where pil.person_id = p_person_id
  and pil.per_in_ler_stat_cd in ('STRTD','PROCD')
  and pil.lf_evt_ocrd_dt < p_effective_date
  and pil.lf_evt_ocrd_dt > p_max_fpd;

Line: 65

  select max(final_process_date)
  from per_all_assignments_f asg,per_periods_of_service pps
  where
  asg.period_of_service_id = pps.period_of_service_id
  and asg.effective_end_date <> hr_api.g_eot
  and asg.person_id = p_person_id;