APPS.PQP_GB_PSI_BASIC_DATA SQL Statements

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

Line: 138

    g_marital_status_mapping.DELETE;

Line: 184

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

Line: 503

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

Line: 688

           debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 30);

Line: 693

           AND ben_ext_person.g_chg_update_type <> 'I'
           THEN -- this is checking location_event for case (3) and (4)

              l_ret_location := '******';

Line: 847

            debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 30);

Line: 854

            ben_ext_person.g_chg_update_type <> 'I'
            THEN -- this is checking location_event for case (3) and (4)
                l_ret_person_decoration := '********';

Line: 961

               debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 44);

Line: 965

               AND ben_ext_person.g_chg_update_type <> 'I'
               THEN
                  l_ret_title := '******';

Line: 1099

                       AND ben_ext_person.g_chg_update_type = 'I')
                       OR ben_ext_person.g_chg_pay_table <> 'PAY_PERSONAL_PAYMENT_METHODS_F'
                   THEN
                        p_return := 'X';

Line: 1643

            debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 30);

Line: 1647

            AND ben_ext_person.g_chg_update_type <> 'I'
            THEN -- this is checking location_event for case (3) and (4)
              l_ret_prevsur := '********************';

Line: 1686

           debug('ben_ext_person.g_chg_update_type:' || ben_ext_person.g_chg_update_type, 30);

Line: 1691

           AND ben_ext_person.g_chg_update_type <> 'I'
           THEN -- this is checking location_event for case (3) and (4)
             l_ret_midname := '********************';

Line: 1721

           ben_ext_person.g_chg_update_type = 'I'
        THEN
          p_output := 'CUTOVER';