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 3651: from ben_elig_los_prte_f els,

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

Line 3673: from ben_elig_los_prte_f els,

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