APPS.BEN_ELIG_RL_CACHE SQL Statements

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

Line: 60

    select  tab1.prtn_elig_id,
            tab1.pgm_id,
            tab1.pl_id,
            tab1.oipl_id,
            tab1.plip_id,
            tab1.ptip_id,
            tab2.formula_id,
            tab2.mndtry_flag,
            tab2.ordr_to_aply_num
    from  ben_prtn_elig_f tab1,
          ben_prtn_eligy_rl_f tab2
    where tab1.pgm_id = c_pgm_id
    and tab1.prtn_elig_id = tab2.prtn_elig_id
    and c_effective_date
      between tab1.effective_start_date and tab1.effective_end_date
    and c_effective_date
      between tab2.effective_start_date and tab2.effective_end_date
    order by decode(tab2.mndtry_flag, 'Y', 2, 3),
             tab2.ordr_to_aply_num;

Line: 87

    select  tab1.prtn_elig_id,
            tab1.pgm_id,
            tab1.pl_id,
            tab1.oipl_id,
            tab1.plip_id,
            tab1.ptip_id,
            tab2.formula_id,
            tab2.mndtry_flag,
            tab2.ordr_to_aply_num
    from  ben_prtn_elig_f tab1,
          ben_prtn_eligy_rl_f tab2
    where tab1.ptip_id = c_ptip_id
    and tab1.prtn_elig_id = tab2.prtn_elig_id
    and c_effective_date
      between tab1.effective_start_date and tab1.effective_end_date
    and c_effective_date
      between tab2.effective_start_date and tab2.effective_end_date
    order by decode(tab2.mndtry_flag, 'Y', 2, 3),
             tab2.ordr_to_aply_num;

Line: 112

    select  tab1.prtn_elig_id,
            tab1.pgm_id,
            tab1.pl_id,
            tab1.oipl_id,
            tab1.plip_id,
            tab1.ptip_id,
            tab2.formula_id,
            tab2.mndtry_flag,
            tab2.ordr_to_aply_num
    from  ben_prtn_elig_f tab1,
          ben_prtn_eligy_rl_f tab2
    where tab1.plip_id = c_plip_id
    and tab1.prtn_elig_id = tab2.prtn_elig_id
    and c_effective_date
      between tab1.effective_start_date and tab1.effective_end_date
    and c_effective_date
      between tab2.effective_start_date and tab2.effective_end_date
    order by decode(tab2.mndtry_flag, 'Y', 2, 3),
             tab2.ordr_to_aply_num;

Line: 137

    select  tab1.prtn_elig_id,
            tab1.pgm_id,
            tab1.pl_id,
            tab1.oipl_id,
            tab1.plip_id,
            tab1.ptip_id,
            tab2.formula_id,
            tab2.mndtry_flag,
            tab2.ordr_to_aply_num
    from  ben_prtn_elig_f tab1,
          ben_prtn_eligy_rl_f tab2
    where tab1.pl_id = c_pl_id
    and tab1.prtn_elig_id = tab2.prtn_elig_id
    and c_effective_date
      between tab1.effective_start_date and tab1.effective_end_date
    and c_effective_date
      between tab2.effective_start_date and tab2.effective_end_date
    order by decode(tab2.mndtry_flag, 'Y', 2, 3),
             tab2.ordr_to_aply_num;

Line: 162

    select  tab1.prtn_elig_id,
            tab1.pgm_id,
            tab1.pl_id,
            tab1.oipl_id,
            tab1.plip_id,
            tab1.ptip_id,
            tab2.formula_id,
            tab2.mndtry_flag,
            tab2.ordr_to_aply_num
    from  ben_prtn_elig_f tab1,
          ben_prtn_eligy_rl_f tab2
    where tab1.oipl_id = c_oipl_id
    and tab1.prtn_elig_id = tab2.prtn_elig_id
    and c_effective_date
      between tab1.effective_start_date and tab1.effective_end_date
    and c_effective_date
      between tab2.effective_start_date and tab2.effective_end_date
    order by decode(tab2.mndtry_flag, 'Y', 2, 3),
             tab2.ordr_to_aply_num;

Line: 378

    g_odlookup.delete(l_hv);