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 2358: from ben_elig_per_typ_prte_f ept

2354: where p_effective_date
2355: between elp.effective_start_date
2356: and elp.effective_end_date
2357: and exists(select null
2358: from ben_elig_per_typ_prte_f ept
2359: where p_effective_date
2360: between ept.effective_start_date
2361: and ept.effective_end_date
2362: and ept.eligy_prfl_id = elp.eligy_prfl_id)

Line 2376: from ben_elig_per_typ_prte_f ept

2372: ept.person_type_id,
2373: ept.excld_flag,
2374: ept.criteria_score,
2375: ept.criteria_weight
2376: from ben_elig_per_typ_prte_f ept
2377: where p_effective_date
2378: between ept.effective_start_date
2379: and ept.effective_end_date
2380: order by ept.eligy_prfl_id,