5747: where p_effective_date
5748: between elp.effective_start_date
5749: and elp.effective_end_date
5750: and exists(select null
5751: from ben_elig_comp_lvl_prte_f ecl,
5752: ben_comp_lvl_fctr clf
5753: where ecl.comp_lvl_fctr_id = clf.comp_lvl_fctr_id
5754: and ecl.business_group_id = clf.business_group_id
5755: and p_effective_date
5770: clf.no_mn_comp_flag,
5771: clf.no_mx_comp_flag,
5772: clf.comp_src_cd,
5773: clf.comp_lvl_fctr_id
5774: from ben_elig_comp_lvl_prte_f ecl,
5775: ben_comp_lvl_fctr clf
5776: where ecl.comp_lvl_fctr_id = clf.comp_lvl_fctr_id
5777: and ecl.business_group_id = clf.business_group_id
5778: and p_effective_date