APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_CMBN_AGE_LOS_PRTE_F

Line 1579: l_tabdet_set(0).tab_name := 'ben_elig_cmbn_age_los_prte_f';

1575: l_mastertab_name := 'ben_eligy_prfl_f';
1576: l_masterpkcol_name := 'eligy_prfl_id';
1577: l_lkup_name := 'ben_elp_cache.g_elpecp_lookup';
1578: l_inst_name := 'ben_elp_cache.g_elpecp_inst';
1579: l_tabdet_set(0).tab_name := 'ben_elig_cmbn_age_los_prte_f';
1580: l_tabdet_set(0).tab_jncolnm := 'cmbn_age_los_fctr_id';
1581: l_tabdet_set(1).tab_name := 'ben_cmbn_age_los_fctr';
1582: l_tabdet_set(1).tab_datetype := 'nondt';
1583: --

Line 3862: from ben_elig_cmbn_age_los_prte_f ecp,

3858: where p_effective_date
3859: between elp.effective_start_date
3860: and elp.effective_end_date
3861: and exists(select null
3862: from ben_elig_cmbn_age_los_prte_f ecp,
3863: ben_cmbn_age_los_fctr cla
3864: where ecp.cmbn_age_los_fctr_id = cla.cmbn_age_los_fctr_id
3865: and ecp.business_group_id = cla.business_group_id
3866: and p_effective_date

Line 3884: from ben_elig_cmbn_age_los_prte_f ecp,

3880: cla.cmbnd_min_val,
3881: cla.cmbnd_max_val,
3882: cla.los_fctr_id,
3883: cla.age_fctr_id
3884: from ben_elig_cmbn_age_los_prte_f ecp,
3885: ben_cmbn_age_los_fctr cla
3886: where ecp.cmbn_age_los_fctr_id = cla.cmbn_age_los_fctr_id
3887: and ecp.business_group_id = cla.business_group_id
3888: and p_effective_date