APPS.PAY_PROGRESS_PKG SQL Statements

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

Line: 28

      SELECT    NVL(SUM(DECODE(action_status,'C',1,'S',1,0)),0)   completed,
                NVL(SUM(DECODE(action_status,'E',1,0)),0)   in_error,
                NVL(SUM(DECODE(action_status,'M',1,0)),0)   marked_for_retry,
                NVL(SUM(DECODE(action_status,'U',1,0)),0)   unprocessed
      FROM      pay_assignment_actions
      WHERE     payroll_action_id = cp_id
      AND       source_action_id IS NULL;

Line: 38

      SELECT    ppa.creation_date start_time,
                NVL(fcr.actual_completion_date,
                  DECODE(cp_done,'Y',ppa.last_update_date,SYSDATE)
                ) end_time,
                SYSDATE                                             current_time
      FROM      fnd_concurrent_requests fcr,pay_payroll_actions ppa
      WHERE     fcr.request_id(+) = ppa.request_id
      AND       ppa.payroll_action_id = cp_id;

Line: 51

      SELECT    payroll_action_id,
                action_type,
                action_status,
                consolidation_set_id,
                display_run_number,
                element_set_id,
                assignment_set_id,
                effective_date,
                comments
      FROM      pay_payroll_actions
      WHERE     payroll_action_id = cp_id;

Line: 92

      g_sample_list.Delete;

Line: 171

  g_sample_list.Delete;