APPS.PER_HU_PENSION_OBJECTS SQL Statements

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

Line: 111

  SELECT classification_id
  FROM   pay_element_classifications
  WHERE  classification_name      = 'Information'
  AND    legislation_code         = 'HU';

Line: 117

  SELECT decode(p_ee_element,'Y',nvl(ee_contribution_percent,0),nvl(er_contribution_percent,0))
        ,decode(p_ee_element,'Y',nvl(ee_contribution_fixed_rate,0),nvl(er_contribution_fixed_rate,0))
    FROM pqp_pension_types_f
  WHERE  pension_type_id = p_pension_type
    AND  p_effective_start_date BETWEEN effective_start_date
    AND  effective_end_date;

Line: 646

PROCEDURE delete_pension_objects_swi
  (p_validate                      NUMBER  DEFAULT hr_api.g_false_num
  ,p_element_type_id               IN     NUMBER
  ,p_effective_date                IN     DATE
  ,p_object_version_number         IN     NUMBER
  ,p_return_status                 OUT    NOCOPY VARCHAR2      ) IS
--
-- Variables for API Boolean parameters
  l_validate                      boolean;

Line: 660

  l_proc    varchar2(72) := g_package ||'delete_pension_objects_swi';

Line: 668

  savepoint delete_pension_objects_swi;

Line: 685

  per_hu_pension_objects.delete_pension_objects(
                         p_validate              => l_validate
                        ,p_element_type_id       => p_element_type_id
                        ,p_effective_date        => p_effective_date
                        ,p_object_version_number => p_object_version_number);

Line: 709

    rollback to delete_pension_objects_swi;

Line: 723

    rollback to delete_pension_objects_swi;

Line: 734

END delete_pension_objects_swi;

Line: 740

PROCEDURE delete_pension_objects(p_validate                BOOLEAN DEFAULT FALSE
                                ,p_element_type_id         NUMBER
                                ,p_effective_date          DATE
                                ,p_object_version_number   NUMBER
                                ) IS
--
l_element_type_id   pay_element_types_f.element_type_id%TYPE;

Line: 751

    SELECT business_group_id FROM pay_element_types_f
    WHERE  element_type_id=p_element_type_id
    AND    p_effective_date BETWEEN effective_start_date AND effective_end_date;

Line: 757

    SELECT input_value_id,object_version_number FROM pay_input_values_f
    WHERE   name = p_input_name
    AND     element_type_id = p_element_type_id--l_element_type_id
    AND     business_group_id = l_business_group_id
    AND     p_effective_date BETWEEN effective_start_date AND effective_end_date;

Line: 765

    SELECT element_type_extra_info_id,object_version_number
    FROM   pay_element_type_extra_info
    WHERE  eei_information_category = 'HU_PENSION_SCHEME_INFO'
    AND    element_type_id = p_element_type_id;--l_element_type_id;

Line: 807

    pay_input_value_api.delete_input_value
      (  p_validate                        => p_validate
        ,p_effective_date                  => p_effective_date
        ,p_datetrack_delete_mode           => 'ZAP'
        ,p_input_value_id                  => l_input_value_id
        ,p_object_version_number           => l_inp_ovn -- in/out
        ,p_effective_start_date            => l_effective_start_date -- out
        ,p_effective_end_date              => l_effective_end_date    -- out
        ,p_balance_feeds_warning           => l_balance_feeds_warning -- out
      );

Line: 827

pay_element_extra_info_api.delete_element_extra_info
  (p_validate                      => p_validate
  ,p_element_type_extra_info_id    => l_element_extra_info_id
  ,p_object_version_number         => l_extra_info_ovn
  ) ;

Line: 836

pay_element_types_api.delete_element_type
  (p_validate                        => p_validate
  ,p_effective_date                  => p_effective_date
  ,p_datetrack_delete_mode           => 'ZAP'
  ,p_element_type_id                 => p_element_type_id
  ,p_object_version_number           => l_object_version_number
  ,p_effective_start_date            => l_effective_start_date
  ,p_effective_end_date              => l_effective_start_date
  ,p_balance_feeds_warning           => l_balance_feeds_warning
  ,p_processing_rules_warning        => l_processing_rules_warning
  ) ;

Line: 848

END delete_pension_objects;