1487: --
1488: cursor c8 is
1489: select 'x' found
1490: from ben_cvg_amt_calc_mthd_f ccm,
1491: ben_pl_typ_f pt,
1492: ben_pl_f pl
1493: where pl.pl_id = p_pl_id
1494: and pt.pl_typ_id = pl.pl_typ_id
1495: and pt.opt_typ_cd = 'CWB'
9829: plt.name,
9830: Plt.MN_ENRL_RQD_NUM,
9831: plt.MX_ENRL_ALWD_NUM
9832: from ben_ptip_f ptip
9833: , ben_pl_typ_f plt
9834: where ptip.ptip_id = p_ptip_id
9835: and ptip.pl_typ_id = plt.pl_typ_id
9836: and ptip.business_group_id = p_business_group_id
9837: and p_effective_date between