APPS.BEN_ELP_CACHE dependencies on BEN_LOS_FCTR

Line 1570: l_tabdet_set(1).tab_name := 'ben_los_fctr';

1566: l_lkup_name := 'ben_elp_cache.g_elpels_lookup';
1567: l_inst_name := 'ben_elp_cache.g_elpels_inst';
1568: l_tabdet_set(0).tab_name := 'ben_elig_los_prte_f';
1569: l_tabdet_set(0).tab_jncolnm := 'los_fctr_id';
1570: l_tabdet_set(1).tab_name := 'ben_los_fctr';
1571: l_tabdet_set(1).tab_datetype := 'nondt';
1572: --
1573: elsif p_cache_code = 'ELPECP' then
1574: --

Line 3652: ben_los_fctr lsf

3648: between elp.effective_start_date
3649: and elp.effective_end_date
3650: and exists(select null
3651: from ben_elig_los_prte_f els,
3652: ben_los_fctr lsf
3653: where p_effective_date
3654: between els.effective_start_date
3655: and els.effective_end_date
3656: and els.los_fctr_id = lsf.los_fctr_id

Line 3674: ben_los_fctr lsf

3670: lsf.mn_los_num,
3671: lsf.no_mx_los_num_apls_flag,
3672: lsf.no_mn_los_num_apls_flag
3673: from ben_elig_los_prte_f els,
3674: ben_los_fctr lsf
3675: where p_effective_date
3676: between els.effective_start_date
3677: and els.effective_end_date
3678: and els.los_fctr_id = lsf.los_fctr_id