APPS.PER_RU_CURRENCY_CONVERSION SQL Statements

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

Line: 12

    SELECT hoi.organization_id, hou.name
      FROM hr_organization_units hou,
           hr_organization_information hoi,
           hr_organization_information hoi1
     WHERE hoi.org_information_context  = 'Business Group Information'
       AND hoi.org_information9         = 'RU'
       AND hoi.org_information10        in (cp_old_currency, cp_new_currency)
       AND hou.organization_id          = hoi.organization_id
       AND hou.organization_id          = hoi1.organization_id
       AND hoi1.org_information_context = 'CLASS'
       AND hoi1.org_information1        = 'HR_BG'
       AND hoi1.org_information2        = 'Y'
       AND NOT EXISTS ( SELECT 1
                          FROM pay_patch_status pps
                         WHERE pps.patch_number = to_char(hoi.organization_id)
                           AND pps.patch_name = 'Currency_Conversion_for_Russia'
                           AND pps.legislation_code = 'RU'
                           AND pps.status = 'C' );

Line: 32

    SELECT pgi.assignment_action_id
      FROM pay_gl_interface pgi
          ,pay_payroll_actions ppa
     WHERE ppa.business_group_id     = cp_business_group_id
       AND pgi.run_payroll_action_id = ppa.payroll_action_id;

Line: 39

    SELECT template_id
      FROM pay_element_templates
     WHERE legislation_code = 'RU';

Line: 44

    SELECT template_id
      FROM pay_element_templates
     WHERE business_group_id = cp_business_group_id;

Line: 49

    SELECT rowid
      FROM ben_pil_elctbl_chc_popl
     WHERE business_group_id = cp_business_group_id;

Line: 54

    SELECT rowid
      FROM ben_elig_per_f
     WHERE business_group_id = cp_business_group_id;

Line: 81

         UPDATE pay_balance_types
            SET currency_code    = lv_new_currency
          WHERE legislation_code = 'RU'
            AND currency_code    = lv_old_currency;

Line: 86

         UPDATE pay_element_types_f
            SET input_currency_code    = decode(input_currency_code,
                                                lv_old_currency,
                                                lv_new_currency,
                                                input_currency_code )
               ,output_currency_code   = decode(output_currency_code,
                                                lv_old_currency,
                                                lv_new_currency,
                                                output_currency_code )
          WHERE legislation_code       = 'RU'
            AND ( input_currency_code  = lv_old_currency OR
                  output_currency_code = lv_old_currency );

Line: 99

         UPDATE pay_legislation_rules
            SET rule_mode        = lv_new_currency
          WHERE legislation_code = 'RU'
            AND rule_type        = 'DC'
            AND rule_mode        = lv_old_currency;

Line: 105

         UPDATE pay_leg_setup_defaults
            SET currency_code    = lv_new_currency
          WHERE legislation_code = 'RU'
            AND currency_code    = lv_old_currency;

Line: 110

         UPDATE pay_monetary_units
            SET currency_code    = lv_new_currency
          WHERE legislation_code = 'RU'
            AND currency_code    = lv_old_currency;

Line: 115

         UPDATE pay_payment_types
            SET currency_code  = lv_new_currency
          WHERE territory_code = 'RU'
            AND currency_code  = lv_old_currency;

Line: 120

         UPDATE pay_pss_transaction_steps
            SET currency_code  = lv_new_currency
          WHERE territory_code = 'RU'
            AND currency_code  = lv_old_currency;

Line: 125

         UPDATE pqp_exception_reports
            SET currency_code    = lv_new_currency
          WHERE legislation_code = 'RU'
            AND currency_code    = lv_old_currency;

Line: 133

           UPDATE pay_shadow_balance_types
              SET currency_code = lv_new_currency
            WHERE template_id   = tmplt.template_id
              AND currency_code = lv_old_currency;

