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_PRTT_ENRT_RSLT_F

Line 637: from ben_prtt_enrt_rslt_f pen

633: --
634: cursor c_pen(v_prtt_enrt_rslt_id number,
635: v_per_in_ler_id number ) is
636: select pen.*
637: from ben_prtt_enrt_rslt_f pen
638: where pen.prtt_enrt_rslt_id = v_prtt_enrt_rslt_id
639: and pen.per_in_ler_id = v_per_in_ler_id
640: and pen.prtt_enrt_rslt_stat_cd IS NULL
641: and pen.effective_end_date = hr_api.g_eot ;

Line 1007: From ben_plip_f plip, ben_prtt_enrt_rslt_f pen

1003: select 2 order_no
1004: ,plip.DFLT_TO_ASN_PNDG_CTFN_CD
1005: ,plip.DFLT_TO_ASN_PNDG_CTFN_RL
1006: ,plip.BNFT_OR_OPTION_RSTRCTN_CD
1007: From ben_plip_f plip, ben_prtt_enrt_rslt_f pen
1008: Where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
1009: and pen.pgm_id = plip.pgm_id
1010: and pen.pl_id = plip.pl_id
1011: and pen.prtt_enrt_rslt_stat_cd is null

Line 1069: from ben_prtt_enrt_rslt_f per,

1065: per.pl_typ_id,
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

Line 1101: from ben_prtt_enrt_rslt_f per,

1097: per.pl_typ_id,
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

Line 1226: from ben_prtt_enrt_rslt_f per,

1222: cursor c_current_enrt(v_pl_id number, v_oipl_id number ) is
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

