DBA Data[Home] [Help]

APPS.GHR_TSP_PLAN_DESIGN dependencies on GHR_GENERAL

Line 663: and ( (b.name in ('Rate','Amount') and (ghr_general.return_number(screen_entry_value) > 0))

659: and g.assignment_id = e.assignment_id
660: and trunc(e.effective_start_date) between g.effective_start_date and g.effective_end_date
661: --and a.element_name = 'TSP'
662: and a.element_name = c_element_name
663: and ( (b.name in ('Rate','Amount') and (ghr_general.return_number(screen_entry_value) > 0))
664: or (b.name = 'Status' and screen_entry_value in ('T','S')))
665: order by 1, 2 desc ;
666:
667: l_element_name pay_element_types_f.element_name%type;

Line 676: ghr_general.ghr_tsp_migrate(emp_rec.assignment_id,

672:
673: -- set program name
674: ghr_mto_int.set_log_program_name('GHR_TSP_MIGRATION');
675: for emp_rec in c_emp_tsp(p_business_group_id,l_element_name) loop
676: ghr_general.ghr_tsp_migrate(emp_rec.assignment_id,
677: emp_rec.name,
678: emp_rec.screen_entry_value,
679: emp_rec.effective_start_date,
680: p_business_group_id,