APPS.GHR_TSP_CATCHUP_PLAN_DESIGN dependencies on PAY_ELEMENT_TYPES_F

Line 208: -- Added link between pay_element_types_f and pay_element_entries_f on element_type_id

204: ,p_retcode OUT NOCOPY Number
205: ,p_business_group_id in Number) is
206:
207: -- Modified cursor for 11.5.10 Performance changes
208: -- Added link between pay_element_types_f and pay_element_entries_f on element_type_id
209: Cursor c_emp_tspc(c_business_group_id in number, c_element_name in pay_element_types_f.element_name%type) is
210: select
211: e.assignment_id assignment_id,
212: decode(name,'Catch Up Amount','Amount', name) Name,

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

205: ,p_business_group_id in Number) is
206:
207: -- Modified cursor for 11.5.10 Performance changes
208: -- Added link between pay_element_types_f and pay_element_entries_f on element_type_id
209: Cursor c_emp_tspc(c_business_group_id in number, c_element_name in pay_element_types_f.element_name%type) is
210: select
211: e.assignment_id assignment_id,
212: decode(name,'Catch Up Amount','Amount', name) Name,
213: screen_entry_value,

Line 216: from pay_element_types_f a,

212: decode(name,'Catch Up Amount','Amount', name) Name,
213: screen_entry_value,
214: e.effective_start_date,
215: g.person_id
216: from pay_element_types_f a,
217: pay_input_values_f b,
218: pay_element_links_f c,
219: pay_link_input_values_f d,
220: pay_element_entries_f e,

Line 240: l_element_name pay_element_types_f.element_name%type;

236: and trunc(e.effective_start_date) between g.effective_start_date and g.effective_end_date
237: and UPPER(a.element_name) = c_element_name
238: and ghr_general.return_number(screen_entry_value) > 0
239: order by 1, 2 desc;
240: l_element_name pay_element_types_f.element_name%type;
241:
242: BEGIN
243: -- 11.5.10 Performance Changes
244: l_element_name := NVL(UPPER(pqp_fedhr_uspay_int_utils.return_new_element_name ('TSP Catch Up Contribution',p_business_group_id,sysdate,NULL)),'$Sys_Def$');