APPS.PAY_US_DEDN_TEMPLATE_WRAPPER SQL Statements

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

Line: 51

   select parameter_value
     from pay_action_parameters
    where parameter_name = 'US_ADVANCED_WAGE_ATTACHMENT';

Line: 58

   select status
     from pay_upgrade_definitions pud,
          pay_upgrade_status pus
    where pud.short_name = 'US_INV_DEDN_UPGRADE'
      and pus.upgrade_definition_id = pud.upgrade_definition_id
      and pus.business_group_id = cp_business_group_id;

Line: 247

PROCEDURE delete_deduction_element
         (p_business_group_id       in  number
         ,p_element_type_id         in  number
         ,p_element_name            in  varchar2
         ,p_classification_name     in  varchar2
         ,p_category                in  varchar2
         ,p_processing_priority     in  number
         ,p_amount_rule             in  varchar2
         ,p_series_ee_bond          in  varchar2
         ,p_arrearage               in  varchar2
         ,p_stop_rule               in  varchar2
         ,p_calculation_ele_id      in  number
         ,p_vol_dedns_baltype_id    in  number
         ,p_primary_baltype_id      in  number
         ,p_accrued_baltype_id      in  number
         ,p_arrears_baltype_id      in  number
         ,p_not_taken_baltype_id    in  number
         ,p_tobondpurch_baltype_id  in  number
         ,p_able_baltype_id         in  number
         ,p_additional_baltype_id   in  number
         ,p_replacement_baltype_id  in  number
         ,p_special_inputs_ele_id   in  number
         ,p_special_features_ele_id in  number
         ,p_verifier_ele_id         in  number
         ,p_eff_start_date          in  date
         ,p_eff_end_date            in  date
         ) IS
   --
   l_proc           varchar2(80);

Line: 279

   select template_id
     from pay_element_templates
    where base_name         = p_element_name
      and business_group_id = p_business_group_id
      and template_type     = 'U';

Line: 286

   select element_type_extra_info_id
         ,object_version_number
     from pay_element_type_extra_info
    where element_type_id          = p_element_type_id
      and information_type         = 'PQP_US_PRE_TAX_DEDUCTIONS'
      and eei_information_category = 'PQP_US_PRE_TAX_DEDUCTIONS';

Line: 294

   l_proc := g_proc||'.delete_deduction_element';

Line: 306

      hr_us_garn_gen.delete_dedn
     (p_business_group_id  => p_business_group_id
     ,p_ele_type_id        => p_element_type_id
     ,p_ele_name           => p_element_name
     ,p_ele_priority       => p_processing_priority
     ,p_ele_info_10        => p_primary_baltype_id
     ,p_ele_info_11        => p_accrued_baltype_id
     ,p_ele_info_12        => p_arrears_baltype_id
     ,p_ele_info_13        => p_not_taken_baltype_id
     ,p_ele_info_14        => p_tobondpurch_baltype_id
     ,p_ele_info_15        => p_able_baltype_id
     ,p_ele_info_16        => p_additional_baltype_id
     ,p_ele_info_17        => p_replacement_baltype_id
     ,p_ele_info_18        => p_special_inputs_ele_id
     ,p_ele_info_19        => p_special_features_ele_id
     ,p_ele_info_20        => p_verifier_ele_id
     ,p_ele_info_5         => p_calculation_ele_id
     ,p_ele_info_8         => p_vol_dedns_baltype_id
     ,p_del_sess_date      => p_eff_start_date
     ,p_del_val_start_date => p_eff_start_date
     ,p_del_val_end_date   => p_eff_end_date
      );

Line: 334

      pay_us_user_init_dedn.delete_user_init_template
     (p_business_group_id  => p_business_group_id
     ,p_ele_type_id        => p_element_type_id
     ,p_ele_name           => p_element_name
     ,p_effective_date     => p_eff_start_date
      );

Line: 343

         pay_element_extra_info_api.delete_element_extra_info
        (p_validate                   => false
        ,p_element_type_extra_info_id => c2_rec.element_type_extra_info_id
        ,p_object_version_number      => c2_rec.object_version_number
            );

Line: 382

  end delete_deduction_element;