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_PER_IN_LER

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 1071: ben_per_in_ler pil

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
1075: per.person_id=p_person_id and

Line 1102: ben_per_in_ler pinl

1098: to_number(null) elig_per_elctbl_chc_id,
1099: -- RCHASE Bug#5353
1100: per.prtt_enrt_rslt_id
1101: from ben_prtt_enrt_rslt_f per,
1102: ben_per_in_ler pinl
1103: where per.per_in_ler_id=pinl.per_in_ler_id and -- Bug 2595113
1104: per.person_id=p_person_id and
1105: per.business_group_id=p_business_group_id and
1106: per.sspndd_flag='N' and

Line 1124: ben_per_in_ler pil

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
1128: epe.prtt_enrt_rslt_id=per.prtt_enrt_rslt_id and

Line 1227: ben_per_in_ler pil

1223: select per.pl_id,
1224: per.pl_typ_id,
1225: per.prtt_enrt_rslt_id
1226: from ben_prtt_enrt_rslt_f per,
1227: ben_per_in_ler pil
1228: where pil.business_group_id = p_business_group_id and
1229: pil.person_id = p_person_id and
1230: pil.per_in_ler_id = p_per_in_ler_id and
1231: per.person_id = pil.person_id and

Line 1274: from ben_per_in_ler pil,

1270: --
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

Line 1311: from ben_per_in_ler pil,

1307: -- Option Restrictions at plan level.
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

Line 1353: from ben_per_in_ler pil,

1349: --
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

Line 1396: from ben_per_in_ler pil,

1392: --
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

Line 1435: from ben_per_in_ler pil,

1431: -- Removed the comments not to get the same suspended enrollment as interim
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

Line 1473: from ben_per_in_ler pil,

1469: -- we need to get the minimum option of the plan
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

Line 1508: from ben_per_in_ler pil,

1504: -- Get the Next Lower Option of the Plan
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

Line 1524: ben_per_in_ler pil1

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
1528: and pil1.per_in_ler_id = p_per_in_ler_id)) and epe.crntly_enrd_flag='Y' )

Line 1557: from ben_per_in_ler pil,

1553: --
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

Line 1573: ben_per_in_ler pil1

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
1577: and pil1.per_in_ler_id = p_per_in_ler_id)) and epe.crntly_enrd_flag='Y' )

Line 1606: from ben_per_in_ler pil,

1602: --
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

Line 1647: from ben_per_in_ler pil,

1643: --
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

Line 1791: ben_per_in_ler pil_new

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)
1795: and epe_new.comp_lvl_cd not in ( 'PLANFC' , 'PLANIMP')

Line 1809: ben_per_in_ler pil_new

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)
1813: and nvl(pen_current.oipl_id,-1) = nvl(epe_new.oipl_id,-1)

Line 1928: from ben_per_in_ler pil

1924: --Bug#5402317
1925: cursor c_get_lf_evt_ocrd_dt
1926: is
1927: select lf_evt_ocrd_dt
1928: from ben_per_in_ler pil
1929: where pil.per_in_ler_id = p_per_in_ler_id
1930: and pil.business_group_id = p_business_group_id;
1931: --Bug#5402317
1932: --

Line 1933: l_get_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type;

1929: where pil.per_in_ler_id = p_per_in_ler_id
1930: and pil.business_group_id = p_business_group_id;
1931: --Bug#5402317
1932: --
1933: l_get_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type;
1934: l_ctfn_rqd varchar2(30);
1935: l_cf_bnft c_cf_bnft%ROWTYPE;
1936:
1937: /*Added for Bug 7426609 */

Line 3040: ,ben_per_in_ler pil

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
3044: and p_effective_date between

Line 3222: ben_per_in_ler pil

3218: prv.per_in_ler_id,
3219: prv.prtt_enrt_rslt_id,
3220: pil.person_id
3221: from ben_prtt_rt_val prv,
3222: ben_per_in_ler pil
3223: where prv.per_in_ler_id = p_per_in_ler_id
3224: and prv.per_in_ler_id = pil.per_in_ler_id
3225: and prv.prtt_rt_val_stat_cd is null
3226: and prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id

Line 3768: ben_per_in_ler pil,

3764: epe.object_version_number
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

Line 3890: ben_per_in_ler pil

3886: ,ecd.cvg_strt_dt
3887: ,ecd.cvg_thru_dt
3888: ,ecd.object_version_number
3889: From ben_elig_cvrd_dpnt_f ecd,
3890: ben_per_in_ler pil
3891: Where ecd.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
3892: and ecd.cvg_strt_dt is not null
3893: and ecd.cvg_thru_dt = hr_api.g_eot
3894: and ecd.business_group_id = p_business_group_id

Line 3905: from ben_per_in_ler pil

3901: --
3902: cursor c_per_in_ler_info is
3903: select pil.lf_evt_ocrd_dt,
3904: pil.ler_id
3905: from ben_per_in_ler pil
3906: where pil.per_in_ler_id=l_per_in_ler_id and
3907: pil.business_group_id=p_business_group_id;
3908: --
3909: -- RCHASE added PLIP join for unsspnd enrt cd setup at plip level