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 1568: ben_elig_per_elctbl_chc epe

1564: pil.lf_evt_ocrd_dt,
1565: pil.ler_id
1566: from ben_enrt_prem ecr,
1567: ben_per_in_ler pil,
1568: ben_elig_per_elctbl_chc epe
1569: where ecr.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
1570: and epe.elig_per_elctbl_chc_id = ecr.elig_per_elctbl_chc_id
1571: and pil.per_in_ler_id = epe.per_in_ler_id
1572: and pil.per_in_ler_stat_cd = 'STRTD'

Line 1651: ,ben_elig_per_elctbl_chc epe

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: --
1655: -- Bug : 3866580

Line 2925: ben_elig_per_elctbl_chc epe

2921: pil.ler_id,
2922: epe.elig_per_elctbl_chc_id
2923: from ben_enrt_prem ecr,
2924: ben_per_in_ler pil,
2925: ben_elig_per_elctbl_chc epe
2926: where epe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2927: and epe.elig_per_elctbl_chc_id = ecr.elig_per_elctbl_chc_id
2928: and pil.per_in_ler_id = epe.per_in_ler_id
2929: and pil.per_in_ler_stat_cd = 'STRTD';

Line 3007: from ben_elig_per_elctbl_chc epe,

3003: select egd.elig_cvrd_dpnt_id,
3004: egd.per_in_ler_id,
3005: pdp.effective_start_date,
3006: pdp.object_version_number
3007: from ben_elig_per_elctbl_chc epe,
3008: ben_elig_dpnt egd,
3009: ben_elig_cvrd_dpnt_f pdp,
3010: ben_per_in_ler egd_pil,
3011: ben_per_in_ler pdp_pil

Line 3044: from ben_elig_per_elctbl_chc epe1,

3040: epe.per_in_ler_id,
3041: ecr.enrt_rt_id,
3042: ecr.acty_base_rt_id,
3043: nvl(ecr.dflt_val, ecr.val) val
3044: from ben_elig_per_elctbl_chc epe1,
3045: ben_elig_per_elctbl_chc epe,
3046: ben_enrt_rt ecr
3047: where epe1.prtt_enrt_rslt_id =p_prtt_enrt_rslt_id and
3048: epe1.per_in_ler_id = p_per_in_ler_id and

Line 3045: ben_elig_per_elctbl_chc epe,

3041: ecr.enrt_rt_id,
3042: ecr.acty_base_rt_id,
3043: nvl(ecr.dflt_val, ecr.val) val
3044: from ben_elig_per_elctbl_chc epe1,
3045: ben_elig_per_elctbl_chc epe,
3046: ben_enrt_rt ecr
3047: where epe1.prtt_enrt_rslt_id =p_prtt_enrt_rslt_id and
3048: epe1.per_in_ler_id = p_per_in_ler_id and
3049: epe1.business_group_id=p_business_group_id and

Line 3077: from ben_elig_per_elctbl_chc epe

3073: bpl.effective_start_date and bpl.effective_end_date ;
3074: --
3075: cursor c_prtt_enrt is
3076: select prtt_enrt_rslt_id
3077: from ben_elig_per_elctbl_chc epe
3078: where epe.per_in_ler_id = p_per_in_ler_id
3079: and epe.comp_lvl_cd = 'PLANFC'
3080: and epe.business_group_id = p_business_group_id;
3081: --

Line 3084: from ben_elig_per_elctbl_chc

3080: and epe.business_group_id = p_business_group_id;
3081: --
3082: cursor c_elig_per_elctbl_chc is
3083: select elig_per_elctbl_chc_id
3084: from ben_elig_per_elctbl_chc
3085: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3086: and per_in_ler_id = p_per_in_ler_id;
3087: --
3088: /* Start of Changes for WWBUG: 1646442: added */

Line 3092: ,ben_elig_per_elctbl_chc epe

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:
3096: l_pel c_pel%rowtype;

Line 5221: from ben_elig_per_elctbl_chc epe

5217: ,epe.pgm_id
5218: ,epe.ptip_id
5219: ,epe.pl_id
5220: ,pil.ler_id
5221: from ben_elig_per_elctbl_chc epe
5222: ,ben_per_in_ler pil
5223: where elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
5224: and epe.business_group_id = p_business_group_id
5225: and epe.per_in_ler_id = pil.per_in_ler_id

Line 5474: ,ben_elig_per_elctbl_chc epe

5470: ,epe.per_in_ler_id
5471: ,epe.object_version_number epe_ovn
5472: ,enb.enrt_bnft_id
5473: from ben_prtt_enrt_rslt_f pen
5474: ,ben_elig_per_elctbl_chc epe
5475: ,ben_per_in_ler pil
5476: ,ben_enrt_bnft enb
5477: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5478: and pen.prtt_enrt_rslt_id = epe.prtt_enrt_rslt_id (+)

