APPS.BEN_CEL_CACHE SQL Statements

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

Line: 45

    select pln.pl_id,
           pln.business_group_id
    from   ben_pl_f pln
    where  p_effective_date
           between pln.effective_start_date
           and     pln.effective_end_date
    and    exists(select null
                  from   ben_prtn_elig_f epa,
                         ben_prtn_elig_prfl_f cep,
                         ben_eligy_prfl_f elp
                  where  elp.eligy_prfl_id = cep.eligy_prfl_id
                  and    elp.business_group_id = cep.business_group_id
                  and    cep.prtn_elig_id = epa.prtn_elig_id
                  and    cep.business_group_id = epa.business_group_id
                  and    p_effective_date
                         between elp.effective_start_date
                         and     elp.effective_end_date
                  and    p_effective_date
                         between epa.effective_start_date
                         and     epa.effective_end_date
                  and    p_effective_date
                         between cep.effective_start_date
                         and     cep.effective_end_date
                  and epa.pl_id = pln.pl_id)
    order  by pln.pl_id;

Line: 72

    select epa.pl_id,
           epa.prtn_elig_id,
           cep.mndtry_flag,
           elp.eligy_prfl_id
    from   ben_prtn_elig_f epa,
           ben_prtn_elig_prfl_f cep,
           ben_eligy_prfl_f elp
    where  elp.eligy_prfl_id = cep.eligy_prfl_id
    and    elp.business_group_id = cep.business_group_id
    and    cep.prtn_elig_id = epa.prtn_elig_id
    and    cep.business_group_id = epa.business_group_id
    and    epa.pl_id is not null
    and    p_effective_date
           between elp.effective_start_date
           and     elp.effective_end_date
    and    p_effective_date
           between epa.effective_start_date
           and     epa.effective_end_date
    and    p_effective_date
           between cep.effective_start_date
           and     cep.effective_end_date
    order  by epa.pl_id, decode(cep.mndtry_flag,'y',1,2);

Line: 228

    g_cache_plnelp_lookup.delete;

Line: 229

    g_cache_plnelp_inst.delete;

Line: 317

    select pgm.pgm_id, pgm.business_group_id
    from   ben_pgm_f pgm
    where  p_effective_date
           between pgm.effective_start_date
           and     pgm.effective_end_date
    and    exists(select null
                  from   ben_prtn_elig_f epa,
                         ben_prtn_elig_prfl_f cep,
                         ben_eligy_prfl_f elp
                  where  elp.eligy_prfl_id = cep.eligy_prfl_id
                  and    elp.business_group_id = cep.business_group_id
                  and    cep.prtn_elig_id = epa.prtn_elig_id
                  and    cep.business_group_id = epa.business_group_id
                  and    p_effective_date
                         between elp.effective_start_date
                         and     elp.effective_end_date
                  and    p_effective_date
                         between epa.effective_start_date
                         and     epa.effective_end_date
                  and    p_effective_date
                         between cep.effective_start_date
                         and     cep.effective_end_date
                  and    epa.pgm_id = pgm.pgm_id)
    order  by pgm.pgm_id;

Line: 343

    select epa.pgm_id,
           epa.prtn_elig_id,
           cep.mndtry_flag,
           elp.eligy_prfl_id
    from   ben_prtn_elig_f epa,
           ben_prtn_elig_prfl_f cep,
           ben_eligy_prfl_f elp
    where  elp.eligy_prfl_id = cep.eligy_prfl_id
    and    elp.business_group_id = cep.business_group_id
    and    cep.prtn_elig_id = epa.prtn_elig_id
    and    cep.business_group_id = epa.business_group_id
    and    epa.pgm_id is not null
    and    p_effective_date
           between elp.effective_start_date
           and     elp.effective_end_date
    and    p_effective_date
           between epa.effective_start_date
           and     epa.effective_end_date
    and    p_effective_date
           between cep.effective_start_date
           and     cep.effective_end_date
    order  by epa.pgm_id, decode(cep.mndtry_flag,'Y',1,2);

Line: 500

    g_cache_pgmelp_lookup.delete;

Line: 501

    g_cache_pgmelp_inst.delete;

Line: 589

    select cop.oipl_id,
           cop.business_group_id
    from   ben_oipl_f cop
    where  p_effective_date
           between cop.effective_start_date
           and     cop.effective_end_date
    and exists(select null
               from   ben_prtn_elig_f epa,
                      ben_prtn_elig_prfl_f cep,
                      ben_eligy_prfl_f elp
               where  elp.eligy_prfl_id = cep.eligy_prfl_id
               and    elp.business_group_id = cep.business_group_id
               and    cep.prtn_elig_id = epa.prtn_elig_id
               and    cep.business_group_id = epa.business_group_id
               and    p_effective_date
                      between elp.effective_start_date
                      and     elp.effective_end_date
               and    p_effective_date
                      between epa.effective_start_date
                      and     epa.effective_end_date
               and    p_effective_date
                      between cep.effective_start_date
                      and     cep.effective_end_date
               and    epa.oipl_id = cop.oipl_id)
    order by cop.oipl_id;

