APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_PER_TYP_PRTE_F

Line 1532: l_tabdet_set(0).tab_name := 'ben_elig_per_typ_prte_f';

1528: l_mastertab_name := 'ben_eligy_prfl_f';
1529: l_masterpkcol_name := 'eligy_prfl_id';
1530: l_lkup_name := 'ben_elp_cache.g_elpept_lookup';
1531: l_inst_name := 'ben_elp_cache.g_elpept_inst';
1532: l_tabdet_set(0).tab_name := 'ben_elig_per_typ_prte_f';
1533: --
1534: elsif p_cache_code = 'ELPEES' then
1535: --
1536: l_mastertab_name := 'ben_eligy_prfl_f';

Line 2349: from ben_elig_per_typ_prte_f ept

2345: where p_effective_date
2346: between elp.effective_start_date
2347: and elp.effective_end_date
2348: and exists(select null
2349: from ben_elig_per_typ_prte_f ept
2350: where p_effective_date
2351: between ept.effective_start_date
2352: and ept.effective_end_date
2353: and ept.eligy_prfl_id = elp.eligy_prfl_id)

Line 2367: from ben_elig_per_typ_prte_f ept

2363: ept.person_type_id,
2364: ept.excld_flag,
2365: ept.criteria_score,
2366: ept.criteria_weight
2367: from ben_elig_per_typ_prte_f ept
2368: where p_effective_date
2369: between ept.effective_start_date
2370: and ept.effective_end_date
2371: order by ept.eligy_prfl_id,