Line 5518: from ben_elig_per_elctbl_chc epe

5514: select epe.elig_per_elctbl_chc_id
5515: ,epe.per_in_ler_id
5516: ,epe.object_version_number epe_ovn
5517: ,enb.enrt_bnft_id
5518: from ben_elig_per_elctbl_chc epe
5519: ,ben_per_in_ler pil
5520: ,ben_enrt_bnft enb
5521: where epe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
5522: and nvl(epe.elig_per_elctbl_chc_id, -1) = enb.elig_per_elctbl_chc_id (+)

Line 6051: ,ben_elig_per_elctbl_chc epe

6047: ,pl.name pl_name
6048: ,opt.name opt_name
6049: ,pl.imptd_incm_calc_cd
6050: from ben_prtt_enrt_rslt_f pen
6051: ,ben_elig_per_elctbl_chc epe
6052: ,ben_per_in_ler pil
6053: ,ben_enrt_bnft enb
6054: ,ben_oipl_f oipl
6055: ,ben_pl_f pl

Line 6514: ,ben_elig_per_elctbl_chc epe

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: --
6518: CURSOR c_lee_rsn_for_plan (c_ler_id number, c_pl_id number,c_effective_date date ) IS

Line 6604: from ben_elig_per_elctbl_chc epe,

6600: --Added for Bug#5018328
6601:
6602: cursor c_crntly_enrd_flag(p_elig_pe_elctbl_chc_id number) is
6603: select epe.crntly_enrd_flag,ler.typ_cd
6604: from ben_elig_per_elctbl_chc epe,
6605: ben_ler_f ler,
6606: ben_prtt_enrt_rslt_f pen
6607: where epe.per_in_ler_id=p_per_in_ler_id
6608: and epe.elig_per_elctbl_chc_id=p_elig_pe_elctbl_chc_id

Line 6622: ben_elig_per_elctbl_chc epe,

6618:
6619: cursor c_crntly_enrd_flag_unres(p_elig_pe_elctbl_chc_id number) is
6620: select ler.typ_cd
6621: from ben_prtt_enrt_rslt_f pen,
6622: ben_elig_per_elctbl_chc epe,
6623: ben_ler_f ler
6624: where epe.elig_per_elctbl_chc_id=p_elig_pe_elctbl_chc_id
6625: and epe.per_in_ler_id=p_per_in_ler_id
6626: and pen.ler_id = ler.ler_id

Line 9998: ben_elig_per_elctbl_chc c

9994: ,r.ptip_id
9995: ,r.enrt_mthd_cd --Bug 2200139
9996: From ben_prtt_enrt_rslt_f r,
9997: ben_oipl_f oipl,
9998: ben_elig_per_elctbl_chc c
9999: Where c.per_in_ler_id = p_per_in_ler_id
10000: and r.prtt_enrt_rslt_id = c.prtt_enrt_rslt_id
10001: and r.per_in_ler_id <> c.per_in_ler_id
10002: and r.person_id = p_person_id

Line 10063: from ben_elig_per_elctbl_chc k

10059: --bug#2602124
10060: and not exists
10061: (
10062: select k.prtt_enrt_rslt_id
10063: from ben_elig_per_elctbl_chc k
10064: Where k.per_in_ler_id = p_per_in_ler_id
10065: and k.prtt_enrt_rslt_id = r.prtt_enrt_rslt_id
10066: and k.comp_lvl_cd not in ('PLANFC', 'PLANIMP')
10067: )

Line 10073: from ben_elig_per_elctbl_chc k

10069: -- otherwise we don't need to delete.
10070: and exists
10071: (
10072: select k.elig_per_elctbl_chc_id
10073: from ben_elig_per_elctbl_chc k
10074: Where k.per_in_ler_id = p_per_in_ler_id
10075: and k.pl_id = r.pl_id
10076: and k.pgm_id= p_pgm_id
10077: and ((k.oipl_id is null and r.oipl_id is null) or

Line 10099: ,ben_elig_per_elctbl_chc c

10095: ,oipl.opt_id
10096: ,r.ptip_id
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

Line 10308: ben_elig_per_elctbl_chc c,

10304: ,pil.ler_id
10305: ,c.alws_dpnt_dsgn_flag
10306: ,pl.bnf_dsgn_cd
10307: From ben_prtt_enrt_rslt_f r,
10308: ben_elig_per_elctbl_chc c,
10309: ben_per_in_ler pil,
10310: ben_pl_f pl
10311: Where r.pl_typ_id = p_pl_typ_id
10312: and r.per_in_ler_id = p_per_in_ler_id