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 541: from ben_elig_per_elctbl_chc epe, ben_per_in_ler pil

537: l_interim_bnft_amt NUMBER := p_interim_bnft_amt;
538: --
539: cursor c_epe(v_elig_per_elctbl_chc_id number) is
540: select epe.*
541: from ben_elig_per_elctbl_chc epe, ben_per_in_ler pil
542: where epe.elig_per_elctbl_chc_id = v_elig_per_elctbl_chc_id
543: and epe.per_in_ler_id = pil.per_in_ler_id(+) /* Bug 5225780 */
544: and (pil.per_in_ler_stat_cd not in ('VOIDD','BCKDT') or
545: pil.per_in_ler_stat_cd is null);

Line 928: from ben_elig_per_elctbl_chc epe,ben_per_in_ler pil

924: epe.pl_id,
925: epe.pl_typ_id,
926: epe.oipl_id,
927: pil.ler_id
928: from ben_elig_per_elctbl_chc epe,ben_per_in_ler pil
929: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id
930: and pil.per_in_ler_id = epe.per_in_ler_id;
931:
932: l_epe c_epe%rowtype;

Line 1015: ben_per_in_ler pil

1011: -- RCHASE Bug#5353 added
1012: per.prtt_enrt_rslt_id
1013: from ben_prtt_enrt_rslt_f per,
1014: ben_elig_per_elctbl_chc epe,
1015: ben_per_in_ler pil
1016: where pil.business_group_id=p_business_group_id and
1017: pil.person_id=p_person_id and
1018: pil.per_in_ler_stat_cd='STRTD' and
1019: per.person_id=p_person_id and

Line 1046: ben_per_in_ler pinl

1042: to_number(null) elig_per_elctbl_chc_id,
1043: -- RCHASE Bug#5353
1044: per.prtt_enrt_rslt_id
1045: from ben_prtt_enrt_rslt_f per,
1046: ben_per_in_ler pinl
1047: where per.per_in_ler_id=pinl.per_in_ler_id and -- Bug 2595113
1048: per.person_id=p_person_id and
1049: per.business_group_id=p_business_group_id and
1050: per.sspndd_flag='N' and

Line 1068: ben_per_in_ler pil

