APPS.BEN_ELP_CACHE dependencies on BEN_SVC_AREA_PSTL_ZIP_RNG_F

Line 1550: l_tabdet_set(1).tab_name := 'ben_svc_area_pstl_zip_rng_f';

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';
1553: --
1554: elsif p_cache_code = 'ELPEHS' then

Line 3378: ben_svc_area_pstl_zip_rng_f saz,

3374: between elp.effective_start_date
3375: and elp.effective_end_date
3376: and exists (select null
3377: from ben_elig_svc_area_prte_f esa,
3378: ben_svc_area_pstl_zip_rng_f saz,
3379: ben_pstl_zip_rng_f rzr
3380: where p_effective_date
3381: between esa.effective_start_date
3382: and esa.effective_end_date

Line 3403: ben_svc_area_pstl_zip_rng_f saz,

3399: esa.criteria_weight,
3400: rzr.from_value,
3401: rzr.to_value
3402: from ben_elig_svc_area_prte_f esa,
3403: ben_svc_area_pstl_zip_rng_f saz,
3404: ben_pstl_zip_rng_f rzr
3405: where p_effective_date
3406: between esa.effective_start_date
3407: and esa.effective_end_date