APPS.BEN_PER_ASG_ELIG SQL Statements

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

Line: 37

select null
  from ben_elig_obj_f
 where elig_obj_id = p_elig_obj_id
   and p_effective_date between effective_start_date
   and effective_end_date;

Line: 44

select person_id
  from per_all_assignments_f asg
 where assignment_id = c_assignment_id
   and p_effective_date between effective_start_date
   and effective_end_date;

Line: 51

select elig_prfl_id,
       nvl(mndtry_flag,'N'),
       'Y',
       'N'
  from ben_elig_obj_elig_profl_f
 where elig_obj_id = p_elig_obj_id
   and p_effective_date between effective_start_date
   and effective_end_date
order by decode(mndtry_flag,'Y',1,2);

Line: 62

select paf.assignment_id
  from per_all_assignments_f paf
 where paf.person_id = p_person_id
   and decode(substr(p_assignment_type,3,1),'P','Y',paf.primary_flag) = paf.primary_flag
   and decode(substr(p_assignment_type,1,1),'L',paf.assignment_type,substr(p_assignment_type,1,1)) = paf.assignment_type
   and paf.business_group_id  = p_business_group_id
   and p_effective_date between paf.effective_start_date
   and paf.effective_end_date
 order by paf.effective_start_date;

Line: 75

select elig_rslt_id,
       elig_flag,
       object_version_number,
       effective_start_date,
       effective_end_date
  from ben_elig_rslt_f
 where elig_obj_id = p_elig_obj_id
   and person_id = c_person_id
   and nvl(assignment_id,-1) = nvl(c_assignment_id,-1)
   and c_effective_date between effective_start_date
   and effective_end_date;

Line: 91

select min(effective_start_date)
  from ben_elig_rslt_f
 where elig_obj_id = p_elig_obj_id
   and person_id = c_person_id
   and nvl(assignment_id,-1) = nvl(c_assignment_id,-1)
   and effective_start_date > c_effective_date;

Line: 103

l_update                boolean;

Line: 104

l_update_override       boolean;

Line: 105

l_update_change_insert  boolean;

Line: 294

               ben_elig_rslt_api.delete_elig_rslt
              (p_effective_date          =>  l_min_strt_dt-1,
               p_elig_rslt_id            =>  l_elig_rslt_id,
               p_datetrack_mode          =>  hr_api.g_delete,
               p_effective_start_date    =>  l_effective_start_date,
               p_effective_end_date      =>  l_effective_end_date,
               p_object_version_number   =>  l_object_version_number);

Line: 312

            p_update               => l_update,
            p_update_override      => l_update_override,
            p_update_change_insert => l_update_change_insert);

Line: 316

            if l_update then
               l_upd_mode := hr_api.g_update;

Line: 318

            elsif l_update_change_insert then
               l_upd_mode := hr_api.g_update_change_insert;

Line: 324

           ben_elig_rslt_api.update_elig_rslt
           (p_datetrack_mode          =>  l_upd_mode,
            p_elig_obj_id             =>  p_elig_obj_id,
            p_effective_date          =>  p_effective_date,
            p_business_group_id       =>  p_business_group_id,
            p_person_id               =>  l_person_id,
            p_assignment_id           =>  l_asg_tab(i),
            p_elig_flag               =>  l_elig_flag,
            p_elig_rslt_id            =>  l_elig_rslt_rec.elig_rslt_id,
            p_effective_start_date    =>  l_effective_start_date,
            p_effective_end_date      =>  l_effective_end_date,
            p_object_version_number   =>  l_elig_rslt_rec.object_version_number);

Line: 475

select person_id
  from per_all_assignments_f asg
 where assignment_id = c_assignment_id
   and p_effective_date between effective_start_date
   and effective_end_date;

Line: 483

select null
  from ben_eligy_prfl_f
 where eligy_prfl_id = p_eligy_prfl_id
   and business_group_id = p_business_group_id
   and stat_cd = 'A'
   and p_effective_date between effective_start_date
   and effective_end_date;