Line: 138

           UPDATE pay_shadow_element_types
              SET input_currency_code    = decode(input_currency_code,
                                                  lv_old_currency,
                                                  lv_new_currency,
                                                  input_currency_code )
                 ,output_currency_code   = decode(output_currency_code,
                                                  lv_old_currency,
                                                  lv_new_currency,
                                                  output_currency_code )
            WHERE template_id   = tmplt.template_id
              AND ( input_currency_code  = lv_old_currency OR
                    output_currency_code = lv_old_currency );

Line: 159

      UPDATE pay_balance_types
         SET currency_code     = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND currency_code     = lv_old_currency;

Line: 166

      UPDATE pay_element_types_f
         SET input_currency_code    = decode(input_currency_code,
                                             lv_old_currency,
                                             lv_new_currency,
                                             input_currency_code )
            ,output_currency_code   = decode(output_currency_code,
                                             lv_old_currency,
                                             lv_new_currency,
                                             output_currency_code )
       WHERE business_group_id      = ln_business_group_id
         AND ( input_currency_code  = lv_old_currency OR
               output_currency_code = lv_old_currency );

Line: 181

      UPDATE pay_monetary_units
         SET currency_code     = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND currency_code     = lv_old_currency;

Line: 188

      UPDATE pay_org_payment_methods_f
         SET currency_code     = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND currency_code     = lv_old_currency;

Line: 195

      UPDATE per_qualifications
         SET fee_currency      = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND fee_currency      = lv_old_currency;

Line: 202

      UPDATE per_recruitment_activities
         SET currency_code     = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND currency_code     = lv_old_currency;

Line: 209

      UPDATE per_work_incidents pwi
         SET compensation_currency = lv_new_currency
       WHERE compensation_currency = lv_old_currency
         AND EXISTS ( SELECT 1
                        FROM per_all_people_f ppf
                       WHERE ppf.person_id = pwi.person_id
                         AND ppf.business_group_id = ln_business_group_id );

Line: 219

      UPDATE per_salary_survey_lines
         SET currency_code     = lv_new_currency
       WHERE currency_code     = lv_old_currency;

Line: 225

      UPDATE pqh_accommodations_f
         SET rental_value_currency = lv_new_currency
       WHERE business_group_id     = ln_business_group_id
         AND rental_value_currency = lv_old_currency;

Line: 232

      UPDATE pqh_assign_accommodations_f
         SET indemnity_currency = lv_new_currency
       WHERE business_group_id  = ln_business_group_id
         AND indemnity_currency = lv_old_currency;

Line: 239

      UPDATE pqh_fr_validations
         SET deduction_currency_code = decode( deduction_currency_code,
                                               lv_old_currency,
                                               lv_new_currency,
                                               deduction_currency_code )
            ,employee_currency_code  = decode( employee_currency_code,
                                               lv_old_currency,
                                               lv_new_currency,
                                               employee_currency_code )
            ,employer_currency_code  = decode( employer_currency_code,
                                               lv_old_currency,
                                               lv_new_currency,
                                               employer_currency_code )
       WHERE business_group_id = ln_business_group_id
         AND (  deduction_currency_code = lv_old_currency OR
                employee_currency_code  = lv_old_currency OR
                employer_currency_code  = lv_old_currency );

Line: 259

      UPDATE pqh_budgets
         SET currency_code     = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND currency_code     = lv_old_currency;

Line: 266

      UPDATE pqp_exception_reports
         SET currency_code     = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND currency_code     = lv_old_currency;

Line: 273

      UPDATE pqp_vehicle_repository_f
         SET currency_code     = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND currency_code     = lv_old_currency;

Line: 280

      UPDATE pqp_vehicle_details
         SET currency_code     = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND currency_code     = lv_old_currency;

Line: 287

      UPDATE psp_adjustment_control_table
         SET currency_code     = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND currency_code     = lv_old_currency;

Line: 294

      UPDATE psp_distribution_interface
         SET currency_code     = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND currency_code     = lv_old_currency;

