APPS.BEN_CWB_REFRESH_PKG SQL Statements

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

Line: 35

   select
     dsgn.pl_id
    ,dsgn.oipl_id
    ,ws_abr_id
    ,rates.group_per_in_ler_id
    ,enrt.rt_strt_dt_rl
    ,enrt.rt_strt_dt_cd
    ,rates.person_id
    ,enrt.business_group_id
    ,rates.object_version_number
   from
     ben_cwb_pl_dsgn dsgn
    ,ben_cwb_person_rates rates
    ,ben_popl_enrt_typ_cycl_f popl
    ,ben_cwb_person_info info
    ,ben_enrt_perd enrt
   where dsgn.group_pl_id = p_group_pl_id
     and dsgn.lf_evt_ocrd_dt = p_lf_evt_ocrd_dt
     and info.group_per_in_ler_id = rates.group_per_in_ler_id
     and nvl(info.post_process_stat_cd,'N') <> 'PR'
     and dsgn.ws_abr_id is not null
     and rates.group_pl_id = dsgn.group_pl_id
     and rates.group_oipl_id = dsgn.group_oipl_id
     and rates.pl_id = dsgn.pl_id
     and rates.oipl_id = dsgn.oipl_id
     and rates.lf_evt_ocrd_dt = dsgn.lf_evt_ocrd_dt
     and popl.pl_id = dsgn.pl_id
     and enrt.asnd_lf_evt_dt = dsgn.lf_evt_ocrd_dt
     and popl.popl_enrt_typ_cycl_id = enrt.popl_enrt_typ_cycl_id;

Line: 68

    select assignment_extra_info_id
          ,object_version_number
      from per_assignment_extra_info xtra_info
      where xtra_info.information_type = 'CWBRANK'
      and xtra_info.aei_information3 IS NULL;

Line: 76

   select distinct(person_id) person_id
   from  ben_cwb_summary
   where status = 'P'
   and group_pl_id = p_group_pl_id
   and lf_evt_ocrd_dt = p_lf_evt_ocrd_dt;

Line: 125

     hr_assignment_extra_info_api.delete_assignment_extra_info
     (p_validate                 => false
     ,p_assignment_extra_info_id => l_ranking_info.assignment_extra_info_id
     ,p_object_version_number    => l_ranking_info.object_version_number);

Line: 162

     ben_cwb_xchg_pkg.insert_into_ben_cwb_xchg(p_group_pl_id
                                            ,l_lf_evt_ocrd_dt
                                            ,l_effective_date
                                            ,'Y'
                                            );

Line: 228

				UPDATE  ben_cwb_person_info
				SET     email_status = 'N'
				WHERE   lf_evt_ocrd_dt = trunc(to_date(p_lf_evt_ocrd_dt,'yyyy/mm/dd hh24:mi:ss'))
				AND     p_group_pl_id = group_pl_id;

Line: 307

  BEN_CWB_PERSON_RATES_API.update_person_rate(
    p_group_per_in_ler_id => rec.group_per_in_ler_id
   ,p_pl_id               => rec.pl_id
   ,p_oipl_id             => rec.oipl_id
   ,p_ws_rt_start_date    => l_returned_date
   ,p_object_version_number => l_object_version_number
   );

Line: 317

    BEN_CWB_PERSON_RATES_API.update_person_rate(
    p_group_per_in_ler_id => rec.group_per_in_ler_id
   ,p_pl_id               => rec.pl_id
   ,p_oipl_id             => rec.oipl_id
   ,p_ws_rt_start_date    => null
   ,p_object_version_number => l_object_version_number
   );