[Home] [Help]
21: local var's instead of referencing
22: for loop cursor
23: 31 Mar 99 T Guy 115.3 Added checking for crntly enrolled
24: if so then do not create ctfn's
25: changed ben_per_in_ler_f to a non
26: date tracked table and fixed approp.
27: cursors
28: 13 Apr 99 T Guy 115.4 Fixed ben_elig_per_elctbl_chc api
29: call
561: epe.ctfn_rqd_flag,
562: pil.person_id,
563: pil.ler_id
564: from ben_elig_per_elctbl_chc epe,
565: ben_per_in_ler pil,
566: ben_oipl_f oipl
567: where pil.per_in_ler_id = epe.per_in_ler_id
568: and epe.crntly_enrd_flag = 'N'
569: and epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
938: p_enrt_ctfn_typ_cd varchar2 ) is
939: select 'Y'
940: from ben_ler_rqrs_enrt_ctfn_f lre,
941: ben_ler_enrt_ctfn_f lec,
942: ben_per_in_ler pil
943: where lre.pl_id = p_pl_id
944: and pil.per_in_ler_id = p_per_in_ler_id
945: and lre.ler_id = pil.ler_id
946: and p_effective_date between lre.effective_start_date