APPS.BEN_ELP_CACHE dependencies on BEN_ELIG_LOS_PRTE_F

Line 1568: l_tabdet_set(0).tab_name := 'ben_elig_los_prte_f';

1564: l_mastertab_name := 'ben_eligy_prfl_f';
1565: l_masterpkcol_name := 'eligy_prfl_id';
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: --

Line 3599: from ben_elig_los_prte_f els,

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

Line 3621: from ben_elig_los_prte_f els,

3617: lsf.mx_los_num,
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