APPS.PA_EMPLOYEE_COST_RATE SQL Statements

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

Line: 8

  select 'X'
  from pa_compensation_details a, pa_compensation_details b
  where a.person_id = v_person_id
  and   b.person_id = v_person_id
  and   a.rowid <> b.rowid
  and ((a.start_date_active
        between b.start_date_active
        and nvl(b.end_date_active,a.start_date_active +1))
  or   (a.end_date_active
        between b.start_date_active
        and nvl(b.end_date_active,b.end_date_active +1))
  or   (b.start_date_active
        between a.start_date_active
        and nvl(a.end_date_active,b.start_date_active +1))
      );