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 247: from ben_prtt_enrt_rslt_f pen,

243: p_pl_typ_id in number,
244: p_business_group_id in number) is
245:
246: select pen.*
247: from ben_prtt_enrt_rslt_f pen,
248: ben_per_in_ler pil
249: where pen.person_id = p_person_id
250: and pen.effective_end_date = hr_api.g_eot
251: and pen.business_group_id = p_business_group_id

Line 281: from ben_prtt_enrt_rslt_f pen

277: select prv.*
278: from ben_prtt_rt_val prv
279: where prv.prtt_enrt_rslt_id in
280: (select pen.prtt_enrt_rslt_id
281: from ben_prtt_enrt_rslt_f pen
282: where pen.effective_end_date = hr_api.g_eot
283: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
284: and pen.person_id = p_person_id
285: and pen.pgm_id <> p_pgm_id

Line 301: from ben_prtt_enrt_rslt_f pen

297: p_person_id number,
298: p_business_group_id number,
299: p_pgm_id number) is
300: select pen.*
301: from ben_prtt_enrt_rslt_f pen
302: where pen.effective_end_date = hr_api.g_eot
303: and pen.enrt_cvg_thru_dt <> hr_api.g_eot
304: and pen.person_id = p_person_id
305: and pen.pgm_id <> p_pgm_id

Line 319: from ben_prtt_enrt_rslt_f pen

315: --
316: cursor c_pen (p_prtt_enrt_rslt_id number) is
317: select pen.effective_start_date,
318: pen.object_version_number
319: from ben_prtt_enrt_rslt_f pen
320: where pen.effective_end_date = hr_api.g_eot
321: and pen.prtt_enrt_rslt_stat_cd is null
322: and pen.business_group_id = p_business_group_id
323: and pen.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id;

Line 354: from ben_prtt_enrt_rslt_f

350: p_prtt_enrt_rslt_id number) is
351: select elig_per_elctbl_chc_id
352: from ben_elig_per_elctbl_chc epe
353: where epe.per_in_ler_id in (select per_in_ler_id
354: from ben_prtt_enrt_rslt_f
355: where prtt_enrt_rslt_id = p_prtt_enrt_rslt_id)
356: and epe.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id;
357: --
358: cursor c_get_prior_per_in_ler is

Line 374: from ben_prtt_enrt_rslt_f pen

370: select prv.*
371: ,abr.element_type_id
372: ,abr.input_value_id
373: ,pen.person_id
374: from ben_prtt_enrt_rslt_f pen
375: ,ben_prtt_rt_val prv
376: ,ben_acty_base_rt_f abr
377: where pen.effective_end_date = hr_api.g_eot
378: and pen.enrt_cvg_thru_dt <> hr_api.g_eot

Line 396: from ben_prtt_enrt_rslt_f pen

392: cursor c_get_enrt_rslts_for_pen(p_cvg_end_dt date
393: ,p_ptip_id number
394: ) is
395: select pen.*
396: from ben_prtt_enrt_rslt_f pen
397: ,ben_ptip_f ptip
398: where pen.effective_end_date = hr_api.g_eot -- '31-dec-4712'
399: and pen.enrt_cvg_thru_dt <> hr_api.g_eot -- '31-dec-4712'
400: and pen.prtt_enrt_rslt_stat_cd is null

Line 474: where BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_RSLT_F_ADJ'

470: cursor c_prtt_enrt_rslt_adj (p_per_in_ler_id number,
471: p_prtt_enrt_rslt_id number) is
472: select null
473: from ben_le_clsn_n_rstr
474: where BKUP_TBL_TYP_CD = 'BEN_PRTT_ENRT_RSLT_F_ADJ'
475: AND BKUP_TBL_ID = p_prtt_enrt_rslt_id
476: AND PER_IN_LER_ID = p_per_in_ler_id;
477: --
478: -- End bug 7206471

Line 611: 'BEN_PRTT_ENRT_RSLT_F_DEL',

607: PLIP_ORDR_NUM,
608: PTIP_ORDR_NUM,
609: OIPL_ORDR_NUM)
610: values (
611: 'BEN_PRTT_ENRT_RSLT_F_DEL',
612: l_ended_result.COMP_LVL_CD,
613: l_ended_result.PEN_ATTRIBUTE16,
614: l_ended_result.PEN_ATTRIBUTE17,
615: l_ended_result.PEN_ATTRIBUTE18,

Line 782: 'BEN_PRTT_ENRT_RSLT_F_DEL',

778: PLIP_ORDR_NUM,
779: PTIP_ORDR_NUM,
780: OIPL_ORDR_NUM)
781: values (
782: 'BEN_PRTT_ENRT_RSLT_F_DEL',
783: l_future_results.COMP_LVL_CD,
784: l_future_results.PEN_ATTRIBUTE16,
785: l_future_results.PEN_ATTRIBUTE17,
786: l_future_results.PEN_ATTRIBUTE18,

Line 1054: 'BEN_PRTT_ENRT_RSLT_F_DEL',

1050: PLIP_ORDR_NUM,
1051: PTIP_ORDR_NUM,
1052: OIPL_ORDR_NUM)
1053: values (
1054: 'BEN_PRTT_ENRT_RSLT_F_DEL',
1055: l_ended_result2.COMP_LVL_CD,
1056: l_ended_result2.PEN_ATTRIBUTE16,
1057: l_ended_result2.PEN_ATTRIBUTE17,
1058: l_ended_result2.PEN_ATTRIBUTE18,

Line 1254: 'BEN_PRTT_ENRT_RSLT_F_DEL',

1250: PLIP_ORDR_NUM,
1251: PTIP_ORDR_NUM,
1252: OIPL_ORDR_NUM)
1253: values (
1254: 'BEN_PRTT_ENRT_RSLT_F_DEL',
1255: l_future_results2.COMP_LVL_CD,
1256: l_future_results2.PEN_ATTRIBUTE16,
1257: l_future_results2.PEN_ATTRIBUTE17,
1258: l_future_results2.PEN_ATTRIBUTE18,

Line 1502: 'BEN_PRTT_ENRT_RSLT_F_ADJ',

1498: ENRT_CVG_THRU_DT,
1499: business_group_id,
1500: object_version_number)
1501: values (
1502: 'BEN_PRTT_ENRT_RSLT_F_ADJ',
1503: l_get_enrt_rslts_for_pen.prtt_enrt_rslt_id,
1504: p_per_in_ler_id,
1505: l_get_enrt_rslts_for_pen.person_id,
1506: l_get_enrt_rslts_for_pen.enrt_cvg_thru_dt,