APPS.BEN_ELP_CACHE dependencies on BEN_CMBN_AGE_LOS_FCTR

Line 1581: l_tabdet_set(1).tab_name := 'ben_cmbn_age_los_fctr';

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: --
1584: end if;
1585: --

Line 3863: ben_cmbn_age_los_fctr cla

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
3867: between ecp.effective_start_date

Line 3885: ben_cmbn_age_los_fctr cla

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
3889: between ecp.effective_start_date