APPS.PAY_NO_EXPIRY_SUPPORT SQL Statements

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

Line: 20

   SELECT TRUNC(ADD_MONTHS(p_date, DECODE(MOD(TO_CHAR(p_date, 'MM'),2),
                                    0, 1,
                                       2)), 'MM')
   INTO   l_return_val
   FROM   pay_payroll_actions
   WHERE  payroll_action_id = p_pactid
   AND    effective_date = p_date;