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 3924: ben_cmbn_age_los_fctr cla

3920: between elp.effective_start_date
3921: and elp.effective_end_date
3922: and exists(select null
3923: from ben_elig_cmbn_age_los_prte_f ecp,
3924: ben_cmbn_age_los_fctr cla
3925: where ecp.cmbn_age_los_fctr_id = cla.cmbn_age_los_fctr_id
3926: and ecp.business_group_id = cla.business_group_id
3927: and p_effective_date
3928: between ecp.effective_start_date

Line 3946: ben_cmbn_age_los_fctr cla

3942: cla.cmbnd_max_val,
3943: cla.los_fctr_id,
3944: cla.age_fctr_id
3945: from ben_elig_cmbn_age_los_prte_f ecp,
3946: ben_cmbn_age_los_fctr cla
3947: where ecp.cmbn_age_los_fctr_id = cla.cmbn_age_los_fctr_id
3948: and ecp.business_group_id = cla.business_group_id
3949: and p_effective_date
3950: between ecp.effective_start_date