APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_EE_STAT_PRTE_F

Line 1540: l_tabdet_set(0).tab_name := 'ben_elig_ee_stat_prte_f';

1536: l_mastertab_name := 'ben_eligy_prfl_f';
1537: l_masterpkcol_name := 'eligy_prfl_id';
1538: l_lkup_name := 'ben_elp_cache.g_elpees_lookup';
1539: l_inst_name := 'ben_elp_cache.g_elpees_inst';
1540: l_tabdet_set(0).tab_name := 'ben_elig_ee_stat_prte_f';
1541: --
1542: elsif p_cache_code = 'ELPESA' then
1543: --
1544: l_mastertab_name := 'ben_eligy_prfl_f';

Line 3090: from ben_elig_ee_stat_prte_f ees

3086: where p_effective_date
3087: between elp.effective_start_date
3088: and elp.effective_end_date
3089: and exists(select null
3090: from ben_elig_ee_stat_prte_f ees
3091: where p_effective_date
3092: between ees.effective_start_date
3093: and ees.effective_end_date
3094: and ees.eligy_prfl_id = elp.eligy_prfl_id)

Line 3105: from ben_elig_ee_stat_prte_f ees

3101: ees.assignment_status_type_id,
3102: ees.excld_flag,
3103: ees.criteria_score,
3104: ees.criteria_weight
3105: from ben_elig_ee_stat_prte_f ees
3106: where p_effective_date
3107: between ees.effective_start_date
3108: and ees.effective_end_date
3109: order by ees.eligy_prfl_id,