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 3379: ben_pstl_zip_rng_f rzr

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
3383: and esa.svc_area_id = saz.svc_area_id

Line 3404: ben_pstl_zip_rng_f rzr

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
3408: and esa.svc_area_id = saz.svc_area_id

Line 8591: ben_pstl_zip_rng_f rzr

8587: between elp.effective_start_date
8588: and elp.effective_end_date
8589: and exists(select null
8590: from ben_elig_pstl_cd_r_rng_prte_f epz,
8591: ben_pstl_zip_rng_f rzr
8592: where epz.pstl_zip_rng_id = rzr.pstl_zip_rng_id
8593: and epz.business_group_id = rzr.business_group_id
8594: and p_effective_date
8595: between rzr.effective_start_date

Line 8613: ben_pstl_zip_rng_f rzr

8609: epz.criteria_weight,
8610: rzr.from_value,
8611: rzr.to_value
8612: from ben_elig_pstl_cd_r_rng_prte_f epz,
8613: ben_pstl_zip_rng_f rzr
8614: where epz.pstl_zip_rng_id = rzr.pstl_zip_rng_id
8615: and epz.business_group_id = rzr.business_group_id
8616: and p_effective_date
8617: between rzr.effective_start_date