APPS.PAY_IN_EXC SQL Statements

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

Line: 37

   SELECT   TP.end_date + 1
     FROM   per_time_periods    TP
          , pay_payroll_actions PACT
    WHERE   PACT.payroll_action_id = p_pactid
      AND   PACT.payroll_id        = TP.payroll_id
      AND   p_date BETWEEN TP.start_date AND TP.end_date;