APPS.BEN_EFC_FUNCTIONS SQL Statements

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

Line: 69

    SELECT act.efc_action_id,
           act.business_group_id
    FROM hr_efc_actions act
    WHERE act.efc_action_status = 'P'
    AND   act.efc_action_type = 'C'
    and   act.business_group_id = c_bgp_id;

Line: 120

  hr_efc_info.insert_or_select_comp_row
    (p_action_id              => l_action_id
    ,p_process_component_name => p_component_name
    ,p_table_name             => p_table_name
    ,p_total_workers          => p_total_workers
    ,p_worker_id              => p_worker_id
    ,p_step                   => 'C_RECAL'
    ,p_sub_step               => p_sub_step
    ,p_process_component_id   => l_component_id
    );

Line: 134

  hr_efc_info.insert_or_select_worker_row
    (p_efc_worker_id          => p_efc_worker_id
    ,p_status                 => p_status
    ,p_process_component_id   => l_component_id
    ,p_process_component_name => p_component_name
    ,p_action_id              => l_action_id
    ,p_worker_number          => p_worker_id
    ,p_pk1                    => p_pk1
    ,p_pk2                    => l_pk2char
    ,p_pk3                    => l_pk3char
    ,p_pk4                    => l_pk4char
    ,p_pk5                    => l_pk5char
    );

Line: 175

     hr_efc_info.update_worker_row
       (p_efc_worker_id => p_efc_worker_id
       ,p_pk1           => p_pk1
       );

Line: 221

    select business_group_id
    into l_business_group_id
    from hr_efc_actions
    where efc_action_id = p_action_id;

Line: 241

    l_sql_str := 'select count(*) '
                 ||' from '||p_table_name
                 ||' where business_group_id is not null ';

Line: 275

    l_sql_str := 'select count(*) '
                 ||' from '||p_efctable_name
                 ||' where efc_action_id = '||p_action_id;

Line: 320

    select pil.lf_evt_ocrd_dt,
           pil.person_id,
           pil.per_in_ler_id,
           pil.business_group_id,
           pil.ler_id,
           pil.per_in_ler_stat_cd
    from BEN_ELIG_PER_ELCTBL_CHC epe,
         ben_per_in_ler pil,
         per_all_people_f per
    where pil.per_in_ler_id = epe.per_in_ler_id
    and   epe.ELIG_PER_ELCTBL_CHC_id = c_epe_id
    and   per.person_id = pil.person_id
    and   pil.lf_evt_ocrd_dt
      between per.effective_start_date and per.effective_end_date;

Line: 341

    select pil.lf_evt_ocrd_dt,
           pil.person_id,
           pil.per_in_ler_id,
           pil.business_group_id,
           pil.ler_id,
           pil.per_in_ler_stat_cd,
           enb.val
    from ben_enrt_bnft enb,
         BEN_ELIG_PER_ELCTBL_CHC epe,
         ben_per_in_ler pil,
         per_all_people_f per
    where enb.ELIG_PER_ELCTBL_CHC_id = epe.ELIG_PER_ELCTBL_CHC_id
    and   pil.per_in_ler_id = epe.per_in_ler_id
    and   enb.enrt_bnft_id = c_enb_id
    and   per.person_id = pil.person_id
    and   pil.lf_evt_ocrd_dt
      between per.effective_start_date and per.effective_end_date;

Line: 461

  l_sql_str := 'select count(*) '
               ||' from BEN_PRTN_ELIG_F tab '
               ||' where tab.'||l_cocol_name||' = :id ';

Line: 473

    l_sql_str := 'select count(*) '
                 ||' from ben_acty_base_rt_f tab '
                 ||' where tab.'||l_cocol_name||' = :id ';

Line: 489

        l_sql_str := 'select count(*) '
                     ||' from ben_actl_prem_f tab '
                     ||' where tab.'||l_cocol_name||' = :id ';

Line: 503

        l_sql_str := 'select count(*) '
                     ||' from ben_cvg_amt_calc_mthd_f tab '
                     ||' where tab.'||l_cocol_name||' = :id ';

Line: 540

   SELECT 'Y'
     FROM hr_efc_actions
    WHERE efc_action_status = 'P'
    and   business_group_id = c_bgp_id;

Line: 547

    SELECT hr_efc_actions_s.nextval
    FROM dual;

Line: 554

    SELECT max(action_sequence)
    FROM hr_efc_actions
    WHERE business_group_id = c_bg;

Line: 560

    SELECT to_number(substr(lok.lookup_code,2)) action_num
    FROM hr_lookups lok
    WHERE lok.lookup_type = 'EFC_PROGRESS_STATUS'
    AND substr(lok.lookup_code,1,1) = 'C'
    ORDER BY lok.lookup_code;

Line: 599

     INSERT INTO hr_efc_actions
                  (efc_action_id
                  ,efc_action_type
                  ,efc_action_status
                  ,efc_progress_status
                  ,business_group_id
                  ,action_sequence
                  ,start_date
                  ,finish_date
                  ,matching_efc_action_id
                  ,last_update_date
                  ,last_updated_by
                  ,last_update_login
                  ,created_by
                  ,creation_date
                  )
     VALUES
       (l_id
       ,'C'
       ,'P'
       ,'C' || to_char(l_low)
       ,p_bgp_id
       ,l_max
       ,sysdate
       ,null
       ,null
       ,sysdate
       ,-1
       ,-1
       ,-1
       ,sysdate
       );

Line: 656

    select efc.efc_action_id
    from hr_efc_actions efc
    where efc.business_group_id = c_bgp_id;

Line: 672

    delete from BEN_ENRT_RT_EFC
    where EFC_ACTION_ID = l_efc_action_id;

Line: 675

    delete from ben_prtt_rt_val_efc
    where EFC_ACTION_ID = l_efc_action_id;

Line: 678

    delete from PAY_ELEMENT_ENTRY_VALUES_F_efc
    where EFC_ACTION_ID = l_efc_action_id;

Line: 681

    delete from HR_EFC_WORKER_AUDITS
    where exists (select efc_worker_id
       from HR_EFC_WORKERS
       where efc_action_id = l_efc_action_id);

Line: 686

    delete from HR_EFC_WORKERS
    where efc_action_id = l_efc_action_id;

Line: 689

    delete from HR_EFC_PROCESS_COMPONENTS
    where efc_action_id = l_efc_action_id;

Line: 692

    delete from HR_EFC_ROUNDING_ERRORS
    where efc_action_id = l_efc_action_id;

Line: 695

    delete from hr_efc_actions
    where efc_action_id = l_efc_action_id;

Line: 750

    select 1
    from hr_ncu_currencies
    where currency_code = c_curr_code;

Line: 787

    select 1
    from fnd_currencies
    where currency_code = c_uom;

Line: 837

    select pgm.pgm_uom
    from ben_pgm_f pgm
    where pgm.pgm_id = c_pgm_id
    and   c_eff_date
      between pgm.effective_start_date and pgm.effective_end_date;

Line: 850

    select pln.nip_pl_uom
    from ben_pl_f pln
    where pln.pl_id = c_pln_id
    and   c_eff_date
      between pln.effective_start_date and pln.effective_end_date;