APPS.BEN_CAGRELP_CACHE SQL Statements

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

Line: 34

    select tab.eligy_prfl_id,
           tab.elig_gndr_prte_id pk_id,
           'EGN' short_code,
           tab.sex,
           tab.excld_flag,
           tab.criteria_score,
           tab.criteria_weight
    from   ben_elig_gndr_prte_f tab
    where tab.eligy_prfl_id = c_eligy_prfl_id
      and c_effective_date
        between tab.effective_start_date and tab.effective_end_date
    order by tab.eligy_prfl_id,
             decode(tab.excld_flag,'Y',1,2);

Line: 99

    select tab.eligy_prfl_id,
           tab.elig_mrtl_sts_prte_id pk_id,
           'EMS' short_code,
           tab.marital_status,
           tab.excld_flag,
           tab.criteria_score,
           tab.criteria_weight
    from   ben_elig_mrtl_sts_prte_f tab
    where tab.eligy_prfl_id = c_eligy_prfl_id
      and c_effective_date
        between tab.effective_start_date and tab.effective_end_date
    order by tab.eligy_prfl_id,
             decode(tab.excld_flag,'Y',1,2);

Line: 164

    select tab.eligy_prfl_id,
           tab.elig_dsblty_ctg_prte_id pk_id,
           'ECT' short_code,
           tab.category,
           tab.excld_flag,
           tab.criteria_score,
           tab.criteria_weight
    from   ben_elig_dsblty_ctg_prte_f tab
    where tab.eligy_prfl_id = c_eligy_prfl_id
      and c_effective_date
        between tab.effective_start_date and tab.effective_end_date
    order by tab.eligy_prfl_id,
             decode(tab.excld_flag,'Y',1,2);

Line: 229

    select tab.eligy_prfl_id,
           tab.elig_dsblty_rsn_prte_id pk_id,
           'EDR' short_code,
           tab.reason,
           tab.excld_flag,
           tab.criteria_score,
           tab.criteria_weight
    from   ben_elig_dsblty_rsn_prte_f tab
    where tab.eligy_prfl_id = c_eligy_prfl_id
      and c_effective_date
        between tab.effective_start_date and tab.effective_end_date
    order by tab.eligy_prfl_id,
             decode(tab.excld_flag,'Y',1,2);

Line: 294

    select tab.eligy_prfl_id,
           tab.elig_dsblty_dgr_prte_id pk_id,
           'EDD' short_code,
           tab.degree,
           tab.excld_flag,
           tab.criteria_score,
           tab.criteria_weight
    from   ben_elig_dsblty_dgr_prte_f tab
    where tab.eligy_prfl_id = c_eligy_prfl_id
      and c_effective_date
        between tab.effective_start_date and tab.effective_end_date
    order by tab.eligy_prfl_id,
             decode(tab.excld_flag,'Y',1,2);

Line: 359

    select tab.eligy_prfl_id,
           tab.elig_suppl_role_prte_id pk_id,
           'EST' short_code,
           tab.job_id,
           tab.job_group_id,
           tab.excld_flag,
           tab.criteria_score,
           tab.criteria_weight
    from   ben_elig_suppl_role_prte_f tab
    where tab.eligy_prfl_id = c_eligy_prfl_id
      and c_effective_date
        between tab.effective_start_date and tab.effective_end_date
    order by tab.eligy_prfl_id,
             decode(tab.excld_flag,'Y',1,2);

Line: 426

    select tab.eligy_prfl_id,
           tab.elig_qual_titl_prte_id pk_id,
           'EQT' short_code,
           tab.title,
           tab.QUALIFICATION_TYPE_ID,
           tab.excld_flag,
           tab.criteria_score,
           tab.criteria_weight
    from   ben_elig_qual_titl_prte_f tab
    where tab.eligy_prfl_id = c_eligy_prfl_id
      and c_effective_date
        between tab.effective_start_date and tab.effective_end_date
    order by tab.eligy_prfl_id,
             decode(tab.excld_flag,'Y',1,2);

Line: 493

    select tab.eligy_prfl_id,
           tab.elig_pstn_prte_id pk_id,
           'EPT' short_code,
           tab.position_id,
           tab.excld_flag,
           tab.criteria_score,
           tab.criteria_weight
    from   ben_elig_pstn_prte_f tab
    where tab.eligy_prfl_id = c_eligy_prfl_id
      and c_effective_date
        between tab.effective_start_date and tab.effective_end_date
    order by tab.eligy_prfl_id,
             decode(tab.excld_flag,'Y',1,2);

Line: 558

    select tab.eligy_prfl_id,
           tab.elig_prbtn_perd_prte_id pk_id,
           'EPP' short_code,
           tab.PROBATION_PERIOD,
           tab.PROBATION_UNIT,
           tab.excld_flag,
           tab.criteria_score,
           tab.criteria_weight
    from   ben_elig_prbtn_perd_prte_f tab
    where tab.eligy_prfl_id = c_eligy_prfl_id
      and c_effective_date
        between tab.effective_start_date and tab.effective_end_date
    order by tab.eligy_prfl_id,
             decode(tab.excld_flag,'Y',1,2);

Line: 625

    select tab.eligy_prfl_id,
           tab.elig_sp_clng_prg_prte_id pk_id,
           'ESP' short_code,
           tab.special_ceiling_step_id,
           tab.excld_flag,
           tab.criteria_score,
           tab.criteria_weight
    from   ben_elig_sp_clng_prg_prte_f tab
    where tab.eligy_prfl_id = c_eligy_prfl_id
      and c_effective_date
        between tab.effective_start_date and tab.effective_end_date
    order by tab.eligy_prfl_id,
             decode(tab.excld_flag,'Y',1,2);