[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
559: epe.ctfn_rqd_flag,
560: pil.person_id,
561: pil.ler_id
562: from ben_elig_per_elctbl_chc epe,
563: ben_per_in_ler pil,
564: ben_oipl_f oipl
565: where pil.per_in_ler_id = epe.per_in_ler_id
566: and epe.crntly_enrd_flag = 'N'
567: and epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
936: p_enrt_ctfn_typ_cd varchar2 ) is
937: select 'Y'
938: from ben_ler_rqrs_enrt_ctfn_f lre,
939: ben_ler_enrt_ctfn_f lec,
940: ben_per_in_ler pil
941: where lre.pl_id = p_pl_id
942: and pil.per_in_ler_id = p_per_in_ler_id
943: and lre.ler_id = pil.ler_id
944: and p_effective_date between lre.effective_start_date