APPS.PAY_US_EARNINGS_TEMPLATE SQL Statements

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

Line: 108

   SELECT element_type_id,
          object_version_number
   FROM   pay_shadow_element_types
   WHERE  element_name = p_ele_name
   AND    template_id  = p_template_id;

Line: 117

   SELECT template_id
   FROM   pay_element_templates
   WHERE  template_name    = p_template_name
   AND    legislation_code = p_legislation_code
   AND    template_type    = 'T'
   AND    business_group_id IS NULL;

Line: 128

   SELECT balance_dimension_id
   FROM pay_balance_dimensions
   WHERE dimension_name = 'Assignment within Government Reporting Entity Run'
   AND legislation_code = 'US';

Line: 134

   SELECT formula_text
   FROM   pay_shadow_formulas
   WHERE  formula_name = p_formula_name;

Line: 139

   SELECT default_priority
   FROM   pay_element_classifications
   WHERE  classification_name = p_classification_name;

Line: 144

   SELECT element_type_id
   FROM   pay_element_types_f
   WHERE  upper(element_name) = upper(p_element_name)
   AND    legislation_code = 'US';

Line: 151

   SELECT input_value_id
   FROM   pay_input_values_f
   WHERE  element_type_id = p_element_type_id
   AND    upper(NAME) = upper(p_input_val_name);

Line: 159

   SELECT status_processing_rule_id
   FROM   pay_status_processing_rules_f
   WHERE  element_type_id = p_element_type_id
   AND    business_group_id = p_bg_id;

Line: 406

   pay_shadow_element_api.update_shadow_element
     (p_validate                     => FALSE
     ,p_effective_date               => p_ele_eff_start_date
     ,p_element_type_id              => l_element_type_id
     ,p_element_name                 => p_ele_name
     ,p_classification_name          => p_ele_classification
     ,p_description                  => p_ele_description
     ,p_reporting_name               => p_ele_reporting_name
     ,p_processing_type              => NVL(p_ele_processing_type,
                                                  hr_api.g_varchar2)
     ,p_standard_link_flag           => NVL(p_ele_standard_link,
                                                  hr_api.g_varchar2)
     ,p_multiple_entries_allowed_fla => l_multiple_entries
     ,p_post_termination_rule        => p_termination_rule
     , p_skip_formula                => l_skip_formula
     ,p_element_information_category => l_info_category --'US_SUPPLEMENTAL EARNINGS'
     ,p_element_information1         => NVL(p_ele_category, hr_api.g_varchar2)
     ,p_element_information8         => NVL(p_ele_ot_base, hr_api.g_varchar2)
     ,p_element_information11        => NVL(p_flsa_hours, hr_api.g_varchar2)
     ,p_element_information13        => NVL(p_reduce_regular, hr_api.g_varchar2)
     ,p_element_information14        => NVL(p_special_input_flag, hr_api.g_varchar2)
     ,p_element_information15        => NVL(p_stop_reach_rule, hr_api.g_varchar2)
     ,p_object_version_number        => l_ovn
     );

Line: 441

            pay_shadow_element_api.update_shadow_element
                (p_validate              => FALSE
                ,p_reporting_name        => p_ele_reporting_name||' SF'
                ,p_classification_name   => p_ele_classification
                ,p_effective_date        => p_ele_eff_start_date
                ,p_element_type_id       => l_element_type_id
                ,p_description           => 'Special Features element for '||
				                                          p_ele_name
                ,p_relative_processing_priority =>l_sf_rel_priority
                ,p_element_information_category => l_info_category
                ,p_element_information1  => NVL(p_ele_category, hr_api.g_varchar2)
                ,p_element_information8  => NVL(p_ele_ot_base, hr_api.g_varchar2)
                ,p_object_version_number => l_ovn
            );

Line: 467

       pay_shadow_element_api.update_shadow_element
          (p_validate                 => FALSE
          ,p_reporting_name           => p_ele_reporting_name ||' SI'
          ,p_classification_name      => p_ele_classification
          ,p_effective_date           => p_ele_eff_start_date
          ,p_element_type_id          => l_element_type_id
          ,p_description              => 'Special Inputs element for '||
		                                      p_ele_name
          ,p_relative_processing_priority => l_si_rel_priority
          ,p_element_information_category => l_info_category
          ,p_element_information1     => NVL(p_ele_category, hr_api.g_varchar2)
          ,p_element_information8     => NVL(p_ele_ot_base, hr_api.g_varchar2)
          ,p_object_version_number    => l_ovn
         );

Line: 517

   UPDATE pay_element_types_f
   SET    element_name           = p_ele_name
          ,element_information10 = l_pri_bal_id
          ,element_information12 = l_hours_bal_id
   WHERE  element_type_id       = l_pri_ele_type_id
   AND    business_group_id     = p_bg_id;

Line: 539

      UPDATE pay_input_values_f
      SET    formula_id       = t_form_id(i)
            ,warning_or_error = t_we_flag(i)
            ,default_value    = t_def_val(i)
      WHERE  input_value_id   = t_ipv_id(i);

Line: 660

   SELECT element_type_id
   FROM   pay_element_types_f
   WHERE  element_name          = p_object_name
   AND  business_group_id     = g_bg_id;

Line: 666

   SELECT piv.input_value_id
   FROM   pay_input_values_f piv
   WHERE  piv.NAME              = p_object_name
   AND  piv.element_type_id   = p_object_id
   AND  piv.business_group_id = g_bg_id;

Line: 673

   SELECT balance_type_id
   FROM   pay_balance_types pbt
   WHERE  pbt.balance_name                            = p_object_name
   AND  NVL(pbt.business_group_id, g_bg_id)           = g_bg_id
   AND  NVL(pbt.legislation_code, g_legislation_code) = g_legislation_code;

Line: 702

PROCEDURE delete_ele_template_objects
           (p_business_group_id     IN NUMBER
           ,p_ele_type_id           IN NUMBER
           ,p_ele_name              IN VARCHAR2
           ,p_effective_date		IN DATE
           ) IS
   --
   l_template_id   NUMBER(9);

Line: 711

   l_proc  VARCHAR2(60) := 'pay_earnings_template.delete_ele_template_objects';

Line: 714

   SELECT template_id
   FROM   pay_element_templates
   WHERE  base_name         = p_ele_name
   AND  business_group_id = p_business_group_id
   AND  template_type     = 'U';

Line: 727

   pay_element_template_api.delete_user_structure
     (p_validate                =>   FALSE
     ,p_drop_formula_packages   =>   TRUE
     ,p_template_id             =>   l_template_id);

Line: 733

END delete_ele_template_objects;