1064: nvl(per.oipl_id,-1) = nvl(v_oipl_id,nvl(per.oipl_id,-1)) and
1065: not exists (
1066: select null
1067: from ben_elig_per_elctbl_chc epe,
1068: ben_per_in_ler pil
1069: where pil.business_group_id=p_business_group_id and
1070: pil.person_id=p_person_id and
1071: pil.per_in_ler_stat_cd='STRTD' and
1072: epe.prtt_enrt_rslt_id=per.prtt_enrt_rslt_id and

Line 1171: ben_per_in_ler pil

1167: select per.pl_id,
1168: per.pl_typ_id,
1169: per.prtt_enrt_rslt_id
1170: from ben_prtt_enrt_rslt_f per,
1171: ben_per_in_ler pil
1172: where pil.business_group_id = p_business_group_id and
1173: pil.person_id = p_person_id and
1174: pil.per_in_ler_id = p_per_in_ler_id and
1175: per.person_id = pil.person_id and

Line 1218: from ben_per_in_ler pil,

1214: --
1215: cursor c_default_epe is
1216: select epe.elig_per_elctbl_chc_id,
1217: enb.enrt_bnft_id
1218: from ben_per_in_ler pil,
1219: ben_elig_per_elctbl_chc epe,
1220: ben_pl_f pl,
1221: ben_enrt_bnft enb
1222: where

Line 1255: from ben_per_in_ler pil,

1251: -- Option Restrictions at plan level.
1252: cursor c_default_pl_epe is
1253: select epe.elig_per_elctbl_chc_id,
1254: enb.enrt_bnft_id
1255: from ben_per_in_ler pil,
1256: ben_elig_per_elctbl_chc epe,
1257: ben_pl_f pl,
1258: ben_enrt_bnft enb
1259: where

Line 1297: from ben_per_in_ler pil,

1293: --
1294: cursor c_default_bnft_epe is
1295: select epe.elig_per_elctbl_chc_id,
1296: enb.enrt_bnft_id
1297: from ben_per_in_ler pil,
1298: ben_elig_per_elctbl_chc epe,
1299: ben_pl_f pl,
1300: ben_enrt_bnft enb
1301: where

Line 1340: from ben_per_in_ler pil,

1336: --
1337: cursor c_default_bnft_pl_epe is
1338: select epe.elig_per_elctbl_chc_id,
1339: enb.enrt_bnft_id
1340: from ben_per_in_ler pil,
1341: ben_elig_per_elctbl_chc epe,
1342: ben_pl_f pl,
1343: ben_enrt_bnft enb
1344: where

Line 1379: from ben_per_in_ler pil,

1375: -- Removed the comments not to get the same suspended enrollment as interim
1376: --
1377: cursor c_min_oipl_epe is
1378: select epe.elig_per_elctbl_chc_id, eb.enrt_bnft_id
1379: from ben_per_in_ler pil,
1380: ben_elig_per_elctbl_chc epe,
1381: ben_pl_f pl,
1382: ben_enrt_bnft eb
1383: where

Line 1417: from ben_per_in_ler pil,

1413: -- we need to get the minimum option of the plan
1414: cursor c_min_pl_epe is
1415: select epe.elig_per_elctbl_chc_id,
1416: enb.enrt_bnft_id
1417: from ben_per_in_ler pil,
1418: ben_elig_per_elctbl_chc epe,
1419: ben_enrt_bnft enb,
1420: ben_pl_f pl
1421: where pil.business_group_id=p_business_group_id and

Line 1452: from ben_per_in_ler pil,

1448: -- Get the Next Lower Option of the Plan
1449: cursor c_next_lower_pl_epe is
1450: select epe.elig_per_elctbl_chc_id,
1451: eb.enrt_bnft_id
1452: from ben_per_in_ler pil,
1453: ben_elig_per_elctbl_chc epe,
1454: ben_pl_f pl,
1455: ben_enrt_bnft eb
1456: where

Line 1491: from ben_per_in_ler pil,

1487: --
1488: cursor c_next_lower_pl_typ_epe is
1489: select epe.elig_per_elctbl_chc_id,
1490: eb.enrt_bnft_id
1491: from ben_per_in_ler pil,
1492: ben_elig_per_elctbl_chc epe,
1493: ben_enrt_bnft eb,
1494: ben_pl_f pl
1495: where

Line 1530: from ben_per_in_ler pil,

1526: --
1527: cursor c_min_bnft_epe is
1528: select epe.elig_per_elctbl_chc_id,
1529: enb.enrt_bnft_id
1530: from ben_per_in_ler pil,
1531: ben_elig_per_elctbl_chc epe,
1532: ben_enrt_bnft enb,
1533: ben_pl_f pl
1534: where

Line 1571: from ben_per_in_ler pil,

1567: --
1568: cursor c_next_lower_bnft_pl_epe is
1569: select epe.elig_per_elctbl_chc_id,
1570: eb.enrt_bnft_id
1571: from ben_per_in_ler pil,
1572: ben_elig_per_elctbl_chc epe,
1573: ben_enrt_bnft eb,
1574: ben_pl_f pl
1575: where

Line 1715: ben_per_in_ler pil_new

1711: cursor c_current_same_epe(c_current_epe_id number) is
1712: select epe_new.elig_per_elctbl_chc_id
1713: from ben_elig_per_elctbl_chc epe_current,
1714: ben_elig_per_elctbl_chc epe_new,
1715: ben_per_in_ler pil_new
1716: where epe_current.elig_per_elctbl_chc_id = c_current_epe_id
1717: and epe_current.pl_id = epe_new.pl_id
1718: and nvl(epe_current.oipl_id,-1) = nvl(epe_new.oipl_id,-1)
1719: and epe_new.comp_lvl_cd not in ( 'PLANFC' , 'PLANIMP')

Line 1733: ben_per_in_ler pil_new

1729: cursor c_current_same_epe(c_current_pen_id number) is
1730: select epe_new.elig_per_elctbl_chc_id
1731: from ben_prtt_enrt_rslt_f pen_current,
1732: ben_elig_per_elctbl_chc epe_new,
1733: ben_per_in_ler pil_new
1734: where pen_current.prtt_enrt_rslt_id = c_current_pen_id
1735: and pen_current.pl_id = epe_new.pl_id
1736: and nvl(pen_current.pgm_id,-1) = nvl(epe_new.pgm_id,-1)
1737: and nvl(pen_current.oipl_id,-1) = nvl(epe_new.oipl_id,-1)

Line 1850: from ben_per_in_ler pil

1846: --Bug#5402317
1847: cursor c_get_lf_evt_ocrd_dt
1848: is
1849: select lf_evt_ocrd_dt
1850: from ben_per_in_ler pil
1851: where pil.per_in_ler_id = p_per_in_ler_id
1852: and pil.business_group_id = p_business_group_id;
1853: --Bug#5402317
1854: --

Line 1855: l_get_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type;

1851: where pil.per_in_ler_id = p_per_in_ler_id
1852: and pil.business_group_id = p_business_group_id;
1853: --Bug#5402317
1854: --
1855: l_get_lf_evt_ocrd_dt ben_per_in_ler.lf_evt_ocrd_dt%type;
1856: l_ctfn_rqd varchar2(30);
1857: l_cf_bnft c_cf_bnft%ROWTYPE;
1858: --
1859: Begin

Line 2894: ,ben_per_in_ler pil

2890: ,pen.bnft_ordr_num /*ENH*/
2891: ,epe.dpnt_dsgn_cd
2892: From ben_prtt_enrt_rslt_f pen
2893: ,ben_elig_per_elctbl_chc epe
2894: ,ben_per_in_ler pil
2895: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2896: and pen.business_group_id= p_business_group_id
2897: and pen.prtt_enrt_rslt_stat_cd is null
2898: and p_effective_date between

Line 3076: ben_per_in_ler pil

3072: prv.per_in_ler_id,
3073: prv.prtt_enrt_rslt_id,
3074: pil.person_id
3075: from ben_prtt_rt_val prv,
3076: ben_per_in_ler pil
3077: where prv.per_in_ler_id = p_per_in_ler_id
3078: and prv.per_in_ler_id = pil.per_in_ler_id
3079: and prv.prtt_rt_val_stat_cd is null
3080: and prv.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id

Line 3622: ben_per_in_ler pil,

3618: epe.object_version_number
3619: --END Bug 2958032
3620: from ben_prtt_enrt_rslt_f pen,
3621: ben_pil_elctbl_chc_popl pel,
3622: ben_per_in_ler pil,
3623: ben_elig_per_elctbl_chc epe
3624: where pen.prtt_enrt_rslt_id=c_prtt_enrt_rslt_id
3625: and p_effective_date between
3626: pen.effective_start_date and pen.effective_end_date

Line 3721: ben_per_in_ler pil

3717: ,ecd.cvg_strt_dt
3718: ,ecd.cvg_thru_dt
3719: ,ecd.object_version_number
3720: From ben_elig_cvrd_dpnt_f ecd,
3721: ben_per_in_ler pil
3722: Where ecd.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
3723: and ecd.cvg_strt_dt is not null
3724: and ecd.cvg_thru_dt = hr_api.g_eot
3725: and ecd.business_group_id = p_business_group_id

Line 3736: from ben_per_in_ler pil

3732: --
3733: cursor c_per_in_ler_info is
3734: select pil.lf_evt_ocrd_dt,
3735: pil.ler_id
3736: from ben_per_in_ler pil
3737: where pil.per_in_ler_id=l_per_in_ler_id and
3738: pil.business_group_id=p_business_group_id;
3739: --
3740: -- RCHASE added PLIP join for unsspnd enrt cd setup at plip level