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 3923: from ben_elig_cmbn_age_los_prte_f ecp,

3919: where p_effective_date
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

Line 3945: from ben_elig_cmbn_age_los_prte_f ecp,

3941: cla.cmbnd_min_val,
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