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_SSPNDD_ENROLLMENT dependencies on BEN_ELIG_PER_ELCTBL_CHC

Line 578: from ben_elig_per_elctbl_chc epe, ben_per_in_ler pil

574: l_interim_bnft_amt NUMBER := p_interim_bnft_amt;
575: --
576: cursor c_epe(v_elig_per_elctbl_chc_id number) is
577: select epe.*
578: from ben_elig_per_elctbl_chc epe, ben_per_in_ler pil
579: where epe.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id
580: and epe.per_in_ler_id = pil.per_in_ler_id(+) /* Bug 5225780 */
581: and (pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT') or
582: pil.per_in_ler_stat_cd is null);

Line 984: from ben_elig_per_elctbl_chc epe,ben_per_in_ler pil

980: epe.pl_id,
981: epe.pl_typ_id,
982: epe.oipl_id,
983: pil.ler_id
984: from ben_elig_per_elctbl_chc epe,ben_per_in_ler pil
985: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
986: and pil.per_in_ler_id = epe.per_in_ler_id;
987:
988: l_epe c_epe%rowtype;

Line 1070: ben_elig_per_elctbl_chc epe,

1066: epe.elig_per_elctbl_chc_id,
1067: -- RCHASE Bug#5353 added
1068: per.prtt_enrt_rslt_id
1069: from ben_prtt_enrt_rslt_f per,
1070: ben_elig_per_elctbl_chc epe,
1071: ben_per_in_ler pil
1072: where pil.business_group_id=p_business_group_id and
1073: pil.person_id=p_person_id and
1074: pil.per_in_ler_stat_cd='STRTD' and

Line 1123: from ben_elig_per_elctbl_chc epe,

