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

Line 211: from ben_prtt_enrt_rslt_f pen

207: --
208: cursor c_pep_pgm_defer(p_pgm_id number) is
209: --
210: select pen.*
211: from ben_prtt_enrt_rslt_f pen
212: ,ben_elig_per_f pep
213: where pen.pgm_id = p_pgm_id
214: ---Bug 7342283
215: and pen.pgm_id = pep.pgm_id

Line 231: from ben_prtt_enrt_rslt_f pen

227: --
228: cursor c_pep_pl_defer(p_pl_id number) is
229: --
230: select pen.*
231: from ben_prtt_enrt_rslt_f pen
232: ,ben_elig_per_f pep
233: where pen.pl_id = p_pl_id
234: and pep.pl_id = pen.pl_id
235: and pep.elig_flag = 'N'

Line 250: ,ben_prtt_enrt_rslt_f pen

246: cursor c_epo_plip_defer(p_pgm_id number) is
247: --
248: select pen.*
249: from ben_elig_per_opt_f epo
250: ,ben_prtt_enrt_rslt_f pen
251: ,ben_oipl_f oipl
252: ,ben_elig_per_f pep
253: where pen.pgm_id = p_pgm_id
254: ---Bug 7301670

Line 280: ,ben_prtt_enrt_rslt_f pen

276: cursor c_epo_plnip_defer(p_pl_id number) is
277: --
278: select pen.*
279: from ben_elig_per_opt_f epo
280: ,ben_prtt_enrt_rslt_f pen
281: ,ben_oipl_f oipl
282: ,ben_elig_per_f pep
283: where pen.pl_id = p_pl_id
284: and pep.pl_id = pen.pl_id

Line 506: from ben_prtt_enrt_rslt_f pen

502: cursor c_pen_pl is
503: select pen.prtt_enrt_rslt_id, pgm_id, pl_id, oipl_id, pen.object_version_number,ptip_id,
504: pen.effective_start_date,pen.enrt_mthd_cd,
505: pen.enrt_cvg_strt_dt
506: from ben_prtt_enrt_rslt_f pen
507: where p_pl_id = pen.pl_id
508: and nvl(pen.pgm_id,-1)=nvl(p_pgm_id,-1)
509: and pen.person_id = p_person_id
510: and pen.business_group_id+0 = p_business_group_id

Line 528: from ben_prtt_enrt_rslt_f pen

524: cursor c_pen_pgm is
525: select pen.prtt_enrt_rslt_id, pgm_id, pl_id, oipl_id, pen.object_version_number,ptip_id,
526: pen.effective_start_date,pen.enrt_mthd_cd,
527: pen.enrt_cvg_strt_dt
528: from ben_prtt_enrt_rslt_f pen
529: where p_pgm_id = pen.pgm_id
530: and pen.person_id = p_person_id
531: and pen.business_group_id+0 = p_business_group_id
532: and pen.prtt_enrt_rslt_stat_cd is null

Line 549: from ben_prtt_enrt_rslt_f pen

545: cursor c_pen_oipl is
546: select pen.prtt_enrt_rslt_id, pgm_id, pl_id, oipl_id, pen.object_version_number,
547: pen.effective_start_date,pen.enrt_mthd_cd,
548: pen.enrt_cvg_strt_dt
549: from ben_prtt_enrt_rslt_f pen
550: where p_oipl_id = pen.oipl_id
551: and nvl(pen.pgm_id,-1)=nvl(p_pgm_id,-1)
552: and pen.person_id = p_person_id
553: and pen.business_group_id+0 = p_business_group_id

Line 703: from ben_prtt_enrt_rslt_f pen

