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 3124: from ben_elig_ee_stat_prte_f ees

3120: where p_effective_date
3121: between elp.effective_start_date
3122: and elp.effective_end_date
3123: and exists(select null
3124: from ben_elig_ee_stat_prte_f ees
3125: where p_effective_date
3126: between ees.effective_start_date
3127: and ees.effective_end_date
3128: and ees.eligy_prfl_id = elp.eligy_prfl_id)

Line 3139: from ben_elig_ee_stat_prte_f ees

3135: ees.assignment_status_type_id,
3136: ees.excld_flag,
3137: ees.criteria_score,
3138: ees.criteria_weight
3139: from ben_elig_ee_stat_prte_f ees
3140: where p_effective_date
3141: between ees.effective_start_date
3142: and ees.effective_end_date
3143: order by ees.eligy_prfl_id,