1119: per.pl_id = nvl(v_pl_id, per.pl_id) and
1120: nvl(per.oipl_id,-1) = nvl(v_oipl_id,nvl(per.oipl_id,-1)) and
1121: not exists (
1122: select null
1123: from ben_elig_per_elctbl_chc epe,
1124: ben_per_in_ler pil
1125: where pil.business_group_id=p_business_group_id and
1126: pil.person_id=p_person_id and
1127: pil.per_in_ler_stat_cd='STRTD' and

Line 1275: ben_elig_per_elctbl_chc epe,

1271: cursor c_default_epe is
1272: select epe.elig_per_elctbl_chc_id,
1273: enb.enrt_bnft_id
1274: from ben_per_in_ler pil,
1275: ben_elig_per_elctbl_chc epe,
1276: ben_pl_f pl,
1277: ben_enrt_bnft enb
1278: where
1279: pil.business_group_id=p_business_group_id and

Line 1312: ben_elig_per_elctbl_chc epe,

1308: cursor c_default_pl_epe is
1309: select epe.elig_per_elctbl_chc_id,
1310: enb.enrt_bnft_id
1311: from ben_per_in_ler pil,
1312: ben_elig_per_elctbl_chc epe,
1313: ben_pl_f pl,
1314: ben_enrt_bnft enb
1315: where
1316: pil.business_group_id=p_business_group_id and

Line 1354: ben_elig_per_elctbl_chc epe,

1350: cursor c_default_bnft_epe is
1351: select epe.elig_per_elctbl_chc_id,
1352: enb.enrt_bnft_id
1353: from ben_per_in_ler pil,
1354: ben_elig_per_elctbl_chc epe,
1355: ben_pl_f pl,
1356: ben_enrt_bnft enb
1357: where
1358: pil.business_group_id=p_business_group_id and

Line 1397: ben_elig_per_elctbl_chc epe,

1393: cursor c_default_bnft_pl_epe is
1394: select epe.elig_per_elctbl_chc_id,
1395: enb.enrt_bnft_id
1396: from ben_per_in_ler pil,
1397: ben_elig_per_elctbl_chc epe,
1398: ben_pl_f pl,
1399: ben_enrt_bnft enb
1400: where
1401: pil.business_group_id=p_business_group_id and

Line 1436: ben_elig_per_elctbl_chc epe,

1432: --
1433: cursor c_min_oipl_epe is
1434: select epe.elig_per_elctbl_chc_id, eb.enrt_bnft_id
1435: from ben_per_in_ler pil,
1436: ben_elig_per_elctbl_chc epe,
1437: ben_pl_f pl,
1438: ben_enrt_bnft eb
1439: where
1440: pil.business_group_id=p_business_group_id and

Line 1474: ben_elig_per_elctbl_chc epe,

1470: cursor c_min_pl_epe is
1471: select epe.elig_per_elctbl_chc_id,
1472: enb.enrt_bnft_id
1473: from ben_per_in_ler pil,
1474: ben_elig_per_elctbl_chc epe,
1475: ben_enrt_bnft enb,
1476: ben_pl_f pl
1477: where pil.business_group_id=p_business_group_id and
1478: pil.person_id=p_person_id and

Line 1509: ben_elig_per_elctbl_chc epe,

1505: cursor c_next_lower_pl_epe is
1506: select epe.elig_per_elctbl_chc_id,
1507: eb.enrt_bnft_id
1508: from ben_per_in_ler pil,
1509: ben_elig_per_elctbl_chc epe,
1510: ben_pl_f pl,
1511: ben_enrt_bnft eb
1512: where
1513: pil.business_group_id=p_business_group_id and

Line 1523: (select 'Y' from ben_elig_per_elctbl_chc epe1,

1519: /*Bug 8528791 : Added the below condition to pick the interim if the LE has no electability */
1520: --epe.elctbl_flag='Y' and
1521: (epe.elctbl_flag='Y' or ('Y' = (select 'Y' from dual
1522: where not exists
1523: (select 'Y' from ben_elig_per_elctbl_chc epe1,
1524: ben_per_in_ler pil1
1525: where epe1.pl_id =p_pl_id
1526: and epe1.elctbl_flag='Y'
1527: and epe1.per_in_ler_id=pil1.per_in_ler_id

Line 1558: ben_elig_per_elctbl_chc epe,

1554: cursor c_next_lower_pl_typ_epe is
1555: select epe.elig_per_elctbl_chc_id,
1556: eb.enrt_bnft_id
1557: from ben_per_in_ler pil,
1558: ben_elig_per_elctbl_chc epe,
1559: ben_enrt_bnft eb,
1560: ben_pl_f pl
1561: where
1562: pil.business_group_id=p_business_group_id and

Line 1572: (select 'Y' from ben_elig_per_elctbl_chc epe1,

1568: /*Bug 8528791 : Added the below condition to pick the interim if the LE has no electability */
1569: --epe.elctbl_flag='Y' and
1570: (epe.elctbl_flag='Y' or ('Y' = (select 'Y' from dual
1571: where not exists
1572: (select 'Y' from ben_elig_per_elctbl_chc epe1,
1573: ben_per_in_ler pil1
1574: where epe1.pl_typ_id =p_pl_typ_id
1575: and epe1.elctbl_flag='Y'
1576: and epe1.per_in_ler_id=pil1.per_in_ler_id

Line 1607: ben_elig_per_elctbl_chc epe,

1603: cursor c_min_bnft_epe is
1604: select epe.elig_per_elctbl_chc_id,
1605: enb.enrt_bnft_id
1606: from ben_per_in_ler pil,
1607: ben_elig_per_elctbl_chc epe,
1608: ben_enrt_bnft enb,
1609: ben_pl_f pl
1610: where
1611: pil.business_group_id=p_business_group_id and

Line 1648: ben_elig_per_elctbl_chc epe,

1644: cursor c_next_lower_bnft_pl_epe is
1645: select epe.elig_per_elctbl_chc_id,
1646: eb.enrt_bnft_id
1647: from ben_per_in_ler pil,
1648: ben_elig_per_elctbl_chc epe,
1649: ben_enrt_bnft eb,
1650: ben_pl_f pl
1651: where
1652: pil.business_group_id=p_business_group_id and

Line 1717: ben_elig_per_elctbl_chc epe --Bug 3042379 Dont select 'R' cases

1713: enb1.enrt_bnft_id
1714: from ben_enrt_bnft enb1,
1715: ben_enrt_bnft enb2,
1716: ben_pl_f pl,
1717: ben_elig_per_elctbl_chc epe --Bug 3042379 Dont select 'R' cases
1718: --to make it consistent with other
1719: --interim cursors.
1720: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
1721: and nvl(epe.dpnt_dsgn_cd,'O')='O'

Line 1747: ben_elig_per_elctbl_chc epe --Bug 3042379 Dont select 'R' cases

1743: enb1.enrt_bnft_id
1744: from ben_enrt_bnft enb1,
1745: ben_enrt_bnft enb2,
1746: ben_pl_f pl,
1747: ben_elig_per_elctbl_chc epe --Bug 3042379 Dont select 'R' cases
1748: --to make it consistent with other
1749: --interim cursors.
1750: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
1751: and nvl(epe.dpnt_dsgn_cd,'O')='O'

Line 1789: from ben_elig_per_elctbl_chc epe_current,

1785: --
1786: /*
1787: cursor c_current_same_epe(c_current_epe_id number) is
1788: select epe_new.elig_per_elctbl_chc_id
1789: from ben_elig_per_elctbl_chc epe_current,
1790: ben_elig_per_elctbl_chc epe_new,
1791: ben_per_in_ler pil_new
1792: where epe_current.elig_per_elctbl_chc_id = c_current_epe_id
1793: and epe_current.pl_id = epe_new.pl_id

Line 1790: ben_elig_per_elctbl_chc epe_new,

1786: /*
1787: cursor c_current_same_epe(c_current_epe_id number) is
1788: select epe_new.elig_per_elctbl_chc_id
1789: from ben_elig_per_elctbl_chc epe_current,
1790: ben_elig_per_elctbl_chc epe_new,
1791: ben_per_in_ler pil_new
1792: where epe_current.elig_per_elctbl_chc_id = c_current_epe_id
1793: and epe_current.pl_id = epe_new.pl_id
1794: and nvl(epe_current.oipl_id,-1) = nvl(epe_new.oipl_id,-1)

Line 1808: ben_elig_per_elctbl_chc epe_new,

1804: --
1805: cursor c_current_same_epe(c_current_pen_id number) is
1806: select epe_new.elig_per_elctbl_chc_id
1807: from ben_prtt_enrt_rslt_f pen_current,
1808: ben_elig_per_elctbl_chc epe_new,
1809: ben_per_in_ler pil_new
1810: where pen_current.prtt_enrt_rslt_id = c_current_pen_id
1811: and pen_current.pl_id = epe_new.pl_id
1812: and nvl(pen_current.pgm_id,-1) = nvl(epe_new.pgm_id,-1)

Line 1884: ben_elig_per_elctbl_chc new_epe

1880: select new_epe.elig_per_elctbl_chc_id,
1881: interim.bnft_ordr_num ordr_num,
1882: interim.bnft_amt
1883: from ben_prtt_enrt_rslt_f interim,
1884: ben_elig_per_elctbl_chc new_epe
1885: where interim.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
1886: and interim.per_in_ler_id <> c_per_in_ler_id
1887: and interim.effective_end_date = hr_api.g_eot
1888: and interim.enrt_cvg_thru_dt = hr_api.g_eot

Line 2657: From ben_elig_per_elctbl_chc epe,

2653: pen.pl_id pen_pl_id,
2654: pen.oipl_id pen_oipl_id,
2655: pen.enrt_cvg_thru_dt,
2656: pen.object_version_number
2657: From ben_elig_per_elctbl_chc epe,
2658: ben_prtt_enrt_rslt_f pen
2659: Where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
2660: and epe.business_group_id = p_business_group_id
2661: and pen.prtt_enrt_rslt_id(+)=epe.prtt_enrt_rslt_id

Line 3039: ,ben_elig_per_elctbl_chc epe

3035: ,pen.plip_ordr_num /*ENH*/
3036: ,pen.bnft_ordr_num /*ENH*/
3037: ,epe.dpnt_dsgn_cd
3038: From ben_prtt_enrt_rslt_f pen
3039: ,ben_elig_per_elctbl_chc epe
3040: ,ben_per_in_ler pil
3041: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3042: and pen.business_group_id= p_business_group_id
3043: and pen.prtt_enrt_rslt_stat_cd is null

Line 3081: From ben_elig_per_elctbl_chc

3077: pen.effective_start_date and pen.effective_end_date
3078: ;
3079: Cursor c_epe (c_elig_per_elctbl_chc_id number) is
3080: select *
3081: From ben_elig_per_elctbl_chc
3082: Where elig_per_elctbl_chc_id = c_elig_per_elctbl_chc_id
3083: ;
3084: cursor c_prv_ee (c_prtt_enrt_rslt_id number) is
3085: select prv.prtt_rt_val_id

Line 3769: ben_elig_per_elctbl_chc epe

3765: --END Bug 2958032
3766: from ben_prtt_enrt_rslt_f pen,
3767: ben_pil_elctbl_chc_popl pel,
3768: ben_per_in_ler pil,
3769: ben_elig_per_elctbl_chc epe
3770: where pen.prtt_enrt_rslt_id=c_prtt_enrt_rslt_id
3771: and p_effective_date between
3772: pen.effective_start_date and pen.effective_end_date
3773: and pen.person_id=pil.person_id

Line 3790: from ben_elig_per_elctbl_chc epe

3786: ;
3787: ----Bug 7557403
3788: cursor c_fonm_check(p_epe_id number) is
3789: select epe.fonm_cvg_strt_dt
3790: from ben_elig_per_elctbl_chc epe
3791: where epe.elig_per_elctbl_chc_id = p_epe_id
3792: and epe.business_group_id=p_business_group_id;
3793:
3794: l_fonm_check c_fonm_check%rowtype;