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_ENRT_RSLT_F

Line 567: l_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type;

563: l_proc_name varchar2(100);
564: l_result Varchar2(1);
565: l_person_id per_all_people_f.person_id%type;
566: l_tsp_amount Number;
567: l_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type;
568: l_payroll_id pay_payrolls_f.payroll_id%type;
569: l_enrt_cvg_strt_dt Date;
570: l_effective_date Date;
571:

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 686: and ben_prtt_enrt_rslt_f.person_id = l_person_id

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
690: and ben_prtt_enrt_rslt_f.effective_end_date

Line 687: and ben_prtt_enrt_rslt_f.pgm_id = p_pgm_id

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
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

Line 688: and ben_prtt_enrt_rslt_f.pl_id = p_pl_id

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
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

Line 689: and trunc(l_effective_date) between ben_prtt_enrt_rslt_f.effective_start_date

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
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;

Line 690: and ben_prtt_enrt_rslt_f.effective_end_date

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
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:

Line 691: and ben_prtt_enrt_rslt_f.enrt_cvg_thru_dt = hr_api.g_eot

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
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

Line 693: and ben_prtt_enrt_rslt_f.prtt_enrt_rslt_stat_cd is null;

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';
697: l_result := 'Y';

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 1205: from ben_prtt_enrt_rslt_f perf

1201:
1202: -- Cursor to check if employee currently enrolled in TSP
1203: Cursor c_chk_enrolled_in_tsp is
1204: select pl_id,oipl_id
1205: from ben_prtt_enrt_rslt_f perf
1206: where person_id = l_person_id
1207: and pgm_id = l_tsp_pgm_id
1208: --and pl_id = l_pl_id
1209: and trunc(l_db_next_pay_start_date) between effective_start_date and effective_end_date

Line 1864: l_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type;

1860: l_proc_name varchar2(100);
1861: l_result Varchar2(1);
1862: l_person_id per_all_people_f.person_id%type;
1863: l_tsp_cu_amount Number;
1864: l_prtt_enrt_rslt_id ben_prtt_enrt_rslt_f.prtt_enrt_rslt_id%type;
1865: l_payroll_id pay_payrolls_f.payroll_id%type;
1866: l_rt_strt_dt Date;
1867: l_effective_date Date;
1868: l_agency_check_date 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

Line 2156: from ben_prtt_enrt_rslt_f perf

2152:
2153: Cursor c_get_enrt_cvg_info(p_person_id in number) is
2154: select enrt_cvg_strt_dt,
2155: ler_id
2156: from ben_prtt_enrt_rslt_f perf
2157: where perf.person_id = p_person_id
2158: and perf.pgm_id = p_pgm_id
2159: and perf.pl_id = p_pl_id
2160: and perf.prtt_enrt_rslt_stat_cd is null

Line 2178: l_enrt_cvg_st_dt ben_prtt_enrt_rslt_f.enrt_cvg_strt_dt%type;

2174:
2175: l_fegli_code ghr_pa_requests.fegli%type;
2176: l_person_id per_all_assignments_f.person_id%type;
2177: l_payroll_id per_all_assignments_f.payroll_id%type;
2178: l_enrt_cvg_st_dt ben_prtt_enrt_rslt_f.enrt_cvg_strt_dt%type;
2179: l_option_id ben_opt_f.opt_id%type;
2180: l_ler_name ben_ler_f.name%type;
2181: l_ler_id ben_ler_f.ler_id%type;
2182: l_fegli_event_code varchar2(3);