APPS.PAY_PROGRESS_PKG SQL Statements

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

Line: 39

      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: 49

      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: 62

      SELECT    payroll_action_id,
                action_type,
                action_status,
                consolidation_set_id,
                display_run_number,
                element_set_id,
                assignment_set_id,
                effective_date,
                dbms_lob.substr(comments,4000,1) comments_1
      FROM      pay_payroll_actions
      WHERE     payroll_action_id = cp_id;

Line: 103

      g_sample_list.Delete;

Line: 133

	-- So l_current_time is wrongly updated to l_end_time which is actual_completion_date from csr_time

    IF l_done = 'Y' and l_end_time IS NOT NULL THEN
        l_current_time := l_end_time;

Line: 186

  g_sample_list.Delete;