117: ee.effective_end_date,
118: ee.element_entry_id
119: from
120: pay_element_entry_values_f eev,
121: pay_element_entries_f ee,
122: per_all_assignments_f asg,
123: pay_input_values_f iv
124: where
125: asg.person_id = p_person_id
165: screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE,
166: element_entry_value_id pay_element_entry_values_f.element_entry_value_id%TYPE,
167: eev_effective_start_date pay_element_entry_values_f.effective_start_date%TYPE,
168: eev_effective_end_date pay_element_entry_values_f.effective_end_date%TYPE,
169: cost_allocation_keyflex_id pay_element_entries_f.cost_allocation_keyflex_id%TYPE,
170: reason pay_element_entries_f.reason%TYPE,
171: effective_start_date pay_element_entries_f.effective_start_date%TYPE,
172: effective_end_date pay_element_entries_f.effective_end_date%TYPE,
173: element_entry_id pay_element_entries_f.element_entry_id%TYPE
166: element_entry_value_id pay_element_entry_values_f.element_entry_value_id%TYPE,
167: eev_effective_start_date pay_element_entry_values_f.effective_start_date%TYPE,
168: eev_effective_end_date pay_element_entry_values_f.effective_end_date%TYPE,
169: cost_allocation_keyflex_id pay_element_entries_f.cost_allocation_keyflex_id%TYPE,
170: reason pay_element_entries_f.reason%TYPE,
171: effective_start_date pay_element_entries_f.effective_start_date%TYPE,
172: effective_end_date pay_element_entries_f.effective_end_date%TYPE,
173: element_entry_id pay_element_entries_f.element_entry_id%TYPE
174: );
167: eev_effective_start_date pay_element_entry_values_f.effective_start_date%TYPE,
168: eev_effective_end_date pay_element_entry_values_f.effective_end_date%TYPE,
169: cost_allocation_keyflex_id pay_element_entries_f.cost_allocation_keyflex_id%TYPE,
170: reason pay_element_entries_f.reason%TYPE,
171: effective_start_date pay_element_entries_f.effective_start_date%TYPE,
172: effective_end_date pay_element_entries_f.effective_end_date%TYPE,
173: element_entry_id pay_element_entries_f.element_entry_id%TYPE
174: );
175:
168: eev_effective_end_date pay_element_entry_values_f.effective_end_date%TYPE,
169: cost_allocation_keyflex_id pay_element_entries_f.cost_allocation_keyflex_id%TYPE,
170: reason pay_element_entries_f.reason%TYPE,
171: effective_start_date pay_element_entries_f.effective_start_date%TYPE,
172: effective_end_date pay_element_entries_f.effective_end_date%TYPE,
173: element_entry_id pay_element_entries_f.element_entry_id%TYPE
174: );
175:
176: pay get_csr_val;
169: cost_allocation_keyflex_id pay_element_entries_f.cost_allocation_keyflex_id%TYPE,
170: reason pay_element_entries_f.reason%TYPE,
171: effective_start_date pay_element_entries_f.effective_start_date%TYPE,
172: effective_end_date pay_element_entries_f.effective_end_date%TYPE,
173: element_entry_id pay_element_entries_f.element_entry_id%TYPE
174: );
175:
176: pay get_csr_val;
177: --Changes for Penserver: Stop
243: ee.effective_end_date,
244: ee.element_entry_id
245: from
246: pay_element_entry_values_f eev,
247: pay_element_entries_f ee,
248: per_all_assignments_f asg,
249: per_all_people_f per,
250: pay_input_values_f iv,
251: pay_element_types_f et,
319: ee.effective_end_date,
320: ee.element_entry_id
321: from
322: pay_element_entry_values_f eev,
323: pay_element_entries_f ee,
324: per_all_assignments_f asg,
325: pay_input_values_f iv
326: where
327: asg.person_id = p_person_id
362: ee.effective_end_date,
363: ee.element_entry_id
364: from
365: pay_element_entry_values_f eev,
366: pay_element_entries_f ee,
367: per_all_assignments_f asg,
368: pay_input_values_f iv
369: where
370: asg.person_id = p_person_id