Line 1242: ( exists (select 'x' from ben_prtt_enrt_rslt_f pen3

1238: ( p_per_in_ler_id = per.per_in_ler_id and
1239: ( /* Case 4 */
1240: per.enrt_cvg_thru_dt <> hr_api.g_eot or
1241: ( /* Case 1,2*/
1242: ( exists (select 'x' from ben_prtt_enrt_rslt_f pen3
1243: where pen3.prtt_enrt_rslt_id = per.prtt_enrt_rslt_id and
1244: pen3.prtt_enrt_rslt_stat_cd is null and
1245: pen3.sspndd_flag = 'N' and
1246: pen3.effective_end_date < per.effective_start_date and

Line 1807: from ben_prtt_enrt_rslt_f pen_current,

1803: --ie the enrollment result from the previous life event.
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

Line 1839: from ben_prtt_enrt_rslt_f susp,

1835: c_per_in_ler_id number,
1836: c_elig_per_elctbl_chc_id number) is
1837: select currently_susp.prtt_enrt_rslt_id,
1838: currently_susp.rplcs_sspndd_rslt_id
1839: from ben_prtt_enrt_rslt_f susp,
1840: ben_prtt_enrt_rslt_f currently_susp
1841: where susp.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
1842: and susp.per_in_ler_id = c_per_in_ler_id
1843: -- and susp.sspndd_flag = 'N' --This can be changed once elinf is fixed

Line 1840: ben_prtt_enrt_rslt_f currently_susp

1836: c_elig_per_elctbl_chc_id number) is
1837: select currently_susp.prtt_enrt_rslt_id,
1838: currently_susp.rplcs_sspndd_rslt_id
1839: from ben_prtt_enrt_rslt_f susp,
1840: ben_prtt_enrt_rslt_f currently_susp
1841: where susp.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
1842: and susp.per_in_ler_id = c_per_in_ler_id
1843: -- and susp.sspndd_flag = 'N' --This can be changed once elinf is fixed
1844: and susp.effective_end_date = hr_api.g_eot

Line 1857: from ben_prtt_enrt_rslt_f susp,

1853: c_per_in_ler_id number,
1854: c_elig_per_elctbl_chc_id number) is
1855: select currently_susp.prtt_enrt_rslt_id,
1856: currently_susp.rplcs_sspndd_rslt_id
1857: from ben_prtt_enrt_rslt_f susp,
1858: ben_prtt_enrt_rslt_f currently_susp
1859: where susp.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
1860: and susp.per_in_ler_id = c_per_in_ler_id
1861: -- and susp.sspndd_flag = 'N' --This can be changed once elinf is fixed

Line 1858: ben_prtt_enrt_rslt_f currently_susp

1854: c_elig_per_elctbl_chc_id number) is
1855: select currently_susp.prtt_enrt_rslt_id,
1856: currently_susp.rplcs_sspndd_rslt_id
1857: from ben_prtt_enrt_rslt_f susp,
1858: ben_prtt_enrt_rslt_f currently_susp
1859: where susp.prtt_enrt_rslt_id = c_prtt_enrt_rslt_id
1860: and susp.per_in_ler_id = c_per_in_ler_id
1861: -- and susp.sspndd_flag = 'N' --This can be changed once elinf is fixed
1862: and susp.effective_end_date = hr_api.g_eot

Line 1883: from ben_prtt_enrt_rslt_f interim,

1879: c_per_in_ler_id number) is
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

Line 2658: ben_prtt_enrt_rslt_f pen

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
2662: and pen.business_group_id(+)=p_business_group_id

Line 2881: From ben_prtt_enrt_rslt_f pen

2877: ,effective_end_date
2878: ,enrt_cvg_strt_dt
2879: ,enrt_cvg_thru_dt
2880: ,object_version_number
2881: From ben_prtt_enrt_rslt_f pen
2882: Where pen.business_group_id = p_business_group_id
2883: And pen.person_id = p_person_id
2884: And nvl(pen.pgm_id,-1) = nvl(p_pgm_id,-1)
2885: And pen.pl_id = p_pl_id

Line 3038: From ben_prtt_enrt_rslt_f pen

3034: ,pen.bnft_amt
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

Line 3072: From ben_prtt_enrt_rslt_f pen

3068: and enb.ordr_num = p_bnft_ordr_num ;
3069:
3070: Cursor c_new_ovn is
3071: select pen.object_version_number
3072: From ben_prtt_enrt_rslt_f pen
3073: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3074: and pen.business_group_id= p_business_group_id
3075: and pen.prtt_enrt_rslt_stat_cd is null
3076: and p_effective_date between

Line 3136: ben_prtt_enrt_rslt_f pen

3132: --START OHSU
3133: ,pea.effective_start_date pea_effective_date
3134: --END OHSU
3135: from ben_prtt_enrt_actn_f pea,
3136: ben_prtt_enrt_rslt_f pen
3137: where
3138: pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3139: --START OHSU
3140: and p_effective_date between pen.effective_start_date and

Line 3150: from ben_prtt_enrt_rslt_f pen

3146: --
3147: cursor c_interim (p_prtt_enrt_rslt_id number,
3148: p_per_in_ler_id number) is
3149: select pen.RPLCS_SSPNDD_RSLT_ID
3150: from ben_prtt_enrt_rslt_f pen
3151: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3152: and pen.sspndd_flag = 'Y'
3153: and pen.per_in_ler_id = p_per_in_ler_id
3154: and pen.prtt_enrt_rslt_stat_cd is null

Line 3157: from ben_prtt_enrt_rslt_f pen3

3153: and pen.per_in_ler_id = p_per_in_ler_id
3154: and pen.prtt_enrt_rslt_stat_cd is null
3155: and not exists
3156: (select null
3157: from ben_prtt_enrt_rslt_f pen3
3158: where pen3.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
3159: and pen3.prtt_enrt_rslt_stat_cd is null
3160: and pen3.effective_start_date < pen.effective_start_date
3161: and pen3.per_in_ler_id <> pen.per_in_ler_id)

Line 3162: and exists (select null from ben_prtt_enrt_rslt_f pen2

3158: where pen3.prtt_enrt_rslt_id = pen.prtt_enrt_rslt_id
3159: and pen3.prtt_enrt_rslt_stat_cd is null
3160: and pen3.effective_start_date < pen.effective_start_date
3161: and pen3.per_in_ler_id <> pen.per_in_ler_id)
3162: and exists (select null from ben_prtt_enrt_rslt_f pen2
3163: where pen2.prtt_enrt_rslt_id = pen.RPLCS_SSPNDD_RSLT_ID
3164: and pen2.prtt_enrt_rslt_stat_cd is null
3165: and pen2.per_in_ler_id = p_per_in_ler_id
3166: and pen2.enrt_cvg_thru_dt <> hr_api.g_eot

Line 3173: from ben_prtt_enrt_rslt_f pen

3169: cursor c_enrt_rslt (p_prtt_enrt_rslt_id number) is
3170: select pen.effective_start_date,
3171: pen.effective_end_date,
3172: pen.object_version_number
3173: from ben_prtt_enrt_rslt_f pen
3174: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3175: and pen.prtt_enrt_rslt_stat_cd is null
3176: and pen.effective_end_date = (select pen2.effective_start_date - 1
3177: from ben_prtt_enrt_rslt_f pen2

Line 3177: from ben_prtt_enrt_rslt_f pen2

3173: from ben_prtt_enrt_rslt_f pen
3174: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3175: and pen.prtt_enrt_rslt_stat_cd is null
3176: and pen.effective_end_date = (select pen2.effective_start_date - 1
3177: from ben_prtt_enrt_rslt_f pen2
3178: where pen2.enrt_cvg_thru_dt <> hr_api.g_eot
3179: and pen2.effective_end_date = hr_api.g_eot
3180: and pen2.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3181: and pen2.prtt_enrt_rslt_stat_cd is null);

Line 3286: l_last_place := 'Fetching record from ben_prtt_enrt_rslt_f';

3282: ,p_argument => 'p_datetrack_mode'
3283: ,p_argument_value => p_datetrack_mode);
3284: --
3285: -- ** Open result cursor.
3286: l_last_place := 'Fetching record from ben_prtt_enrt_rslt_f';
3287: Open Csr_prtt_enrt_rslt;
3288: Fetch Csr_prtt_enrt_rslt Into l_pen;
3289: If Csr_prtt_enrt_rslt%NOTFOUND Then
3290: Close Csr_prtt_enrt_rslt;

Line 3732: From ben_prtt_enrt_rslt_f pen

3728: ,pln.ENRT_PL_OPT_FLAG
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

Line 3766: from ben_prtt_enrt_rslt_f pen,

3762: --START Bug 2958032
3763: epe.prtt_enrt_rslt_id,
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

Line 3959: from ben_prtt_enrt_rslt_f pen,

3955: p_elig_per_elctbl_chc_id number,
3956: p_effective_date date) is
3957: select enb.enrt_bnft_id,
3958: enb.object_version_number
3959: from ben_prtt_enrt_rslt_f pen,
3960: ben_enrt_bnft enb
3961: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3962: and p_effective_date between pen.effective_start_date and pen.effective_end_date
3963: and pen.bnft_ordr_num = enb.ordr_num

Line 3971: from ben_prtt_enrt_rslt_f pen

3967: --
3968: -- bug#3202455 - determine whether unsuspend is on account of some user error
3969: cursor c_previous_status is
3970: select null
3971: from ben_prtt_enrt_rslt_f pen
3972: where pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
3973: and pen.sspndd_flag = 'N'
3974: and pen.per_in_ler_id <> l_per_in_ler_id
3975: and pen.prtt_enrt_rslt_stat_cd is null;

Line 3981: FROM ben_pil_elctbl_chc_popl popl, ben_prtt_enrt_rslt_f pen

3977: -- 6054988 : Check if any elections have been made in the current pil.
3978: --
3979: cursor chk_elcn_dt_in_pel is
3980: SELECT 'x'
3981: FROM ben_pil_elctbl_chc_popl popl, ben_prtt_enrt_rslt_f pen
3982: WHERE popl.per_in_ler_id = l_per_in_ler_id
3983: AND popl.elcns_made_dt IS NULL
3984: AND popl.dflt_asnd_dt IS NULL
3985: AND popl.pgm_id = pen.pgm_id

Line 4031: l_last_place := 'Fetching record from ben_prtt_enrt_rslt_f';

4027: hr_api.mandatory_arg_error(p_api_name => l_proc,
4028: p_argument => 'p_datetrack_mode',
4029: p_argument_value => p_datetrack_mode);
4030: --
4031: l_last_place := 'Fetching record from ben_prtt_enrt_rslt_f';
4032: --
4033: -- Get the needed result info
4034: --
4035: Open Csr_prtt_enrt_rslt(p_prtt_enrt_rslt_id);