DBA Data[Home] [Help]

APPS.GHR_TSP_CATCHUP_PLAN_DESIGN dependencies on PAY_ELEMENT_ENTRIES_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 220: pay_element_entries_f e,

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,
221: pay_element_entry_values_f f,
222: per_assignments_f g
223: where a.element_type_id = b.element_type_id
224: and a.element_type_id = c.element_type_id