614: order by ordr_to_aply_num;
615: --
616: cursor c_schedd_enrt_rl_pgm is
617: select formula_id
618: from ben_schedd_enrt_rl_f lrr,
619: ben_popl_enrt_typ_cycl_f pet,
620: ben_enrt_perd enp
621: where pet.pgm_id = l_pgm_id
622: and p_effective_date
639: order by ordr_to_aply_num;
640: --
641: cursor c_schedd_enrt_rl_plnip is
642: select formula_id
643: from ben_schedd_enrt_rl_f lrr,
644: ben_popl_enrt_typ_cycl_f pet,
645: ben_enrt_perd enp
646: -- CWB changes
647: where pet.pl_id = l_pl_id