APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_HRLY_SLRD_PRTE_F

Line 1560: l_tabdet_set(0).tab_name := 'ben_elig_hrly_slrd_prte_f';

1556: l_mastertab_name := 'ben_eligy_prfl_f';
1557: l_masterpkcol_name := 'eligy_prfl_id';
1558: l_lkup_name := 'ben_elp_cache.g_elpehs_lookup';
1559: l_inst_name := 'ben_elp_cache.g_elpehs_inst';
1560: l_tabdet_set(0).tab_name := 'ben_elig_hrly_slrd_prte_f';
1561: --
1562: elsif p_cache_code = 'ELPELS' then
1563: --
1564: l_mastertab_name := 'ben_eligy_prfl_f';

Line 4698: from ben_elig_hrly_slrd_prte_f ehs

4694: where p_effective_date
4695: between elp.effective_start_date
4696: and elp.effective_end_date
4697: and exists(select null
4698: from ben_elig_hrly_slrd_prte_f ehs
4699: where p_effective_date
4700: between ehs.effective_start_date
4701: and ehs.effective_end_date
4702: and ehs.eligy_prfl_id = elp.eligy_prfl_id)

Line 4713: from ben_elig_hrly_slrd_prte_f ehs

4709: ehs.hrly_slrd_cd,
4710: ehs.excld_flag,
4711: ehs.criteria_score,
4712: ehs.criteria_weight
4713: from ben_elig_hrly_slrd_prte_f ehs
4714: where p_effective_date
4715: between ehs.effective_start_date
4716: and ehs.effective_end_date
4717: order by ehs.eligy_prfl_id,