eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_PRTT_ENRT_RESULT_API dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 1641: ben_elig_per_elctbl_chc epe

1637: pil.lf_evt_ocrd_dt,
1638: pil.ler_id
1639: from ben_enrt_prem ecr,
1640: ben_per_in_ler pil,
1641: ben_elig_per_elctbl_chc epe
1642: where ecr.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
1643: and epe.elig_per_elctbl_chc_id = ecr.elig_per_elctbl_chc_id
1644: and pil.per_in_ler_id = epe.per_in_ler_id
1645: and pil.per_in_ler_stat_cd = 'STRTD'

Line 1724: ,ben_elig_per_elctbl_chc epe

1720: /* Start of Changes for Bug: 1646442: added cursor */
1721: cursor c_pel (p_elig_pe_elctbl_chc_id number) is
1722: select pel.enrt_perd_id,pel.lee_rsn_id
1723: from ben_pil_elctbl_chc_popl pel
1724: ,ben_elig_per_elctbl_chc epe
1725: where pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
1726: and epe.elig_per_elctbl_chc_id = p_elig_pe_elctbl_chc_id;
1727: --
1728: -- Bug : 3866580

Line 3035: ben_elig_per_elctbl_chc epe

3031: pil.ler_id,
3032: epe.elig_per_elctbl_chc_id
3033: from ben_enrt_prem ecr,
3034: ben_per_in_ler pil,
3035: ben_elig_per_elctbl_chc epe
3036: where epe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3037: and epe.elig_per_elctbl_chc_id = ecr.elig_per_elctbl_chc_id
3038: and pil.per_in_ler_id = epe.per_in_ler_id
3039: and pil.per_in_ler_stat_cd = 'STRTD';

Line 3118: from ben_elig_per_elctbl_chc epe,

3114: egd.per_in_ler_id,
3115: pdp.effective_start_date,
3116: pdp.object_version_number,
3117: pdp.cvg_thru_dt --9881657
3118: from ben_elig_per_elctbl_chc epe,
3119: ben_elig_dpnt egd,
3120: ben_elig_cvrd_dpnt_f pdp,
3121: ben_per_in_ler egd_pil,
3122: ben_per_in_ler pdp_pil

Line 3197: from ben_elig_per_elctbl_chc epe,

3193:
3194: ------Check if the elig_cvrd_dpnt_id is set in ben_elig_dpnt table,Bug 8919376
3195: cursor c_check_cvrd_dpnt(p_dpnt_cvg_thru_dt date) is --9881657
3196: select egd.*,pdp.elig_cvrd_dpnt_id cvrd_dpnt_id
3197: from ben_elig_per_elctbl_chc epe,
3198: ben_elig_dpnt egd,
3199: ben_elig_cvrd_dpnt_f pdp,
3200: ben_per_in_ler egd_pil,
3201: ben_per_in_ler pdp_pil

Line 3233: from ben_elig_per_elctbl_chc epe1,

3229: epe.per_in_ler_id,
3230: ecr.enrt_rt_id,
3231: ecr.acty_base_rt_id,
3232: nvl(ecr.dflt_val, ecr.val) val
3233: from ben_elig_per_elctbl_chc epe1,
3234: ben_elig_per_elctbl_chc epe,
3235: ben_enrt_rt ecr
3236: where epe1.prtt_enrt_rslt_id =p_prtt_enrt_rslt_id and
3237: epe1.per_in_ler_id = p_per_in_ler_id and

Line 3234: ben_elig_per_elctbl_chc epe,

3230: ecr.enrt_rt_id,
3231: ecr.acty_base_rt_id,
3232: nvl(ecr.dflt_val, ecr.val) val
3233: from ben_elig_per_elctbl_chc epe1,
3234: ben_elig_per_elctbl_chc epe,
3235: ben_enrt_rt ecr
3236: where epe1.prtt_enrt_rslt_id =p_prtt_enrt_rslt_id and
3237: epe1.per_in_ler_id = p_per_in_ler_id and
3238: epe1.business_group_id=p_business_group_id and

Line 3266: from ben_elig_per_elctbl_chc epe

