APPS.BEN_ELP_CACHE dependencies on BEN_PSTL_ZIP_RNG_F

Line 1552: l_tabdet_set(2).tab_name := 'ben_pstl_zip_rng_f';

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
1555: --
1556: l_mastertab_name := 'ben_eligy_prfl_f';

Line 3336: ben_pstl_zip_rng_f rzr

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
3339: and esa.effective_end_date
3340: and esa.svc_area_id = saz.svc_area_id

Line 3361: ben_pstl_zip_rng_f rzr

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
3364: and esa.effective_end_date
3365: and esa.svc_area_id = saz.svc_area_id

Line 8368: ben_pstl_zip_rng_f rzr

8364: between elp.effective_start_date
8365: and elp.effective_end_date
8366: and exists(select null
8367: from ben_elig_pstl_cd_r_rng_prte_f epz,
8368: ben_pstl_zip_rng_f rzr
8369: where epz.pstl_zip_rng_id = rzr.pstl_zip_rng_id
8370: and epz.business_group_id = rzr.business_group_id
8371: and p_effective_date
8372: between rzr.effective_start_date

Line 8390: ben_pstl_zip_rng_f rzr

8386: epz.criteria_weight,
8387: rzr.from_value,
8388: rzr.to_value
8389: from ben_elig_pstl_cd_r_rng_prte_f epz,
8390: ben_pstl_zip_rng_f rzr
8391: where epz.pstl_zip_rng_id = rzr.pstl_zip_rng_id
8392: and epz.business_group_id = rzr.business_group_id
8393: and p_effective_date
8394: between rzr.effective_start_date