APPS.PA_DATE_OVERLAP_CHECKS SQL Statements

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

Line: 23

      select  a.labor_cost_multiplier_name
        from  pa_labor_cost_multipliers a,
              pa_labor_cost_multipliers b
       where  a.labor_cost_multiplier_name = b.labor_cost_multiplier_name
         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, a.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))
         and   a.rowid <> b.rowid ;