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 125: ben_prtt_enrt_rslt_f pen1,

121: or (c_enrt_mthd_cd = 'D' and
122: pen.enrt_mthd_cd = 'E' and
123: exists (select null
124: from ben_bnft_pool_rlovr_rqmt_f rlovr,
125: ben_prtt_enrt_rslt_f pen1,
126: ben_bnft_prvdd_ldgr_f ldgr,
127: ben_acty_base_rt_f abr
128: where pen1.pgm_id = pen.pgm_id
129: and pen1.comp_lvl_cd = 'PLANFC'

Line 197: from ben_prtt_enrt_rslt_f pen

193: ,c_effective_date in date
194: )
195: is
196: select distinct pen.pgm_id
197: from ben_prtt_enrt_rslt_f pen
198: where pen.person_id = c_person_id
199: and ( pen.enrt_mthd_cd in ('A','D','E') -- Bug 15938962
200: or pen.enrt_mthd_cd = 'O' ) -- Bug 2200139 Override Enhancements
201: and pen.prtt_enrt_rslt_stat_cd is null

Line 218: from ben_prtt_enrt_rslt_f pen

214: --
215: cursor c_spcl_enrt_rslt(v_pl_id in number, v_oipl_id in number)
216: is
217: select '1'
218: from ben_prtt_enrt_rslt_f pen
219: where pen.person_id = p_person_id
220: and pen.business_group_id = p_business_group_id
221: and (pen.pl_id = v_pl_id or
222: pen.oipl_id = v_oipl_id)

Line 253: ben_prtt_enrt_rslt_f pen

249: pel.acty_ref_perd_cd
250: from ben_elig_per_elctbl_chc epe,
251: ben_per_in_ler pil,
252: ben_pil_elctbl_chc_popl pel,
253: ben_prtt_enrt_rslt_f pen
254: where epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
255: and pil.per_in_ler_id=epe.per_in_ler_id
256: and pil.per_in_ler_id = p_per_in_ler_id
257: and pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT')

Line 401: ben_prtt_enrt_rslt_f pen,

397: ben_pil_elctbl_chc_popl pel,
398: ben_enrt_rt ecr1,
399: ben_enrt_rt ecr2,
400: ben_enrt_bnft enb,
401: ben_prtt_enrt_rslt_f pen,
402: ben_bnft_prvdr_pool_f bpp -- join to get only current pgm_id - rgajula
403: where
404: pil.per_in_ler_id=p_per_in_ler_id and
405: pil.business_group_id=p_business_group_id and

Line 911: from ben_prtt_enrt_rslt_f pen

907: pen.pgm_id,
908: pen.oipl_id,
909: pen.enrt_cvg_strt_dt,
910: pen.comp_lvl_cd
911: from ben_prtt_enrt_rslt_f pen
912: where pen.person_id = c_person_id
913: and pen.enrt_mthd_cd = c_enrt_mthd_cd
914: and pen.prtt_enrt_rslt_stat_cd is null
915: and pen.per_in_ler_id = c_per_in_ler_id

Line 959: ben_prtt_enrt_rslt_f pen

955: epe.spcl_rt_oipl_id,
956: pel.acty_ref_perd_cd
957: from ben_elig_per_elctbl_chc epe,
958: ben_pil_elctbl_chc_popl pel,
959: ben_prtt_enrt_rslt_f pen
960: where epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
961: and epe.per_in_ler_id = p_per_in_ler_id
962: and pen.prtt_enrt_rslt_id=v_enrt_rslt_id
963: and nvl(pen.pgm_id,-1)=nvl(epe.pgm_id,-1)

Line 1244: ben_prtt_enrt_rslt_f pen

1240: epe.spcl_rt_oipl_id,
1241: pel.acty_ref_perd_cd
1242: from ben_elig_per_elctbl_chc epe,
1243: ben_pil_elctbl_chc_popl pel,
1244: ben_prtt_enrt_rslt_f pen
1245: where epe.pil_elctbl_chc_popl_id = pel.pil_elctbl_chc_popl_id
1246: and epe.per_in_ler_id = p_per_in_ler_id
1247: and pen.prtt_enrt_rslt_id=v_enrt_rslt_id
1248: and nvl(pen.pgm_id,-1)=nvl(epe.pgm_id,-1)

Line 1279: from ben_prtt_enrt_rslt_f pen

1275: --
1276: cursor c_rslt_pgm is
1277: select pen.pgm_id,
1278: pen.enrt_mthd_cd
1279: from ben_prtt_enrt_rslt_f pen
1280: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1281: and pen.prtt_enrt_rslt_stat_cd is null;
1282: --
1283: cursor c_prtt_enrt (p_pgm_id number) is