75: opt.effective_start_date and opt.effective_end_date ;
76:
77: cursor c_ptp is
78: select ptp.opt_typ_cd
79: from ben_pl_typ_f ptp
80: where ptp.pl_typ_id = p_pl_typ_id
81: and p_effective_date between
82: ptp.effective_start_date and ptp.effective_end_date ;
83:
81: and p_effective_date between
82: ptp.effective_start_date and ptp.effective_end_date ;
83:
84: l_group_opt_id ben_opt_f.Group_opt_id%type ;
85: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%type ;
86: l_opt_ovn number ;
87: l_eff_st_dt date ;
88: l_eff_end_dt date ;
89:
408: opt.effective_start_date and opt.effective_end_date ;
409:
410: cursor c_ptp is
411: select ptp.opt_typ_cd
412: from ben_pl_typ_f ptp
413: where ptp.pl_typ_id = p_pl_typ_id
414: and p_effective_date between
415: ptp.effective_start_date and ptp.effective_end_date ;
416:
414: and p_effective_date between
415: ptp.effective_start_date and ptp.effective_end_date ;
416:
417: l_group_opt_id ben_opt_f.Group_opt_id%type ;
418: l_opt_typ_cd ben_pl_typ_f.opt_typ_cd%type ;
419: l_opt_ovn number ;
420: l_eff_st_dt date ;
421: l_eff_end_dt date ;
422: