275: --
276: CURSOR c_opt_id (p_oipl_id NUMBER)
277: IS
278: SELECT opt_id, pl_id
279: FROM ben_oipl_f
280: WHERE oipl_id = p_oipl_id;
281:
282: --
283: l_opt_id c_opt_id%ROWTYPE;
662: --
663: /* CURSOR c_trk_inelig_per_flag (p_opt_id NUMBER)
664: IS
665: SELECT trk_inelig_per_flag
666: FROM ben_oipl_f
667: WHERE opt_id = p_opt_id;
668:
669: --
670: l_trk_inelig_per_flag ben_oipl_f.trk_inelig_per_flag%TYPE;
666: FROM ben_oipl_f
667: WHERE opt_id = p_opt_id;
668:
669: --
670: l_trk_inelig_per_flag ben_oipl_f.trk_inelig_per_flag%TYPE;
671:
672: --
673: CURSOR c_pep_ovn (p_elig_per_id IN NUMBER)
674: IS