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 884: l_DFLT_TO_ASN_PNDG_CTFN_CD ben_pl_f.DFLT_TO_ASN_PNDG_CTFN_CD%type := NULL ;

880: l_proc varchar2(80) := g_package ||
881: '.Determine_interim';
882: l_last_place varchar2(132);
883: l_interim_enrt_bnft_id number;
884: l_DFLT_TO_ASN_PNDG_CTFN_CD ben_pl_f.DFLT_TO_ASN_PNDG_CTFN_CD%type := NULL ;
885: l_DFLT_TO_ASN_PNDG_CTFN_RL ben_pl_f.DFLT_TO_ASN_PNDG_CTFN_RL%type := NULL ;
886: l_bnft_or_option_rstrctn_cd ben_pl_f.BNFT_OR_OPTION_RSTRCTN_CD%type := NULL;
887: l_assignment_id per_all_assignments_f.assignment_id%type;
888:

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

881: '.Determine_interim';
882: l_last_place varchar2(132);
883: l_interim_enrt_bnft_id number;
884: l_DFLT_TO_ASN_PNDG_CTFN_CD ben_pl_f.DFLT_TO_ASN_PNDG_CTFN_CD%type := NULL ;
885: l_DFLT_TO_ASN_PNDG_CTFN_RL ben_pl_f.DFLT_TO_ASN_PNDG_CTFN_RL%type := NULL ;
886: l_bnft_or_option_rstrctn_cd ben_pl_f.BNFT_OR_OPTION_RSTRCTN_CD%type := NULL;
887: l_assignment_id per_all_assignments_f.assignment_id%type;
888:
889: /********************* l_organization_id added by shdas **********/

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

882: l_last_place varchar2(132);
883: l_interim_enrt_bnft_id number;
884: l_DFLT_TO_ASN_PNDG_CTFN_CD ben_pl_f.DFLT_TO_ASN_PNDG_CTFN_CD%type := NULL ;
885: l_DFLT_TO_ASN_PNDG_CTFN_RL ben_pl_f.DFLT_TO_ASN_PNDG_CTFN_RL%type := NULL ;
886: l_bnft_or_option_rstrctn_cd ben_pl_f.BNFT_OR_OPTION_RSTRCTN_CD%type := NULL;
887: l_assignment_id per_all_assignments_f.assignment_id%type;
888:
889: /********************* l_organization_id added by shdas **********/
890:

Line 967: From ben_pl_f

963: select 3 order_no
964: ,DFLT_TO_ASN_PNDG_CTFN_CD
965: ,DFLT_TO_ASN_PNDG_CTFN_RL
966: ,BNFT_OR_OPTION_RSTRCTN_CD
967: From ben_pl_f
968: Where pl_id = p_pl_id
969: and l_get_lf_evt_ocrd_dt between --Bug#5402317
970: effective_start_date and effective_end_date
971: and business_group_id=p_business_group_id

Line 1220: ben_pl_f pl,

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
1223: pil.business_group_id=p_business_group_id and
1224: pil.person_id=p_person_id and

Line 1257: ben_pl_f pl,

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
1260: pil.business_group_id=p_business_group_id and
1261: pil.person_id=p_person_id and

Line 1299: ben_pl_f pl,

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
1302: pil.business_group_id=p_business_group_id and
1303: pil.person_id=p_person_id and

Line 1342: ben_pl_f pl,

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
1345: pil.business_group_id=p_business_group_id and
1346: pil.person_id=p_person_id and

Line 1381: ben_pl_f pl,

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
1384: pil.business_group_id=p_business_group_id and
1385: pil.person_id=p_person_id and

Line 1420: ben_pl_f pl

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
1422: pil.person_id=p_person_id and
1423: --pil.per_in_ler_stat_cd='STRTD' and
1424: pil.per_in_ler_id = p_per_in_ler_id and

Line 1454: ben_pl_f pl,

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
1457: pil.business_group_id=p_business_group_id and
1458: pil.person_id=p_person_id and

Line 1494: ben_pl_f pl

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
1496: pil.business_group_id=p_business_group_id and
1497: pil.person_id=p_person_id and
1498: --pil.per_in_ler_stat_cd='STRTD' and

