[Home] [Help]
6023: between epl.effective_start_date
6024: and epl.effective_end_date
6025: and exists(select null
6026: from ben_elig_pct_fl_tm_prte_f epf,
6027: ben_pct_fl_tm_fctr pff
6028: where epf.pct_fl_tm_fctr_id = pff.pct_fl_tm_fctr_id
6029: and epf.business_group_id = pff.business_group_id
6030: and p_effective_date
6031: between epf.effective_start_date
6045: pff.mn_pct_val,
6046: pff.no_mn_pct_val_flag,
6047: pff.no_mx_pct_val_flag
6048: from ben_elig_pct_fl_tm_prte_f epf,
6049: ben_pct_fl_tm_fctr pff
6050: where epf.pct_fl_tm_fctr_id = pff.pct_fl_tm_fctr_id
6051: and epf.business_group_id = pff.business_group_id
6052: and p_effective_date
6053: between epf.effective_start_date