5474: between elp.effective_start_date
5475: and elp.effective_end_date
5476: and exists(select null
5477: from ben_elig_hrs_wkd_prte_f ecl,
5478: ben_hrs_wkd_in_perd_fctr clf
5479: where ecl.hrs_wkd_in_perd_fctr_id =
5480: clf.hrs_wkd_in_perd_fctr_id
5481: and ecl.business_group_id = clf.business_group_id
5482: and p_effective_date
5498: clf.no_mn_hrs_wkd_flag,
5499: clf.no_mx_hrs_wkd_flag,
5500: clf.hrs_src_cd
5501: from ben_elig_hrs_wkd_prte_f ecl,
5502: ben_hrs_wkd_in_perd_fctr clf
5503: where ecl.hrs_wkd_in_perd_fctr_id = clf.hrs_wkd_in_perd_fctr_id
5504: and ecl.business_group_id = clf.business_group_id
5505: and p_effective_date
5506: between ecl.effective_start_date