APPS.GHR_VALIDATE_PAYWSMEE SQL Statements

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

Line: 11

  SELECT tpe.start_date
  FROM   per_time_periods tpe
  WHERE  tpe.payroll_id = p_payroll_id
  AND    tpe.start_date >= p_wgi_due_date
  ORDER BY tpe.start_date;

Line: 32

  SELECT 1
  FROM   per_time_periods tpe
  WHERE  tpe.payroll_id = p_payroll_id
  AND    tpe.start_date = p_date;