Line: 301

      UPDATE psp_payroll_controls
         SET currency_code     = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND currency_code     = lv_old_currency;

Line: 308

      UPDATE psp_payroll_interface
         SET currency_code     = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND currency_code     = lv_old_currency;

Line: 315

      UPDATE ben_actl_prem_f
         SET uom         = decode( uom, lv_old_currency, lv_new_currency, uom )
            ,cr_lkbk_uom = decode( cr_lkbk_uom, lv_old_currency,
                                                lv_new_currency, cr_lkbk_uom )
       WHERE business_group_id = ln_business_group_id
         AND ( uom = lv_old_currency OR cr_lkbk_uom = lv_old_currency );

Line: 324

      UPDATE ben_bnfts_bal_f
         SET uom               = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND uom               = lv_old_currency;

Line: 331

      UPDATE ben_cntng_prtn_elig_prfl_f
         SET pymt_must_be_rcvd_uom = lv_new_currency
       WHERE business_group_id     = ln_business_group_id
         AND pymt_must_be_rcvd_uom = lv_old_currency;

Line: 338

      UPDATE ben_cntng_prtn_prfl_rt_f
         SET pymt_must_be_rcvd_uom = lv_new_currency
       WHERE business_group_id     = ln_business_group_id
         AND pymt_must_be_rcvd_uom = lv_old_currency;

Line: 345

      UPDATE ben_drvbl_fctr_uom
         SET uom_cd            = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND uom_cd            = lv_old_currency;

Line: 352

      UPDATE ben_enrt_prem_rbv
         SET uom               = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND uom               = lv_old_currency;

Line: 359

      UPDATE ben_pgm_f
         SET pgm_uom           = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND pgm_uom           = lv_old_currency;

Line: 366

      UPDATE ben_pil_epe_popl_rbv
         SET uom               = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND uom               = lv_old_currency;

Line: 373

      UPDATE ben_pl_frfs_val_f
         SET uom               = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND uom               = lv_old_currency;

Line: 380

      UPDATE ben_prtt_enrt_rslt_f_rbv
         SET uom               = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND uom               = lv_old_currency;

Line: 387

      UPDATE ben_prtt_prem_f
         SET std_prem_uom      = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND std_prem_uom      = lv_old_currency;

Line: 394

      UPDATE ben_prtt_reimbmt_rqst_f
         SET rqst_amt_uom      = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND rqst_amt_uom      = lv_old_currency;

Line: 401

      UPDATE ben_prtt_prem_by_mo_f
         SET antcpd_prtt_cntr_uom = lv_new_currency
       WHERE business_group_id    = ln_business_group_id
         AND antcpd_prtt_cntr_uom = lv_old_currency;

Line: 408

      UPDATE ben_comp_lvl_fctr
         SET comp_lvl_uom      = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND comp_lvl_uom      = lv_old_currency;

Line: 415

      UPDATE ben_pl_r_oipl_prem_by_mo_f
         SET uom               = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND uom               = lv_old_currency;

Line: 422

      UPDATE BEN_PL_F
         SET nip_pl_uom        = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND nip_pl_uom        = lv_old_currency;

Line: 429

      UPDATE ben_pl_bnf_f
         SET amt_dsgd_uom      = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND amt_dsgd_uom      = lv_old_currency;

Line: 436

      UPDATE ben_pl_r_oipl_asset_f
         SET mkt_val_uom       = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND mkt_val_uom       = lv_old_currency;

Line: 443

      UPDATE ben_crt_ordr
         SET uom               = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND uom               = lv_old_currency;

Line: 450

      UPDATE ben_enrt_prem
         SET uom               = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND uom               = lv_old_currency;

Line: 457

      UPDATE irc_all_recruiting_sites
         SET posting_cost_currency = lv_new_currency
       WHERE posting_cost_currency = lv_old_currency;

Line: 463

      UPDATE irc_search_criteria
         SET salary_currency = lv_new_currency
       WHERE salary_currency = lv_old_currency;

