APPS.HRBISOFO SQL Statements

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

Line: 35

  select job.job_id
  from	 per_people_x       peo
  ,	 per_jobs           job
  ,	 per_assignments_x  asg
  ,	 per_job_extra_info inf
  ,	 hr_lookups         lkp
  where  lkp.lookup_type = 'JOB_CATEGORIES'
  and    lkp.lookup_code = inf.jei_information1
  and    inf.jei_information1 = 'RG'
  and    inf.information_type = 'Job Category'
  and    job.job_id = inf.job_id
  and    job.job_id = asg.job_id
  and    trunc(sysdate) between asg.effective_start_date and asg.effective_end_date
  and    peo.person_id = asg.person_id
  and    peo.person_id = p_person_id
  order by 1,decode(asg.primary_flag,'Y',1,2),asg.effective_start_date;