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 HR_API

Line 423: ghr_api.retrieve_element_entry_value

419: hr_utility.set_location('Entering ' ||l_proc_name,10);
420: hr_utility.trace('p_asg_id = ' ||p_asg_id );
421:
422: -- Get Retirement Plan
423: ghr_api.retrieve_element_entry_value
424: (p_element_name => 'Retirement Plan'
425: ,p_input_value_name => 'Plan'
426: ,p_assignment_id => p_asg_id
427: ,p_effective_date => p_effective_date

Line 586: and perf.enrt_cvg_thru_dt = hr_api.g_eot

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
585: and trunc(l_effective_date) between perf.effective_start_date and perf.effective_end_date
586: and perf.enrt_cvg_thru_dt = hr_api.g_eot
587: and prv.rt_end_dt = hr_api.g_eot
588: and perf.prtt_enrt_rslt_stat_cd is null;
589:
590: Begin

Line 587: and prv.rt_end_dt = hr_api.g_eot

583: and perf.pl_id = p_pl_id
584: and perf.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id
585: and trunc(l_effective_date) between perf.effective_start_date and perf.effective_end_date
586: and perf.enrt_cvg_thru_dt = hr_api.g_eot
587: and prv.rt_end_dt = hr_api.g_eot
588: and perf.prtt_enrt_rslt_stat_cd is null;
589:
590: Begin
591: l_proc_name := g_package|| 'ghr_tsp_amount_validation';

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 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 856: ghr_api.retrieve_element_entry_value

852: hr_utility.trace('l_effective_date ' ||l_effective_date );
853: hr_utility.trace('old_status ' ||g_old_tsp_status );
854: hr_utility.trace('new_status ' ||g_new_tsp_status );
855: if g_old_tsp_status = g_new_tsp_status then
856: ghr_api.retrieve_element_entry_value
857: (p_element_name => 'TSP'
858: ,p_input_value_name => 'Status Date'
859: ,p_assignment_id => p_asg_id
860: ,p_effective_date => p_effective_date - 1

Line 934: ghr_api.retrieve_element_entry_value

930: l_effective_date := l_pay_start_date;
931: End If;
932: hr_utility.trace('l_effective_date ' ||l_effective_date );
933:
934: ghr_api.retrieve_element_entry_value
935: (p_element_name => 'TSP'
936: ,p_input_value_name => 'Status'
937: ,p_assignment_id => p_asg_id
938: ,p_effective_date => l_effective_date - 1

Line 1198: and perf.enrt_cvg_thru_dt = hr_api.g_eot

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
1198: and perf.enrt_cvg_thru_dt = hr_api.g_eot
1199: and prv.rt_end_dt = hr_api.g_eot
1200: and perf.prtt_enrt_rslt_stat_cd is null;
1201:
1202: -- Cursor to check if employee currently enrolled in TSP

Line 1199: and prv.rt_end_dt = hr_api.g_eot

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
1198: and perf.enrt_cvg_thru_dt = hr_api.g_eot
1199: and prv.rt_end_dt = hr_api.g_eot
1200: and perf.prtt_enrt_rslt_stat_cd is null;
1201:
1202: -- Cursor to check if employee currently enrolled in TSP
1203: Cursor c_chk_enrolled_in_tsp is

Line 1210: and enrt_cvg_thru_dt = hr_api.g_eot

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
1210: and enrt_cvg_thru_dt = hr_api.g_eot
1211: and prtt_enrt_rslt_stat_cd is null;
1212:
1213: Cursor c_get_opt_name is
1214: select name from ben_opt_f

Line 1780: and nvl(effective_date,hr_api.g_date) = trunc(p_effective_date);

1776: select noa_family_code,first_noa_code
1777: from ghr_pa_requests
1778: where person_id = v_person_id
1779: and noa_family_code in ('APP','CONV_APP')
1780: and nvl(effective_date,hr_api.g_date) = trunc(p_effective_date);
1781:
1782: -- get coverage and rate start date
1783: Cursor c_get_dates is
1784: select start_date

Line 1887: and perf.enrt_cvg_thru_dt = hr_api.g_eot

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
1886: and trunc(l_effective_date) between perf.effective_start_date and perf.effective_end_date
1887: and perf.enrt_cvg_thru_dt = hr_api.g_eot
1888: and prv.rt_end_dt = hr_api.g_eot
1889: and perf.prtt_enrt_rslt_stat_cd is null;
1890:
1891: -- get check__date maianitained in system for the rate start date

Line 1888: and prv.rt_end_dt = hr_api.g_eot

1884: and perf.pl_id = p_pl_id
1885: and perf.prtt_enrt_rslt_id = prv.prtt_enrt_rslt_id
1886: and trunc(l_effective_date) between perf.effective_start_date and perf.effective_end_date
1887: and perf.enrt_cvg_thru_dt = hr_api.g_eot
1888: and prv.rt_end_dt = hr_api.g_eot
1889: and perf.prtt_enrt_rslt_stat_cd is null;
1890:
1891: -- get check__date maianitained in system for the rate start date
1892: Cursor c_get_db_check_date is