APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_SVC_AREA_PRTE_F

Line 1548: l_tabdet_set(0).tab_name := 'ben_elig_svc_area_prte_f';

1544: l_mastertab_name := 'ben_eligy_prfl_f';
1545: l_masterpkcol_name := 'eligy_prfl_id';
1546: l_lkup_name := 'ben_elp_cache.g_elpesa_lookup';
1547: l_inst_name := 'ben_elp_cache.g_elpesa_inst';
1548: l_tabdet_set(0).tab_name := 'ben_elig_svc_area_prte_f';
1549: l_tabdet_set(0).tab_jncolnm := 'svc_area_id';
1550: l_tabdet_set(1).tab_name := 'ben_svc_area_pstl_zip_rng_f';
1551: l_tabdet_set(1).tab_jncolnm := 'pstl_zip_rng_id';
1552: l_tabdet_set(2).tab_name := 'ben_pstl_zip_rng_f';

Line 3334: from ben_elig_svc_area_prte_f esa,

3330: where p_effective_date
3331: between elp.effective_start_date
3332: and elp.effective_end_date
3333: and exists (select null
3334: from ben_elig_svc_area_prte_f esa,
3335: ben_svc_area_pstl_zip_rng_f saz,
3336: ben_pstl_zip_rng_f rzr
3337: where p_effective_date
3338: between esa.effective_start_date

Line 3359: from ben_elig_svc_area_prte_f esa,

3355: esa.criteria_score,
3356: esa.criteria_weight,
3357: rzr.from_value,
3358: rzr.to_value
3359: from ben_elig_svc_area_prte_f esa,
3360: ben_svc_area_pstl_zip_rng_f saz,
3361: ben_pstl_zip_rng_f rzr
3362: where p_effective_date
3363: between esa.effective_start_date