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 3600: ben_los_fctr lsf

3596: between elp.effective_start_date
3597: and elp.effective_end_date
3598: and exists(select null
3599: from ben_elig_los_prte_f els,
3600: ben_los_fctr lsf
3601: where p_effective_date
3602: between els.effective_start_date
3603: and els.effective_end_date
3604: and els.los_fctr_id = lsf.los_fctr_id

Line 3622: ben_los_fctr lsf

3618: lsf.mn_los_num,
3619: lsf.no_mx_los_num_apls_flag,
3620: lsf.no_mn_los_num_apls_flag
3621: from ben_elig_los_prte_f els,
3622: ben_los_fctr lsf
3623: where p_effective_date
3624: between els.effective_start_date
3625: and els.effective_end_date
3626: and els.los_fctr_id = lsf.los_fctr_id