Line: 616

    select epa.oipl_id,
           epa.prtn_elig_id,
           cep.mndtry_flag,
           elp.eligy_prfl_id
    from   ben_prtn_elig_f epa,
           ben_prtn_elig_prfl_f cep,
           ben_eligy_prfl_f elp
    where  elp.eligy_prfl_id = cep.eligy_prfl_id
    and    elp.business_group_id = cep.business_group_id
    and    cep.prtn_elig_id = epa.prtn_elig_id
    and    cep.business_group_id = epa.business_group_id
    and    epa.oipl_id is not null
    and    p_effective_date
           between elp.effective_start_date
           and     elp.effective_end_date
    and    p_effective_date
           between epa.effective_start_date
           and     epa.effective_end_date
    and    p_effective_date
           between cep.effective_start_date
           and     cep.effective_end_date
    order  by epa.oipl_id, decode(cep.mndtry_flag,'Y',1,2);

Line: 772

    g_cache_copelp_lookup.delete;

Line: 773

    g_cache_copelp_inst.delete;

Line: 861

    select cpp.plip_id,
           cpp.business_group_id
    from   ben_plip_f cpp
    where  p_effective_date
           between cpp.effective_start_date
           and     cpp.effective_end_date
    and exists(select null
               from   ben_prtn_elig_f epa,
                      ben_prtn_elig_prfl_f cep,
                      ben_eligy_prfl_f elp
               where  elp.eligy_prfl_id = cep.eligy_prfl_id
               and    elp.business_group_id = cep.business_group_id
               and    cep.prtn_elig_id = epa.prtn_elig_id
               and    cep.business_group_id = epa.business_group_id
               and    p_effective_date
                      between elp.effective_start_date
                      and     elp.effective_end_date
               and    p_effective_date
                      between epa.effective_start_date
                      and     epa.effective_end_date
               and    p_effective_date
                      between cep.effective_start_date
                      and     cep.effective_end_date
               and    epa.plip_id = cpp.plip_id)
    order by cpp.plip_id;

Line: 888

    select epa.plip_id,
           epa.prtn_elig_id,
           cep.mndtry_flag,
           elp.eligy_prfl_id
    from   ben_prtn_elig_f epa,
           ben_prtn_elig_prfl_f cep,
           ben_eligy_prfl_f elp
    where  elp.eligy_prfl_id = cep.eligy_prfl_id
    and    elp.business_group_id = cep.business_group_id
    and    cep.prtn_elig_id = epa.prtn_elig_id
    and    cep.business_group_id = epa.business_group_id
    and    epa.plip_id is not null
    and    p_effective_date
           between elp.effective_start_date
           and     elp.effective_end_date
    and    p_effective_date
           between epa.effective_start_date
           and     epa.effective_end_date
    and    p_effective_date
           between cep.effective_start_date
           and     cep.effective_end_date
    order  by epa.plip_id, decode(cep.mndtry_flag,'Y',1,2);

Line: 1044

    g_cache_cppelp_lookup.delete;

Line: 1045

    g_cache_cppelp_inst.delete;

Line: 1133

    select ctp.ptip_id,
           ctp.business_group_id
    from   ben_ptip_f ctp
    where  p_effective_date
           between ctp.effective_start_date
           and     ctp.effective_end_date
    and exists(select null
               from   ben_prtn_elig_f epa,
                      ben_prtn_elig_prfl_f cep,
                      ben_eligy_prfl_f elp
               where  elp.eligy_prfl_id = cep.eligy_prfl_id
               and    elp.business_group_id = cep.business_group_id
               and    cep.prtn_elig_id = epa.prtn_elig_id
               and    cep.business_group_id = epa.business_group_id
               and    p_effective_date
                      between elp.effective_start_date
                      and     elp.effective_end_date
               and    p_effective_date
                      between epa.effective_start_date
                      and     epa.effective_end_date
               and    p_effective_date
                      between cep.effective_start_date
                      and     cep.effective_end_date
               and    epa.ptip_id = ctp.ptip_id)
    order by ctp.ptip_id;

Line: 1160

    select epa.ptip_id,
           epa.prtn_elig_id,
           cep.mndtry_flag,
           elp.eligy_prfl_id
    from   ben_prtn_elig_f epa,
           ben_prtn_elig_prfl_f cep,
           ben_eligy_prfl_f elp
    where  elp.eligy_prfl_id = cep.eligy_prfl_id
    and    elp.business_group_id = cep.business_group_id
    and    cep.prtn_elig_id = epa.prtn_elig_id
    and    cep.business_group_id = epa.business_group_id
    and    epa.ptip_id is not null
    and    p_effective_date
           between elp.effective_start_date
           and     elp.effective_end_date
    and    p_effective_date
           between epa.effective_start_date
           and     epa.effective_end_date
    and    p_effective_date
           between cep.effective_start_date
           and     cep.effective_end_date
    order  by epa.ptip_id, decode(cep.mndtry_flag,'Y',1,2);

Line: 1316

    g_cache_ctpelp_lookup.delete;

Line: 1317

    g_cache_ctpelp_inst.delete;

Line: 1495

  g_cache_plnelp_lookup.delete;

Line: 1496

  g_cache_plnelp_inst.delete;

Line: 1497

  g_cache_pgmelp_lookup.delete;

Line: 1498

  g_cache_pgmelp_inst.delete;

Line: 1499

  g_cache_copelp_lookup.delete;

Line: 1500

  g_cache_copelp_inst.delete;

Line: 1501

  g_cache_cppelp_lookup.delete;

Line: 1502

  g_cache_cppelp_lookup.delete;

Line: 1503

  g_cache_ctpelp_inst.delete;

Line: 1504

  g_cache_ctpelp_inst.delete;