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.GHR_FORMULA_FUNCTIONS dependencies on BEN_PRTT_RT_VAL

Line 580: from ben_prtt_enrt_rslt_f perf , ben_prtt_rt_val prv

576: and trunc(p_effective_date) between effective_start_date and effective_end_date;
577:
578: Cursor c_get_prtt_enrt_rslt_id is
579: select enrt_cvg_strt_dt,rt_val
580: from ben_prtt_enrt_rslt_f perf , ben_prtt_rt_val prv
581: where perf.person_id = l_person_id
582: and perf.pgm_id = p_pgm_id
583: and perf.pl_id = p_pl_id
584: and perf.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id

Line 684: from ben_prtt_rt_val , ben_prtt_enrt_rslt_f

680: and trunc(p_effective_date) between effective_start_date and effective_end_date;
681:
682: Cursor c_get_tsp_percentage is
683: select rt_val,enrt_cvg_strt_dt
684: from ben_prtt_rt_val , ben_prtt_enrt_rslt_f
685: where ben_prtt_rt_val.prtt_enrt_rslt_id = ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id
686: and ben_prtt_enrt_rslt_f.person_id = l_person_id
687: and ben_prtt_enrt_rslt_f.pgm_id = p_pgm_id
688: and ben_prtt_enrt_rslt_f.pl_id = p_pl_id

Line 685: where ben_prtt_rt_val.prtt_enrt_rslt_id = ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id

681:
682: Cursor c_get_tsp_percentage is
683: select rt_val,enrt_cvg_strt_dt
684: from ben_prtt_rt_val , ben_prtt_enrt_rslt_f
685: where ben_prtt_rt_val.prtt_enrt_rslt_id = ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id
686: and ben_prtt_enrt_rslt_f.person_id = l_person_id
687: and ben_prtt_enrt_rslt_f.pgm_id = p_pgm_id
688: and ben_prtt_enrt_rslt_f.pl_id = p_pl_id
689: and trunc(l_effective_date) between ben_prtt_enrt_rslt_f.effective_start_date

Line 692: and ben_prtt_rt_val.rt_end_dt = hr_api.g_eot

688: and ben_prtt_enrt_rslt_f.pl_id = p_pl_id
689: and trunc(l_effective_date) between ben_prtt_enrt_rslt_f.effective_start_date
690: and ben_prtt_enrt_rslt_f.effective_end_date
691: and ben_prtt_enrt_rslt_f.enrt_cvg_thru_dt = hr_api.g_eot
692: and ben_prtt_rt_val.rt_end_dt = hr_api.g_eot
693: and ben_prtt_enrt_rslt_f.prtt_enrt_rslt_stat_cd is null;
694:
695: Begin
696: l_proc_name := g_package|| 'ghr_tsp_percentage_validation';

Line 1193: from ben_prtt_enrt_rslt_f perf, ben_prtt_rt_val prv

1189:
1190: -- Cursor to check if employee currently enrolled in TSP Catch Up
1191: Cursor c_chk_enrolled_in_tspc is
1192: select rt_strt_dt
1193: from ben_prtt_enrt_rslt_f perf, ben_prtt_rt_val prv
1194: where perf.person_id = l_person_id
1195: and perf.pgm_id = p_pgm_id
1196: and perf.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id
1197: and trunc(p_effective_date) between perf.effective_start_date and perf.effective_end_date

Line 1881: from ben_prtt_enrt_rslt_f perf , ben_prtt_rt_val prv

1877: and trunc(p_effective_date) between effective_start_date and effective_end_date;
1878:
1879: Cursor c_get_prtt_enrt_rslt_id is
1880: select rt_strt_dt,rt_val
1881: from ben_prtt_enrt_rslt_f perf , ben_prtt_rt_val prv
1882: where perf.person_id = l_person_id
1883: and perf.pgm_id = p_pgm_id
1884: and perf.pl_id = p_pl_id
1885: and perf.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id