[Home] [Help]
1646: --
1647: /* Start of Changes for Bug: 1646442: added cursor */
1648: cursor c_pel (p_elig_pe_elctbl_chc_id number) is
1649: select pel.enrt_perd_id,pel.lee_rsn_id
1650: from ben_pil_elctbl_chc_popl pel
1651: ,ben_elig_per_elctbl_chc epe
1652: where pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
1653: and epe.elig_per_elctbl_chc_id = p_elig_pe_elctbl_chc_id;
1654: --
3087: --
3088: /* Start of Changes for WWBUG: 1646442: added */
3089: cursor c_pel (p_elig_pe_elctbl_chc_id number) is
3090: select pel.enrt_perd_id,pel.lee_rsn_id
3091: from ben_pil_elctbl_chc_popl pel
3092: ,ben_elig_per_elctbl_chc epe
3093: where pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
3094: and epe.elig_per_elctbl_chc_id = p_elig_pe_elctbl_chc_id;
3095:
6509: l_pen_ovn c_pen_ovn%rowtype;
6510: --
6511: cursor c_pel (p_elig_pe_elctbl_chc_id number) is
6512: select pel.enrt_perd_id,pel.lee_rsn_id
6513: from ben_pil_elctbl_chc_popl pel
6514: ,ben_elig_per_elctbl_chc epe
6515: where pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
6516: and epe.elig_per_elctbl_chc_id = p_elig_pe_elctbl_chc_id;
6517: --
10097: ,r.enrt_mthd_cd
10098: From ben_prtt_enrt_rslt_f r
10099: ,ben_elig_per_elctbl_chc c
10100: ,ben_oipl_f oipl
10101: ,ben_pil_elctbl_chc_popl pel
10102: Where c.per_in_ler_id = p_per_in_ler_id
10103: and r.prtt_enrt_rslt_id = c.prtt_enrt_rslt_id
10104: and r.per_in_ler_id <> c.per_in_ler_id
10105: and r.person_id = p_person_id
10176: -- For plan not in program (p_pgm_id is null)
10177: --
10178: cursor pl_typ_c is
10179: select distinct pln.pl_typ_id
10180: from ben_pil_elctbl_chc_popl pel,
10181: ben_pl_f pln
10182: where pel.per_in_ler_id = p_per_in_ler_id
10183: and pel.pgm_id is null
10184: and (pel.elcns_made_dt is not null or pel.dflt_asnd_dt is not NULL)