APPS.PAY_PROC_ENVIRONMENT_PKG SQL Statements

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

Line: 5

   update_pop_action_status

   This procedure updates the action population then issues a commit.
*/
procedure update_pop_action_status(p_payroll_action_id in number,
                                   p_status in varchar2)
is
begin
--
   UPDATE PAY_PAYROLL_ACTIONS PAC
   SET    PAC.ACTION_POPULATION_STATUS = p_status,
          PAC.LAST_UPDATE_DATE         = SYSDATE,
          PAC.LAST_UPDATED_BY          = g_user_id,
          PAC.LAST_UPDATE_LOGIN        = g_login_id
   WHERE  PAC.PAYROLL_ACTION_ID        = p_payroll_action_id;

Line: 23

end update_pop_action_status;