APPS.PAY_US_EARN_TEMPL_WRAPPER SQL Statements

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

Line: 33

   SELECT parameter_value
    FROM  pay_action_parameters
   WHERE  parameter_name = 'US_ADVANCE_EARNING_TEMPLATE';

Line: 38

   SELECT name
    FROM per_business_groups
   WHERE business_group_id = p_bg_id;

Line: 43

   SELECT formula_id
     FROM ff_formulas_f
    WHERE formula_name = p_formula_name
      AND legislation_code = 'US';

Line: 184

      l_ele_type_id := hr_user_init_earn.do_insertions
         (p_ele_name              => p_ele_name
         ,p_ele_reporting_name    => p_ele_reporting_name
         ,p_ele_description       => p_ele_description
         ,p_ele_classification    => p_ele_classification
         ,p_ele_category          => p_ele_category
         ,p_ele_ot_base           => p_ele_ot_base
         ,p_flsa_hours            => p_flsa_hours
         ,p_ele_processing_type   => p_ele_processing_type
         ,p_ele_priority          => p_ele_priority
         ,p_ele_standard_link     => p_ele_standard_link
         ,p_ele_calc_ff_id        => l_ele_calc_ff_id
         ,p_ele_calc_ff_name      => l_ele_calc_ff_name
         ,p_sep_check_option      => p_sep_check_option
         ,p_dedn_proc             => p_dedn_proc
         ,p_mix_flag              => p_mix_flag
         ,p_reduce_regular        => p_reduce_regular
         ,p_ele_eff_start_date    => p_ele_eff_start_date
         ,p_ele_eff_end_date      => p_ele_eff_end_date
         ,p_bg_id                 => p_bg_id
         ,p_termination_rule      => p_termination_rule
         );

Line: 417

PROCEDURE delete_earnings_element
                       (p_business_group_id       in number
                       ,p_ele_type_id             in number
                       ,p_ele_name                in varchar2
                       ,p_ele_priority            in number
                       ,p_ele_primary_baltype_id  in varchar2     default null
                       ,p_ele_info_12             in varchar2     default null
                       ,p_session_date            in date
                       ,p_eff_start_date          in date
                       ,p_eff_end_date            in date
                       ,p_ele_classification      in varchar2
) IS
--
   l_proc           varchar2(80) := 'pay_us_earn_temp_wrapper';

Line: 435

   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: 448

  l_proc := l_proc||'.delete_earnings_element';

Line: 456

  /*    pay_us_earnings_template.delete_ele_template_objects
           (p_business_group_id  => p_business_group_id
           ,p_ele_type_id        => p_ele_type_id
           ,p_ele_name           => p_ele_name
           ,p_effective_date     => p_eff_start_date
           );

Line: 463

      hr_utility.trace('Calling global package for delete');

Line: 464

      PAY_ELEMENT_TEMPLATE_USER_INIT.delete_element
      (
        p_validate => FALSE
       ,p_template_id => l_template_id
      );

Line: 490

END delete_earnings_element;