APPS.AR_CMGT_REASSIGN_CONC SQL Statements

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

Line: 62

         UPDATE ar_cmgt_case_folders
         SET    credit_analyst_id = l_credit_analyst_id_to
         WHERE  credit_analyst_id = l_credit_analyst_id_from
         AND    status in ('CREATED','SAVED');

Line: 73

         UPDATE ar_cmgt_credit_requests
         SET    credit_analyst_id = l_credit_analyst_id_to
         WHERE  credit_analyst_id = l_credit_analyst_id_from
         AND    status in ('IN_PROCESS','SAVED','SUBMIT');

Line: 98

         UPDATE ar_cmgt_case_folders
         SET    credit_analyst_id = l_credit_analyst_id_to
         WHERE  credit_analyst_id = l_credit_analyst_id_from
         AND    creation_date_time between NVL(l_start_date,creation_date_time)
                                           AND NVL(l_end_date,creation_date_time)
         AND    status in ('CREATED','SAVED');

Line: 111

         UPDATE ar_cmgt_credit_requests
         SET    credit_analyst_id = l_credit_analyst_id_to
         WHERE  credit_analyst_id = l_credit_analyst_id_from
         AND    creation_date between NVL(l_start_date,creation_date)
                                           AND NVL(l_end_date,creation_date)
         AND    status in ('IN_PROCESS','SAVED','SUBMIT');

Line: 126

       UPDATE hz_customer_profiles
       SET    credit_analyst_id = l_credit_analyst_id_to
       WHERE  credit_analyst_id = l_credit_analyst_id_from;