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 4610: from ben_elig_hrly_slrd_prte_f ehs

4606: where p_effective_date
4607: between elp.effective_start_date
4608: and elp.effective_end_date
4609: and exists(select null
4610: from ben_elig_hrly_slrd_prte_f ehs
4611: where p_effective_date
4612: between ehs.effective_start_date
4613: and ehs.effective_end_date
4614: and ehs.eligy_prfl_id = elp.eligy_prfl_id)

Line 4625: from ben_elig_hrly_slrd_prte_f ehs

4621: ehs.hrly_slrd_cd,
4622: ehs.excld_flag,
4623: ehs.criteria_score,
4624: ehs.criteria_weight
4625: from ben_elig_hrly_slrd_prte_f ehs
4626: where p_effective_date
4627: between ehs.effective_start_date
4628: and ehs.effective_end_date
4629: order by ehs.eligy_prfl_id,