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_REOPEN_ENDED_RESULTS dependencies on BEN_PRTT_ENRT_RSLT_F

Line 197: from ben_prtt_enrt_rslt_f pen,

193: --
194: cursor c_ended_result (p_per_in_ler_id number,
195: p_business_group_id number) is
196: select pen.*
197: from ben_prtt_enrt_rslt_f pen,
198: ben_elig_per_elctbl_chc epe
199: where pen.prtt_enrt_rslt_stat_cd is null
200: and pen.effective_end_date = hr_api.g_eot
201: and pen.enrt_cvg_thru_dt <> hr_api.g_eot

Line 210: from ben_prtt_enrt_rslt_f susp

206: -- and epe.ELCTBL_FLAG = 'Y'
207: and epe.BUSINESS_GROUP_ID = p_business_group_id
208: --Bug 5102337. we need to exclude interim enrollments being selected here.
209: and not exists ( select 'x'
210: from ben_prtt_enrt_rslt_f susp
211: where susp.RPLCS_SSPNDD_RSLT_ID = pen.prtt_enrt_rslt_id
212: and susp.effective_end_date <> hr_api.g_eot
213: and susp.prtt_enrt_rslt_stat_cd is null
214: and susp.enrt_cvg_thru_dt = hr_api.g_eot ) ;

Line 225: from ben_prtt_enrt_rslt_f pen,

221: p_pl_typ_id in number,
222: p_business_group_id in number) is
223:
224: select pen.*
225: from ben_prtt_enrt_rslt_f pen,
226: ben_per_in_ler pil
227: where pen.person_id = p_person_id
228: and pen.effective_end_date = hr_api.g_eot
229: and pen.business_group_id = p_business_group_id

Line 257: from ben_prtt_enrt_rslt_f pen

253: select prv.*
254: from ben_prtt_rt_val prv
255: where prv.prtt_enrt_rslt_id in
256: (select pen.prtt_enrt_rslt_id
257: from ben_prtt_enrt_rslt_f pen
258: where pen.effective_end_date = hr_api.g_eot
259: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
260: and pen.person_id = p_person_id
261: and pen.pgm_id <> p_pgm_id

Line 277: from ben_prtt_enrt_rslt_f pen

273: p_person_id number,
274: p_business_group_id number,
275: p_pgm_id number) is
276: select pen.*
277: from ben_prtt_enrt_rslt_f pen
278: where pen.effective_end_date = hr_api.g_eot
279: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
280: and pen.person_id = p_person_id
281: and pen.pgm_id <> p_pgm_id

Line 295: from ben_prtt_enrt_rslt_f pen

291: --
292: cursor c_pen (p_prtt_enrt_rslt_id number) is
293: select pen.effective_start_date,
294: pen.object_version_number
295: from ben_prtt_enrt_rslt_f pen
296: where pen.effective_end_date = hr_api.g_eot
297: and pen.prtt_enrt_rslt_stat_cd is null
298: and pen.business_group_id = p_business_group_id
299: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id;

Line 316: from ben_prtt_enrt_rslt_f

312: p_prtt_enrt_rslt_id number) is
313: select elig_per_elctbl_chc_id
314: from ben_elig_per_elctbl_chc epe
315: where epe.per_in_ler_id in (select per_in_ler_id
316: from ben_prtt_enrt_rslt_f
317: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id)
318: and epe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id;
319: --
320: cursor c_get_prior_per_in_ler is

Line 336: from ben_prtt_enrt_rslt_f pen

332: select prv.*
333: ,abr.element_type_id
334: ,abr.input_value_id
335: ,pen.person_id
336: from ben_prtt_enrt_rslt_f pen
337: ,ben_prtt_rt_val prv
338: ,ben_acty_base_rt_f abr
339: where pen.effective_end_date = hr_api.g_eot
340: and pen.enrt_cvg_thru_dt <> hr_api.g_eot

Line 358: from ben_prtt_enrt_rslt_f pen

354: cursor c_get_enrt_rslts_for_pen(p_cvg_end_dt date
355: ,p_ptip_id number
356: ) is
357: select pen.*
358: from ben_prtt_enrt_rslt_f pen
359: ,ben_ptip_f ptip
360: where pen.effective_end_date = hr_api.g_eot -- '31-dec-4712'
361: and pen.enrt_cvg_thru_dt <> hr_api.g_eot -- '31-dec-4712'
362: and pen.prtt_enrt_rslt_stat_cd is null

Line 436: where BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_RSLT_F_ADJ'

432: cursor c_prtt_enrt_rslt_adj (p_per_in_ler_id number,
433: p_prtt_enrt_rslt_id number) is
434: select null
435: from ben_le_clsn_n_rstr
436: where BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_RSLT_F_ADJ'
437: AND BKUP_TBL_ID = p_prtt_enrt_rslt_id
438: AND PER_IN_LER_ID = p_per_in_ler_id;
439: --
440: -- End bug 7206471

Line 573: 'BEN_PRTT_ENRT_RSLT_F_DEL',

569: PLIP_ORDR_NUM,
570: PTIP_ORDR_NUM,
571: OIPL_ORDR_NUM)
572: values (
573: 'BEN_PRTT_ENRT_RSLT_F_DEL',
574: l_ended_result.COMP_LVL_CD,
575: l_ended_result.PEN_ATTRIBUTE16,
576: l_ended_result.PEN_ATTRIBUTE17,
577: l_ended_result.PEN_ATTRIBUTE18,

Line 744: 'BEN_PRTT_ENRT_RSLT_F_DEL',

740: PLIP_ORDR_NUM,
741: PTIP_ORDR_NUM,
742: OIPL_ORDR_NUM)
743: values (
744: 'BEN_PRTT_ENRT_RSLT_F_DEL',
745: l_future_results.COMP_LVL_CD,
746: l_future_results.PEN_ATTRIBUTE16,
747: l_future_results.PEN_ATTRIBUTE17,
748: l_future_results.PEN_ATTRIBUTE18,

Line 1012: 'BEN_PRTT_ENRT_RSLT_F_DEL',

1008: PLIP_ORDR_NUM,
1009: PTIP_ORDR_NUM,
1010: OIPL_ORDR_NUM)
1011: values (
1012: 'BEN_PRTT_ENRT_RSLT_F_DEL',
1013: l_ended_result2.COMP_LVL_CD,
1014: l_ended_result2.PEN_ATTRIBUTE16,
1015: l_ended_result2.PEN_ATTRIBUTE17,
1016: l_ended_result2.PEN_ATTRIBUTE18,

Line 1228: 'BEN_PRTT_ENRT_RSLT_F_ADJ',

1224: ENRT_CVG_THRU_DT,
1225: business_group_id,
1226: object_version_number)
1227: values (
1228: 'BEN_PRTT_ENRT_RSLT_F_ADJ',
1229: l_get_enrt_rslts_for_pen.prtt_enrt_rslt_id,
1230: p_per_in_ler_id,
1231: l_get_enrt_rslts_for_pen.person_id,
1232: l_get_enrt_rslts_for_pen.enrt_cvg_thru_dt,