APPS.GHR_TSP_PLAN_DESIGN dependencies on PAY_ELEMENT_TYPES_F

Line 632: Cursor c_emp_tsp(c_business_group_id in number, c_element_name in pay_element_types_f.element_name%type) is

628: ,p_retcode OUT NOCOPY Number
629: ,p_business_group_id in Number) is
630:
631:
632: Cursor c_emp_tsp(c_business_group_id in number, c_element_name in pay_element_types_f.element_name%type) is
633: select
634: e.assignment_id assignment_id,
635: decode(name,'Rate','Percentage',
636: 'Status','Terminate Contributions',

Line 641: from pay_element_types_f a,

637: name) Name,
638: decode (screen_entry_value,'T',0,'S',0,screen_entry_value) screen_entry_value,
639: e.effective_start_date,
640: g.person_id
641: from pay_element_types_f a,
642: pay_input_values_f b,
643: pay_element_links_f c,
644: pay_link_input_values_f d,
645: pay_element_entries_f e,

Line 667: l_element_name pay_element_types_f.element_name%type;

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;
668:
669: BEGIN
670: -- 11.5.10 Performance Changes
671: l_element_name := NVL(UPPER(pqp_fedhr_uspay_int_utils.return_new_element_name ('TSP',p_business_group_id,sysdate,NULL)),'$Sys_Def$');