APPS.PQP_GB_PSI_WPS_HISTORY SQL Statements

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

Line: 186

          debug('update_type       :'||g_pay_proc_evt_tab(i).update_type      ,20);

Line: 312

        ELSIF l_prev_event_dtl_rec.update_type <>   g_prev_event_dtl_rec.update_type THEN
            l_flag  :=  'N';

Line: 526

  l_update_type                  VARCHAR2(5);

Line: 613

      l_update_type       :=  g_pay_proc_evt_tab(l_curr_evt_index).update_type;

Line: 625

        debug('update_type       :'||g_pay_proc_evt_tab(l_curr_evt_index).update_type      ,20);

Line: 670

          IF l_chg_table = 'PER_ALL_ASSIGNMENTS_F' AND l_update_type = 'I'
          THEN
            l_return        := 'N'; -- this event is because of PQP_GB_PSI_NEW_HIRE event group.

Line: 748

                              IF l_update_type = 'C'
                              THEN
                                    debug('correction event');

Line: 798

                                                   IF l_update_type = 'E' and l_return = 'Y'
                                                   THEN
                                                      l_wps_eff_end_date := p_effective_date + 1;

Line: 982

    l_update_type          VARCHAR2(5);

Line: 1006

      l_update_type       :=  g_pay_proc_evt_tab(l_curr_evt_index).update_type;

Line: 1014

      debug('l_update_type   :-'||l_update_type);

Line: 1016

      IF l_element_type_id <> g_pension_element_type_id and l_update_type = 'E'
         and l_end_date_basic_ele = 'N'
      THEN
         l_g_effective_date := p_effective_date + 1;

Line: 1029

                        debug('l_update_type:-'||l_update_type);

Line: 1030

                        IF l_update_type = 'C'
                        THEN
                              debug('correction event');

Line: 1158

      l_update_type          VARCHAR2(5);

Line: 1183

      l_update_type       :=  g_pay_proc_evt_tab(l_curr_evt_index).update_type;

Line: 1192

      debug('l_update_type:-'||l_update_type);

Line: 1195

      IF l_element_type_id <> g_pension_element_type_id and l_update_type = 'E'
      and l_end_date_basic_ele = 'N'
      THEN
         l_g_effective_date := p_effective_date + 1;

Line: 1208

      IF (l_update_type = 'E' AND l_element_type_id = g_pension_element_type_id)  --For Bug 6071527
      or g_is_terminated = 'Y'
      THEN
        OPEN get_wps_percent_cont_per
                                          (p_element_entry_id => l_chg_surrogate_key
                                          ,p_effective_date   => p_effective_date
              ,p_input_value_name => 'Opt Out Date'
                                          );

Line: 1310

      l_update_type          VARCHAR2(5);