APPS.PAY_IP_RUN_BALANCE_UPGRADE SQL Statements

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

Line: 41

 gtt_updated_balances character_data_table;

Line: 49

 **              as a parameter needs to be updated.
 **
 **
 ****************************************************************************/


 PROCEDURE qualify_balance(p_object_id  in        varchar2
                          ,p_qualified out nocopy varchar2)
 IS


   cursor c_primary_balance(cp_element_type_id  in number) is
        select distinct 'Y'
        from pay_element_types_f pet,
             pay_balance_types pbt,
             pay_input_values_f piv
        where pbt.input_value_id = piv.input_value_id
          and piv.element_type_id = pet.element_type_id
          and pbt.legislation_code is null
          and pet.business_group_id = pbt.business_group_id
	  and pet.element_name = pbt.balance_name
	  and pet.element_type_id = p_object_id;

Line: 101

    select pbg.legislation_code
       from pay_element_types_f pet,
            per_business_groups pbg
       where pet.element_type_id = cp_element_type_id
         and pet.business_group_id = pbg.business_group_id
	 and rownum = 1;

Line: 109

     select distinct pbt.balance_type_id,
                     pec.classification_name,
		     pet.effective_start_date,
		     pbt.business_group_id
        from pay_element_types_f pet,
             pay_input_values_f piv,
             pay_balance_types  pbt,
             pay_element_classifications pec
       where pet.element_type_id = cp_element_type_id
         and pet.element_type_id = piv.element_type_id
         and pbt.input_value_id = piv.input_value_id
         and pet.element_name = pbt.balance_name
	 and pet.classification_id = pec.classification_id;

Line: 126

      select pdb.defined_balance_id
         from pay_defined_balances pdb,
	      pay_balance_types pbt,
	      pay_balance_dimensions pbd
         where pbt.balance_type_id = cp_bal_type_id
	   and pbd.database_item_suffix = cp_bal_dim
	   and pbd.legislation_code = cp_legislation_code
	   and pdb.balance_type_id = pbt.balance_type_id
	   and pdb.balance_dimension_id = pbd.balance_dimension_id;

Line: 137

       select rule_mode
         from pay_legislation_rules
	 where legislation_code = cp_legislation_code
	   and rule_type = 'TAX_UNIT';

Line: 144

       select balance_dimension_id
          from pay_balance_dimensions
	  where database_item_suffix = cp_database_item_suffix
	    and legislation_code = cp_legislation_code;

Line: 197

      update pay_balance_types
         set balance_category_id = (SELECT BALANCE_CATEGORY_ID
                                 FROM PAY_BALANCE_CATEGORIES_F
				 WHERE CATEGORY_NAME = 'Earnings'
				   AND legislation_code = lv_legislation_code)
         where balance_type_id = ln_balance_type_id;

Line: 204

      hr_utility.trace('Balance Category Updated to Earnings for primary balance ' || ln_balance_type_id);

Line: 211

      update pay_balance_types
         set balance_category_id = (SELECT BALANCE_CATEGORY_ID
                                 FROM PAY_BALANCE_CATEGORIES_F
				 WHERE CATEGORY_NAME = 'Deductions'
				   AND legislation_code = lv_legislation_code)
         where balance_type_id = ln_balance_type_id;

Line: 218

      hr_utility.trace('Balance Category Updated to Deductions for primary  balance ' || ln_balance_type_id);

Line: 237

           /* Insert defined balance for _ASG_TU_RUN */
           pay_defined_balances_pkg.insert_row
           (x_rowid                        => lv_rowid
           ,x_defined_balance_id           => ln_def_balance_id
           ,x_business_group_id            => ln_business_grp_id
           ,x_legislation_code             => null
           ,x_balance_type_id              => ln_balance_type_id
           ,x_balance_dimension_id         => ln_bal_dim_id
           ,x_force_latest_balance_flag    => null
           ,x_legislation_subgroup         => null);

Line: 248

           hr_utility.trace('Inserted defined balance for _ASG_TU_RUN ' || ln_def_balance_id);

Line: 251

          update pay_defined_balances
          set save_run_balance = 'Y'
          where defined_balance_id = ln_def_balance_id ;

Line: 255

          hr_utility.trace('Save run balance updated for defined balance ' || ln_def_balance_id);

Line: 267

     update pay_defined_balances
     set save_run_balance = 'Y'
     where defined_balance_id = ln_def_balance_id ;

Line: 271

     hr_utility.trace('Save run balance updated for defined balance ' || ln_def_balance_id);