APPS.PAY_RETRO_STATUS_LOAD SQL Statements

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

Line: 91

    select distinct paf.assignment_id
    into l_assignment_id
    from
      per_all_assignments_f paf
     ,per_all_people_f      ppf
    where
        paf.assignment_number = p_assignment_number
    and paf.business_group_id+0 = p_business_group_id
    and ppf.person_id = paf.person_id
  and paf.effective_start_date = (select max(effective_start_date)
                                    from per_all_assignments_f
                                    where assignment_id = paf.assignment_id)
    and nvl(ppf.full_name, hr_api.g_varchar2)
         = nvl(p_full_name, nvl(ppf.full_name, hr_api.g_varchar2));

Line: 173

      select distinct pee.element_entry_id
      into   l_element_entry_id
      from
        pay_element_types_f_tl pettl
       ,pay_element_types_f    pet
       ,pay_element_links_f    pel
       ,pay_element_entries_f  pee
      where
          pettl.element_name = p_element_name
      and pettl.language     = userenv('lang')
      and pet.element_type_id = pettl.element_type_id
      and nvl(pet.business_group_id, p_business_group_id) = p_business_group_id
      and nvl(pet.legislation_code, l_leg_code) = l_leg_code
      and pel.element_type_id = pet.element_type_id
      and pel.business_group_id+0 = p_business_group_id
      and pee.assignment_id       = p_assignment_id
      and pee.element_link_id     = pel.element_link_id
      and pee.creator_type in ('A', 'F', 'H', 'Q', 'SP', 'UT', 'M', 'S')
      ;

Line: 217

      select
        retro_component_id into l_retro_component_id
      from pay_retro_components
      where
          component_name = p_component_name
      and nvl(legislation_code, l_leg_code) = l_leg_code;

Line: 861

procedure update_or_delete_retro_asg
  (p_business_group_id             in     number
  ,p_assignment_number             in     varchar2
  ,p_full_name                     in     varchar2 default null
  ,p_reprocess_date                in     date     default null
  ,p_approval_status               in     varchar2 default null
  ,p_update_or_delete_mode         in     varchar2 default g_update_mode
  ,p_delete_sys_retro_asg          in     varchar2 default 'N'
  )
is
  l_proc                varchar2(72) := g_package||'update_or_delete_retro_asg';

Line: 920

  if p_update_or_delete_mode = g_update_mode then
    --
    pay_retro_status_internal.update_retro_asg
      (p_retro_assignment_id  => l_retro_assignment_id
      ,p_reprocess_date       => nvl(p_reprocess_date, hr_api.g_date)
      ,p_approval_status      => nvl(p_approval_status, hr_api.g_varchar2)
      ,p_owner_type           => pay_retro_status_internal.g_user
      );

Line: 929

  elsif p_update_or_delete_mode = g_delete_mode then
    --
    pay_retro_status_internal.delete_retro_asg
      (p_retro_assignment_id   => l_retro_assignment_id
      ,p_owner_type            => pay_retro_status_internal.g_user
      ,p_delete_sys_retro_asg  => p_delete_sys_retro_asg
      ,p_replaced_retro_asg_id => l_replaced_retro_asg_id
      );

Line: 943

      (l_proc||':chk_update_or_delete_mode' ,false);

Line: 947

end update_or_delete_retro_asg;

Line: 949

procedure update_reprocess_date(
p_business_group_id               in     number
  ,p_assignment_number             in     varchar2
  ,p_full_name                     in     varchar2 default null
  ,p_reprocess_date                in     date
  ,p_new_retro_asg_id              out    nocopy number
  ) is

  --local variables.
  l_proc                varchar2(72) := g_package||'update_reprocess_date';

Line: 1003

  hr_utility.set_location('Calling pay_retro_status_internal.update_reprocess_date : '|| l_proc, 60);

Line: 1004

  pay_retro_status_internal.update_reprocess_date(
                            p_assignment_id   => l_assignment_id
                            ,p_reprocess_date => p_reprocess_date
			    ,p_retro_asg_id => p_new_retro_asg_id);

Line: 1011

end update_reprocess_date;