APPS.BEN_DET_ENRT_RATES dependencies on BEN_PRTT_ENRT_RSLT_F

Line 105: from ben_prtt_enrt_rslt_f pen

101: pen.pgm_id,
102: pen.oipl_id,
103: pen.enrt_cvg_strt_dt,
104: pen.comp_lvl_cd
105: from ben_prtt_enrt_rslt_f pen
106: where pen.person_id = c_person_id
107: --
108: -- Bug 6445880
109: -- Changed enrt_mthd_cd checks, to allow Default Enrollment records to be picked

Line 153: from ben_prtt_enrt_rslt_f pen

149: ,c_effective_date in date
150: )
151: is
152: select distinct pen.pgm_id
153: from ben_prtt_enrt_rslt_f pen
154: where pen.person_id = c_person_id
155: and ( pen.enrt_mthd_cd = c_enrt_mthd_cd
156: or pen.enrt_mthd_cd = 'O' ) -- Bug 2200139 Override Enhancements
157: and pen.prtt_enrt_rslt_stat_cd is null

Line 174: from ben_prtt_enrt_rslt_f pen

170: --
171: cursor c_spcl_enrt_rslt(v_pl_id in number, v_oipl_id in number)
172: is
173: select '1'
174: from ben_prtt_enrt_rslt_f pen
175: where pen.person_id = p_person_id
176: and pen.business_group_id = p_business_group_id
177: and (pen.pl_id = v_pl_id or
178: pen.oipl_id = v_oipl_id)

Line 209: ben_prtt_enrt_rslt_f pen

205: pel.acty_ref_perd_cd
206: from ben_elig_per_elctbl_chc epe,
207: ben_per_in_ler pil,
208: ben_pil_elctbl_chc_popl pel,
209: ben_prtt_enrt_rslt_f pen
210: where epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
211: and pil.per_in_ler_id=epe.per_in_ler_id
212: and pil.per_in_ler_id = p_per_in_ler_id
213: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')

Line 357: ben_prtt_enrt_rslt_f pen,

353: ben_pil_elctbl_chc_popl pel,
354: ben_enrt_rt ecr1,
355: ben_enrt_rt ecr2,
356: ben_enrt_bnft enb,
357: ben_prtt_enrt_rslt_f pen,
358: ben_bnft_prvdr_pool_f bpp -- join to get only current pgm_id - rgajula
359: where
360: pil.per_in_ler_id=p_per_in_ler_id and
361: pil.business_group_id=p_business_group_id and

Line 846: from ben_prtt_enrt_rslt_f pen

842: pen.pgm_id,
843: pen.oipl_id,
844: pen.enrt_cvg_strt_dt,
845: pen.comp_lvl_cd
846: from ben_prtt_enrt_rslt_f pen
847: where pen.person_id = c_person_id
848: and pen.enrt_mthd_cd = c_enrt_mthd_cd
849: and pen.prtt_enrt_rslt_stat_cd is null
850: and pen.per_in_ler_id = c_per_in_ler_id

Line 894: ben_prtt_enrt_rslt_f pen

890: epe.spcl_rt_oipl_id,
891: pel.acty_ref_perd_cd
892: from ben_elig_per_elctbl_chc epe,
893: ben_pil_elctbl_chc_popl pel,
894: ben_prtt_enrt_rslt_f pen
895: where epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
896: and epe.per_in_ler_id = p_per_in_ler_id
897: and pen.prtt_enrt_rslt_id=v_enrt_rslt_id
898: and nvl(pen.pgm_id,-1)=nvl(epe.pgm_id,-1)

Line 1179: ben_prtt_enrt_rslt_f pen

1175: epe.spcl_rt_oipl_id,
1176: pel.acty_ref_perd_cd
1177: from ben_elig_per_elctbl_chc epe,
1178: ben_pil_elctbl_chc_popl pel,
1179: ben_prtt_enrt_rslt_f pen
1180: where epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
1181: and epe.per_in_ler_id = p_per_in_ler_id
1182: and pen.prtt_enrt_rslt_id=v_enrt_rslt_id
1183: and nvl(pen.pgm_id,-1)=nvl(epe.pgm_id,-1)

Line 1214: from ben_prtt_enrt_rslt_f pen

1210: --
1211: cursor c_rslt_pgm is
1212: select pen.pgm_id,
1213: pen.enrt_mthd_cd
1214: from ben_prtt_enrt_rslt_f pen
1215: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1216: and pen.prtt_enrt_rslt_stat_cd is null;
1217: --
1218: cursor c_prtt_enrt (p_pgm_id number) is