APPS.PAY_RETRO_COMP_USAGE_INTERNAL SQL Statements

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

Line: 44

    select
      rcu1.retro_component_usage_id
     ,rcu1.retro_component_id
     ,rcu1.creator_id
     ,rcu1.creator_type
     ,rcu1.default_component
     ,rcu1.reprocess_type
     ,etp.business_group_id
     ,etp.legislation_code
    from
      pay_element_types_f etp
     ,pay_retro_component_usages rcu1
    where
        etp.element_type_id = p_element_type_id
    and p_effective_date between etp.effective_start_date
    and etp.effective_end_date
    and rcu1.creator_type = 'EC'
    and rcu1.creator_id = etp.classification_id
    and not exists
          (select null from pay_retro_component_usages rcu2
           where rcu2.creator_id = etp.element_type_id
             and rcu2.creator_type = 'ET')
    ;

Line: 72

    select
      element_span_usage_id
     ,time_span_id
     ,retro_component_usage_id
     ,adjustment_type
     ,retro_element_type_id
     ,business_group_id
     ,legislation_code
    from
      pay_element_span_usages
    where
      retro_component_usage_id = p_retro_comp_usage_id
    ;

Line: 169

procedure delete_child_retro_comp_usages
  (p_effective_date                in     date
  ,p_element_type_id               in     number
  ) is
  --
  -- Declare cursors and local variables
  --
  --Bug#4075607. Takes in leg code and business group id as parameters.

  cursor csr_rcu(p_legislation_code varchar2, p_business_group_id number)
  is
    select
      retro_component_usage_id
     ,object_version_number
    from
      pay_retro_component_usages
    where
        creator_id = p_element_type_id
    and nvl(legislation_code, -1) = p_legislation_code
    and nvl(business_group_id , -1) = p_business_group_id
    and creator_type = 'ET'
    ;

Line: 196

    select
      element_span_usage_id
     ,object_version_number
    from
      pay_element_span_usages
    where
        retro_component_usage_id = p_retro_component_usage_id
    ;

Line: 205

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

Line: 261

end delete_child_retro_comp_usages;

Line: 284

    Select nvl(etp.business_group_id, -1)
          ,nvl(etp.legislation_code, -1)
          ,etp.classification_id
     Into
         x_business_group_id
        ,x_legislation_code
        ,x_classification_id
     From pay_element_types_f etp
    Where etp.element_type_id = p_element_type_id
      And p_effective_date between etp.effective_start_date and etp.effective_end_date ;