39: FROM per_all_assignments_f asg
40: ,per_all_people_f per
41: ,pay_element_links_f el
42: ,pay_element_types_f et
43: ,pay_input_values_f iv
44: ,pay_element_entries_f ee
45: ,pay_element_entry_values_f eev
46: WHERE asg.assignment_id = p_assignment_id
47: AND per.person_id = asg.person_id
184: ,per_all_assignments_f asg2
185: ,per_all_people_f per
186: ,pay_element_links_f el
187: ,pay_element_types_f et
188: ,pay_input_values_f iv1
189: ,pay_element_entries_f ee
190: ,pay_element_entry_values_f eev1
191: WHERE asg1.assignment_id = p_assignment_id
192: AND p_effective_date BETWEEN asg1.effective_start_date AND asg1.effective_end_date
210: ORDER BY ee.element_entry_id, DECODE(iv1.name, 'Start Date', 1,'End Date', 2, 'Sick Days', 3,'Start Time', 4,'End Time', 5,'Sick Hours', 6) ;
211: --
212: TYPE l_record is record (eeid pay_element_entries_f.element_entry_id%TYPE,
213: eevalue pay_element_entry_values_f.screen_entry_value%TYPE,
214: eename pay_input_values_f.name%TYPE );
215: l_rec l_record;
216: TYPE l_table is table of l_record index by BINARY_INTEGER;
217: l_tab l_table;
218:
400: FROM per_all_assignments_f asg
401: ,per_all_people_f per
402: ,pay_element_links_f el
403: ,pay_element_types_f et
404: ,pay_input_values_f iv
405: ,pay_element_entries_f ee
406: ,pay_element_entry_values_f eev
407: WHERE asg.assignment_id = p_assignment_id
408: AND per.person_id = asg.person_id