3262: bpl.effective_start_date and bpl.effective_end_date ;
3263: --
3264: cursor c_prtt_enrt is
3265: select prtt_enrt_rslt_id
3266: from ben_elig_per_elctbl_chc epe
3267: where epe.per_in_ler_id = p_per_in_ler_id
3268: and epe.comp_lvl_cd = 'PLANFC'
3269: and epe.business_group_id = p_business_group_id;
3270: --

Line 3273: from ben_elig_per_elctbl_chc

3269: and epe.business_group_id = p_business_group_id;
3270: --
3271: cursor c_elig_per_elctbl_chc is
3272: select elig_per_elctbl_chc_id
3273: from ben_elig_per_elctbl_chc
3274: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3275: and per_in_ler_id = p_per_in_ler_id;
3276: --
3277: /* Start of Changes for WWBUG: 1646442: added */

Line 3281: ,ben_elig_per_elctbl_chc epe

3277: /* Start of Changes for WWBUG: 1646442: added */
3278: cursor c_pel (p_elig_pe_elctbl_chc_id number) is
3279: select pel.enrt_perd_id,pel.lee_rsn_id
3280: from ben_pil_elctbl_chc_popl pel
3281: ,ben_elig_per_elctbl_chc epe
3282: where pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
3283: and epe.elig_per_elctbl_chc_id = p_elig_pe_elctbl_chc_id;
3284:
3285: l_pel c_pel%rowtype;

Line 5510: from ben_elig_per_elctbl_chc epe

5506: ,epe.pgm_id
5507: ,epe.ptip_id
5508: ,epe.pl_id
5509: ,pil.ler_id
5510: from ben_elig_per_elctbl_chc epe
5511: ,ben_per_in_ler pil
5512: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
5513: and epe.business_group_id = p_business_group_id
5514: and epe.per_in_ler_id = pil.per_in_ler_id

Line 5763: ,ben_elig_per_elctbl_chc epe

5759: ,epe.per_in_ler_id
5760: ,epe.object_version_number epe_ovn
5761: ,enb.enrt_bnft_id
5762: from ben_prtt_enrt_rslt_f pen
5763: ,ben_elig_per_elctbl_chc epe
5764: ,ben_per_in_ler pil
5765: ,ben_enrt_bnft enb
5766: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5767: and pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id (+)

Line 5807: from ben_elig_per_elctbl_chc epe

5803: select epe.elig_per_elctbl_chc_id
5804: ,epe.per_in_ler_id
5805: ,epe.object_version_number epe_ovn
5806: ,enb.enrt_bnft_id
5807: from ben_elig_per_elctbl_chc epe
5808: ,ben_per_in_ler pil
5809: ,ben_enrt_bnft enb
5810: where epe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5811: and nvl(epe.elig_per_elctbl_chc_id, -1) = enb.elig_per_elctbl_chc_id (+)

Line 6340: ,ben_elig_per_elctbl_chc epe

6336: ,pl.name pl_name
6337: ,opt.name opt_name
6338: ,pl.imptd_incm_calc_cd
6339: from ben_prtt_enrt_rslt_f pen
6340: ,ben_elig_per_elctbl_chc epe
6341: ,ben_per_in_ler pil
6342: ,ben_enrt_bnft enb
6343: ,ben_oipl_f oipl
6344: ,ben_pl_f pl

Line 6825: ,ben_elig_per_elctbl_chc epe

6821: --
6822: cursor c_pel (p_elig_pe_elctbl_chc_id number) is
6823: select pel.enrt_perd_id,pel.lee_rsn_id
6824: from ben_pil_elctbl_chc_popl pel
6825: ,ben_elig_per_elctbl_chc epe
6826: where pel.pil_elctbl_chc_popl_id = epe.pil_elctbl_chc_popl_id
6827: and epe.elig_per_elctbl_chc_id = p_elig_pe_elctbl_chc_id;
6828: --
6829: CURSOR c_lee_rsn_for_plan (c_ler_id number, c_pl_id number,c_effective_date date ) IS

Line 6916: from ben_elig_per_elctbl_chc epe,

6912: --Added for Bug#5018328
6913:
6914: cursor c_crntly_enrd_flag(p_elig_pe_elctbl_chc_id number) is
6915: select epe.crntly_enrd_flag,ler.typ_cd
6916: from ben_elig_per_elctbl_chc epe,
6917: ben_ler_f ler,
6918: ben_prtt_enrt_rslt_f pen
6919: where epe.per_in_ler_id=p_per_in_ler_id
6920: and epe.elig_per_elctbl_chc_id=p_elig_pe_elctbl_chc_id