699: cursor c_pen_pl_2 is
700: select pen.prtt_enrt_rslt_id, pgm_id, pl_id, oipl_id, pen.object_version_number,ptip_id,
701: pen.effective_start_date,pen.enrt_mthd_cd,
702: pen.enrt_cvg_strt_dt
703: from ben_prtt_enrt_rslt_f pen
704: where p_pl_id = pen.pl_id
705: and nvl(pen.pgm_id,-1)=nvl(p_pgm_id,-1)
706: and pen.person_id = p_person_id
707: and pen.business_group_id = p_business_group_id

Line 717: from ben_prtt_enrt_rslt_f pen

713: cursor c_pen_pgm_2 is
714: select pen.prtt_enrt_rslt_id, pgm_id, pl_id, oipl_id, pen.object_version_number,ptip_id,
715: pen.effective_start_date,pen.enrt_mthd_cd,
716: pen.enrt_cvg_strt_dt
717: from ben_prtt_enrt_rslt_f pen
718: where p_pgm_id = pen.pgm_id
719: and pen.person_id = p_person_id
720: and pen.business_group_id = p_business_group_id
721: and pen.prtt_enrt_rslt_stat_cd is null

Line 730: from ben_prtt_enrt_rslt_f pen

726: cursor c_pen_oipl_2 is
727: select pen.prtt_enrt_rslt_id, pgm_id, pl_id, oipl_id, pen.object_version_number,
728: pen.effective_start_date,pen.enrt_mthd_cd,
729: pen.enrt_cvg_strt_dt
730: from ben_prtt_enrt_rslt_f pen
731: where p_oipl_id = pen.oipl_id
732: and nvl(pen.pgm_id,-1)=nvl(p_pgm_id,-1)
733: and pen.person_id = p_person_id
734: and pen.business_group_id = p_business_group_id

Line 742: from ben_prtt_enrt_rslt_f pen,

738: and l_effective_date_1 < pen.enrt_cvg_thru_dt;
739: --
740: cursor c_pen_max_esd (v_prtt_enrt_rslt_id in number) is
741: select pen.effective_end_date,pen.object_version_number
742: from ben_prtt_enrt_rslt_f pen,
743: ben_per_in_ler pil
744: where prtt_enrt_rslt_id = v_prtt_enrt_rslt_id
745: and pen.business_group_id = p_business_group_id
746: and pil.per_in_ler_stat_cd not in ('BCKDT','VOIDD')

Line 1056: p_base_table_name => 'BEN_PRTT_ENRT_RSLT_F',

1052: l_ovn := l_pen.object_version_number;
1053: --
1054: dt_api.find_dt_upd_modes
1055: (p_effective_date => p_effective_date,
1056: p_base_table_name => 'BEN_PRTT_ENRT_RSLT_F',
1057: p_base_key_column => 'prtt_enrt_rslt_id',
1058: p_base_key_value => l_pen.prtt_enrt_rslt_id,
1059: p_correction => l_correction,
1060: p_update => l_update,

Line 1310: p_base_table_name => 'BEN_PRTT_ENRT_RSLT_F',

1306: hr_utility.set_location('p_effective_date '||p_effective_date,10);
1307: --
1308: dt_api.find_dt_upd_modes
1309: (p_effective_date => p_effective_date,
1310: p_base_table_name => 'BEN_PRTT_ENRT_RSLT_F',
1311: p_base_key_column => 'prtt_enrt_rslt_id',
1312: p_base_key_value => l_pen.prtt_enrt_rslt_id,
1313: p_correction => l_correction,
1314: p_update => l_update,

Line 1615: p_base_table_name => 'BEN_PRTT_ENRT_RSLT_F',

1611: l_ovn := l_pen.object_version_number;
1612: --
1613: dt_api.find_dt_upd_modes
1614: (p_effective_date => p_effective_date,
1615: p_base_table_name => 'BEN_PRTT_ENRT_RSLT_F',
1616: p_base_key_column => 'prtt_enrt_rslt_id',
1617: p_base_key_value => l_pen.prtt_enrt_rslt_id,
1618: p_correction => l_correction,
1619: p_update => l_update,