Line 1533: ben_pl_f pl

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
1535: pil.business_group_id=p_business_group_id and
1536: pil.person_id=p_person_id and
1537: --pil.per_in_ler_stat_cd='STRTD' and

Line 1574: ben_pl_f pl

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
1576: pil.business_group_id=p_business_group_id and
1577: pil.person_id=p_person_id and
1578: --pil.per_in_ler_stat_cd='STRTD' and

Line 1640: ben_pl_f pl,

1636: select enb1.val bnft_amt,
1637: enb1.enrt_bnft_id
1638: from ben_enrt_bnft enb1,
1639: ben_enrt_bnft enb2,
1640: ben_pl_f pl,
1641: ben_elig_per_elctbl_chc epe --Bug 3042379 Dont select 'R' cases
1642: --to make it consistent with other
1643: --interim cursors.
1644: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id

Line 1670: ben_pl_f pl,

1666: select enb1.val bnft_amt,
1667: enb1.enrt_bnft_id
1668: from ben_enrt_bnft enb1,
1669: ben_enrt_bnft enb2,
1670: ben_pl_f pl,
1671: ben_elig_per_elctbl_chc epe --Bug 3042379 Dont select 'R' cases
1672: --to make it consistent with other
1673: --interim cursors.
1674: where epe.elig_per_elctbl_chc_id = p_elig_per_elctbl_chc_id

Line 2971: select 'x' from ben_pl_f pl

2967: and prv.rt_strt_dt between
2968: pee.effective_start_date and pee.effective_end_date
2969: ;
2970: cursor c_pl(p_pl_id number) is
2971: select 'x' from ben_pl_f pl
2972: where pl.pl_id = p_pl_id
2973: and pl.SUBJ_TO_IMPTD_INCM_TYP_CD is not null
2974: and p_effective_date between
2975: pl.effective_start_date and pl.effective_end_date;

Line 3104: l_bnft_or_option_rstrctn_cd ben_pl_f.bnft_or_option_rstrctn_cd%type;

3100: l_current_enrt_bnft_id number;
3101: l_interim_bnft_amt number;
3102: l_pea_effective_start_date date;
3103: l_pea_effective_end_date date;
3104: l_bnft_or_option_rstrctn_cd ben_pl_f.bnft_or_option_rstrctn_cd%type;
3105: -- for nocopy changes
3106: l_object_version_number number := p_object_version_number ;
3107: l_enrt_rslt c_enrt_rslt%rowtype;
3108: l_prv c_prv%rowtype;

Line 3587: ,ben_pl_f pln

3583: ,pen.business_group_id
3584: ,'USEEFD' calc_cvg_strt_dt_cd
3585: ,'USE1BSEFD' calc_cvg_end_dt_cd
3586: From ben_prtt_enrt_rslt_f pen
3587: ,ben_pl_f pln
3588: Where pen.prtt_enrt_rslt_id = c_rslt_id
3589: And pen.business_group_id = p_business_group_id
3590: and pen.prtt_enrt_rslt_stat_cd is null
3591: And p_effective_date between

Line 3601: select 'x' from ben_pl_f pl

3597: pln.effective_start_date and
3598: pln.effective_end_date
3599: ;
3600: cursor c_pl(p_pl_id number) is
3601: select 'x' from ben_pl_f pl
3602: where pl.pl_id = p_pl_id
3603: and pl.SUBJ_TO_IMPTD_INCM_TYP_CD is not null
3604: and p_effective_date between
3605: pl.effective_start_date and pl.effective_end_date;

Line 3745: ben_pl_f pl,

3741: cursor c_unsspnd_enrt_cd is
3742: select nvl(lbr.unsspnd_enrt_cd,
3743: nvl(pl.unsspnd_enrt_cd, plip.unsspnd_enrt_cd))
3744: from ben_ler_bnft_rstrn_f lbr,
3745: ben_pl_f pl,
3746: ben_plip_f plip
3747: where
3748: pl.pl_id=l_pen.pl_id
3749: and plip.pl_id(+)=pl.pl_id