Line 6934: ben_elig_per_elctbl_chc epe,

6930:
6931: cursor c_crntly_enrd_flag_unres(p_elig_pe_elctbl_chc_id number) is
6932: select ler.typ_cd
6933: from ben_prtt_enrt_rslt_f pen,
6934: ben_elig_per_elctbl_chc epe,
6935: ben_ler_f ler
6936: where epe.elig_per_elctbl_chc_id=p_elig_pe_elctbl_chc_id
6937: and epe.per_in_ler_id=p_per_in_ler_id
6938: and pen.ler_id = ler.ler_id

Line 6992: ben_elig_per_elctbl_chc epe

6988: --elected in a Life Event.
6989: cursor c_get_epe(p_pl_typ_id number) is
6990: SELECT epe.*
6991: FROM ben_prtt_enrt_rslt_f pen,
6992: ben_elig_per_elctbl_chc epe
6993: WHERE pen.per_in_ler_id = p_per_in_ler_id
6994: AND pen.business_group_id = p_business_group_id
6995: AND epe.per_in_ler_id = pen.per_in_ler_id
6996: AND epe.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id

Line 7239: ben_elig_per_elctbl_chc epe,

7235: entr_val_at_enrt_flag,
7236: cvg_mlt_cd,
7237: mx_wout_ctfn_val
7238: from ben_enrt_bnft bnft,
7239: ben_elig_per_elctbl_chc epe,
7240: ben_prtt_enrt_rslt_f pen
7241: where epe.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
7242: and epe.per_in_ler_id = c_per_in_ler_id
7243: and pen.per_in_ler_id = c_per_in_ler_id

Line 11596: ben_elig_per_elctbl_chc c

11592: ,r.ptip_id
11593: ,r.enrt_mthd_cd --Bug 2200139
11594: From ben_prtt_enrt_rslt_f r,
11595: ben_oipl_f oipl,
11596: ben_elig_per_elctbl_chc c
11597: Where c.per_in_ler_id = p_per_in_ler_id
11598: and r.prtt_enrt_rslt_id = c.prtt_enrt_rslt_id
11599: and r.per_in_ler_id <> c.per_in_ler_id
11600: and r.person_id = p_person_id

Line 11661: from ben_elig_per_elctbl_chc k

11657: --bug#2602124
11658: and not exists
11659: (
11660: select k.prtt_enrt_rslt_id
11661: from ben_elig_per_elctbl_chc k
11662: Where k.per_in_ler_id = p_per_in_ler_id
11663: and k.prtt_enrt_rslt_id = r.prtt_enrt_rslt_id
11664: and k.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
11665: )

Line 11671: from ben_elig_per_elctbl_chc k

11667: -- otherwise we don't need to delete.
11668: and exists
11669: (
11670: select k.elig_per_elctbl_chc_id
11671: from ben_elig_per_elctbl_chc k
11672: Where k.per_in_ler_id = p_per_in_ler_id
11673: and k.pl_id = r.pl_id
11674: and k.pgm_id= p_pgm_id
11675: and ((k.oipl_id is null and r.oipl_id is null) or

Line 11697: ,ben_elig_per_elctbl_chc c

11693: ,oipl.opt_id
11694: ,r.ptip_id
11695: ,r.enrt_mthd_cd
11696: From ben_prtt_enrt_rslt_f r
11697: ,ben_elig_per_elctbl_chc c
11698: ,ben_oipl_f oipl
11699: ,ben_pil_elctbl_chc_popl pel
11700: Where c.per_in_ler_id = p_per_in_ler_id
11701: and r.prtt_enrt_rslt_id = c.prtt_enrt_rslt_id

Line 11906: ben_elig_per_elctbl_chc c,

11902: ,pil.ler_id
11903: ,c.alws_dpnt_dsgn_flag
11904: ,pl.bnf_dsgn_cd
11905: From ben_prtt_enrt_rslt_f r,
11906: ben_elig_per_elctbl_chc c,
11907: ben_per_in_ler pil,
11908: ben_pl_f pl
11909: Where r.pl_typ_id = p_pl_typ_id
11910: and r.per_in_ler_id = p_per_in_ler_id