Line: 469

      SELECT count(*)
        INTO ln_ota_act_ver_count
        FROM ota_activity_versions
       WHERE budget_currency_code = lv_old_currency;

Line: 475

         UPDATE ota_activity_versions
            SET budget_currency_code = lv_new_currency
          WHERE budget_currency_code = lv_old_currency;

Line: 482

      UPDATE ota_events
         SET budget_currency_code = decode( budget_currency_code,
                                            lv_old_currency,
                                            lv_new_currency,
                                            budget_currency_code)
            ,currency_code        = decode( currency_code,
                                            lv_old_currency,
                                            lv_new_currency,
                                            currency_code)
       WHERE business_group_id    = ln_business_group_id
         AND ( budget_currency_code = lv_old_currency OR
               currency_code        = lv_old_currency );

Line: 497

      UPDATE ota_price_lists
         SET currency_code     = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND currency_code     = lv_old_currency;

Line: 504

      UPDATE ota_suppliable_resources
         SET currency_code     = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND currency_code     = lv_old_currency;

Line: 511

      UPDATE ota_training_plans
         SET budget_currency   = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND budget_currency   = lv_old_currency;

Line: 518

      UPDATE ota_training_plan_costs
         SET currency_code     = lv_new_currency
       WHERE business_group_id = ln_business_group_id
         AND currency_code     = lv_old_currency;

Line: 530

        UPDATE pay_gl_interface
           SET currency_code        = lv_new_currency
         WHERE assignment_action_id = paygl.assignment_action_id
           AND currency_code        = lv_old_currency;

Line: 549

        UPDATE pay_shadow_balance_types
           SET currency_code = lv_new_currency
         WHERE template_id   = ele_tmplt.template_id
           AND currency_code = lv_old_currency;

Line: 554

        UPDATE pay_shadow_element_types
           SET input_currency_code    = decode(input_currency_code,
                                               lv_old_currency,
                                               lv_new_currency,
                                               input_currency_code )
              ,output_currency_code   = decode(output_currency_code,
                                               lv_old_currency,
                                               lv_new_currency,
                                               output_currency_code )
         WHERE template_id   = ele_tmplt.template_id
           AND ( input_currency_code  = lv_old_currency OR
                 output_currency_code = lv_old_currency );

Line: 576

        UPDATE ben_pil_elctbl_chc_popl
           SET uom   = lv_new_currency
         WHERE rowid = chc.rowid
           AND uom   = lv_old_currency;

Line: 597

        UPDATE ben_elig_per_f
           SET rt_comp_ref_uom = lv_new_currency
         WHERE rowid           = elig.rowid
           AND rt_comp_ref_uom = lv_old_currency;

Line: 613

      UPDATE hr_organization_information
         SET org_information10       = lv_new_currency
       WHERE organization_id         = ln_business_group_id
         AND org_information_context = 'Business Group Information'
         AND org_information10       = lv_old_currency;

Line: 619

      INSERT INTO pay_patch_status
                  (id, patch_number, patch_name, applied_date, status,
                   description, update_date, legislation_code)
      VALUES      (pay_patch_status_s.nextval, to_char(ln_business_group_id),
                   'Currency_Conversion_for_Russia', sysdate, 'C',
                   lv_business_group_name,  sysdate, 'RU');

Line: 647

    SELECT count(*)
      INTO ln_conv_curr_cnt
      FROM hr_organization_units hou,
           hr_organization_information hoi,
           hr_organization_information hoi1
     WHERE hoi.org_information_context  = 'Business Group Information'
       AND hoi.org_information9         = 'RU'
       AND hoi.org_information10        = 'RUR'
       AND hou.organization_id          = hoi.organization_id
       AND hou.organization_id          = hoi1.organization_id
       AND hoi1.org_information_context = 'CLASS'
       AND hoi1.org_information1        = 'HR_BG'
       AND hoi1.org_information2        = 'Y';