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_PL_F

Line 939: l_DFLT_TO_ASN_PNDG_CTFN_CD ben_pl_f.DFLT_TO_ASN_PNDG_CTFN_CD%type := NULL ;

935: l_proc varchar2(80) := g_package ||
936: '.Determine_interim';
937: l_last_place varchar2(132);
938: l_interim_enrt_bnft_id number;
939: l_DFLT_TO_ASN_PNDG_CTFN_CD ben_pl_f.DFLT_TO_ASN_PNDG_CTFN_CD%type := NULL ;
940: l_DFLT_TO_ASN_PNDG_CTFN_RL ben_pl_f.DFLT_TO_ASN_PNDG_CTFN_RL%type := NULL ;
941: l_bnft_or_option_rstrctn_cd ben_pl_f.BNFT_OR_OPTION_RSTRCTN_CD%type := NULL;
942: l_assignment_id per_all_assignments_f.assignment_id%type;
943:

Line 940: l_DFLT_TO_ASN_PNDG_CTFN_RL ben_pl_f.DFLT_TO_ASN_PNDG_CTFN_RL%type := NULL ;

936: '.Determine_interim';
937: l_last_place varchar2(132);
938: l_interim_enrt_bnft_id number;
939: l_DFLT_TO_ASN_PNDG_CTFN_CD ben_pl_f.DFLT_TO_ASN_PNDG_CTFN_CD%type := NULL ;
940: l_DFLT_TO_ASN_PNDG_CTFN_RL ben_pl_f.DFLT_TO_ASN_PNDG_CTFN_RL%type := NULL ;
941: l_bnft_or_option_rstrctn_cd ben_pl_f.BNFT_OR_OPTION_RSTRCTN_CD%type := NULL;
942: l_assignment_id per_all_assignments_f.assignment_id%type;
943:
944: /********************* l_organization_id added by shdas **********/

Line 941: l_bnft_or_option_rstrctn_cd ben_pl_f.BNFT_OR_OPTION_RSTRCTN_CD%type := NULL;

937: l_last_place varchar2(132);
938: l_interim_enrt_bnft_id number;
939: l_DFLT_TO_ASN_PNDG_CTFN_CD ben_pl_f.DFLT_TO_ASN_PNDG_CTFN_CD%type := NULL ;
940: l_DFLT_TO_ASN_PNDG_CTFN_RL ben_pl_f.DFLT_TO_ASN_PNDG_CTFN_RL%type := NULL ;
941: l_bnft_or_option_rstrctn_cd ben_pl_f.BNFT_OR_OPTION_RSTRCTN_CD%type := NULL;
942: l_assignment_id per_all_assignments_f.assignment_id%type;
943:
944: /********************* l_organization_id added by shdas **********/
945:

Line 1023: From ben_pl_f

1019: select 3 order_no
1020: ,DFLT_TO_ASN_PNDG_CTFN_CD
1021: ,DFLT_TO_ASN_PNDG_CTFN_RL
1022: ,BNFT_OR_OPTION_RSTRCTN_CD
1023: From ben_pl_f
1024: Where pl_id = p_pl_id
1025: and l_get_lf_evt_ocrd_dt between --Bug#5402317
1026: effective_start_date and effective_end_date
1027: and business_group_id=p_business_group_id

Line 1276: ben_pl_f pl,

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
1280: pil.person_id=p_person_id and

Line 1313: ben_pl_f pl,

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
1317: pil.person_id=p_person_id and

Line 1355: ben_pl_f pl,

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
1359: pil.person_id=p_person_id and

Line 1398: ben_pl_f pl,

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
1402: pil.person_id=p_person_id and

Line 1437: ben_pl_f pl,

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
1441: pil.person_id=p_person_id and

Line 1476: ben_pl_f pl

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
1479: --pil.per_in_ler_stat_cd='STRTD' and
1480: pil.per_in_ler_id = p_per_in_ler_id and

Line 1510: ben_pl_f pl,

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
1514: pil.person_id=p_person_id and

Line 1560: ben_pl_f pl

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
1563: pil.person_id=p_person_id and
1564: --pil.per_in_ler_stat_cd='STRTD' and

Line 1609: ben_pl_f pl

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
1612: pil.person_id=p_person_id and
1613: --pil.per_in_ler_stat_cd='STRTD' and

Line 1650: ben_pl_f pl

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
1653: pil.person_id=p_person_id and
1654: --pil.per_in_ler_stat_cd='STRTD' and

Line 1716: ben_pl_f pl,

1712: select enb1.val bnft_amt,
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

Line 1746: ben_pl_f pl,

1742: select enb1.val bnft_amt,
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

Line 3117: select 'x' from ben_pl_f pl

3113: and prv.rt_strt_dt between
3114: pee.effective_start_date and pee.effective_end_date
3115: ;
3116: cursor c_pl(p_pl_id number) is
3117: select 'x' from ben_pl_f pl
3118: where pl.pl_id = p_pl_id
3119: and pl.SUBJ_TO_IMPTD_INCM_TYP_CD is not null
3120: and p_effective_date between
3121: pl.effective_start_date and pl.effective_end_date;

Line 3250: l_bnft_or_option_rstrctn_cd ben_pl_f.bnft_or_option_rstrctn_cd%type;

3246: l_current_enrt_bnft_id number;
3247: l_interim_bnft_amt number;
3248: l_pea_effective_start_date date;
3249: l_pea_effective_end_date date;
3250: l_bnft_or_option_rstrctn_cd ben_pl_f.bnft_or_option_rstrctn_cd%type;
3251: -- for nocopy changes
3252: l_object_version_number number := p_object_version_number ;
3253: l_enrt_rslt c_enrt_rslt%rowtype;
3254: l_prv c_prv%rowtype;

Line 3733: ,ben_pl_f pln

3729: ,pen.business_group_id
3730: ,'USEEFD' calc_cvg_strt_dt_cd
3731: ,'USE1BSEFD' calc_cvg_end_dt_cd
3732: From ben_prtt_enrt_rslt_f pen
3733: ,ben_pl_f pln
3734: Where pen.prtt_enrt_rslt_id = c_rslt_id
3735: And pen.business_group_id = p_business_group_id
3736: and pen.prtt_enrt_rslt_stat_cd is null
3737: And p_effective_date between

Line 3747: select 'x' from ben_pl_f pl

3743: pln.effective_start_date and
3744: pln.effective_end_date
3745: ;
3746: cursor c_pl(p_pl_id number) is
3747: select 'x' from ben_pl_f pl
3748: where pl.pl_id = p_pl_id
3749: and pl.SUBJ_TO_IMPTD_INCM_TYP_CD is not null
3750: and p_effective_date between
3751: pl.effective_start_date and pl.effective_end_date;

Line 3914: ben_pl_f pl,

3910: cursor c_unsspnd_enrt_cd is
3911: select nvl(lbr.unsspnd_enrt_cd,
3912: nvl(pl.unsspnd_enrt_cd, plip.unsspnd_enrt_cd))
3913: from ben_ler_bnft_rstrn_f lbr,
3914: ben_pl_f pl,
3915: ben_plip_f plip
3916: where
3917: pl.pl_id=l_pen.pl_id
3918: and plip.pl_id(+)=pl.pl_id