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

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

Line 229: from ben_prtt_enrt_rslt_f pen

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

Line 248: ,ben_prtt_enrt_rslt_f pen

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

Line 278: ,ben_prtt_enrt_rslt_f pen

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

Line 504: from ben_prtt_enrt_rslt_f pen

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

Line 526: from ben_prtt_enrt_rslt_f pen

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

Line 547: from ben_prtt_enrt_rslt_f pen

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

Line 701: from ben_prtt_enrt_rslt_f pen

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

Line 715: from ben_prtt_enrt_rslt_f pen

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

Line 728: from ben_prtt_enrt_rslt_f pen

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

Line 740: from ben_prtt_enrt_rslt_f pen,

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

Line 1054: p_base_table_name => 'BEN_PRTT_ENRT_RSLT_F',

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

Line 1308: p_base_table_name => 'BEN_PRTT_ENRT_RSLT_F',

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

Line 1613: p_base_table_name => 'BEN_PRTT_ENRT_RSLT_F',

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