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
126: and asg.assignment_id = ee.assignment_id
127: and ee.element_entry_id = eev.element_entry_id
156:
157:
158: TYPE get_csr_val IS RECORD
159: (
160: name pay_input_values_f.name%TYPE,
161: uom pay_input_values_f.uom%TYPE,
162: display_sequence pay_input_values_f.display_sequence%TYPE,
163: input_value_id pay_input_values_f.input_value_id%TYPE,
164: element_type_id pay_input_values_f.element_type_id%TYPE,
157:
158: TYPE get_csr_val IS RECORD
159: (
160: name pay_input_values_f.name%TYPE,
161: uom pay_input_values_f.uom%TYPE,
162: display_sequence pay_input_values_f.display_sequence%TYPE,
163: input_value_id pay_input_values_f.input_value_id%TYPE,
164: element_type_id pay_input_values_f.element_type_id%TYPE,
165: screen_entry_value pay_element_entry_values_f.screen_entry_value%TYPE,
158: TYPE get_csr_val IS RECORD
159: (
160: name pay_input_values_f.name%TYPE,
161: uom pay_input_values_f.uom%TYPE,
162: display_sequence pay_input_values_f.display_sequence%TYPE,
163: input_value_id pay_input_values_f.input_value_id%TYPE,
164: element_type_id pay_input_values_f.element_type_id%TYPE,
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,
159: (
160: name pay_input_values_f.name%TYPE,
161: uom pay_input_values_f.uom%TYPE,
162: display_sequence pay_input_values_f.display_sequence%TYPE,
163: input_value_id pay_input_values_f.input_value_id%TYPE,
164: element_type_id pay_input_values_f.element_type_id%TYPE,
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,
160: name pay_input_values_f.name%TYPE,
161: uom pay_input_values_f.uom%TYPE,
162: display_sequence pay_input_values_f.display_sequence%TYPE,
163: input_value_id pay_input_values_f.input_value_id%TYPE,
164: element_type_id pay_input_values_f.element_type_id%TYPE,
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,
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,
252: pay_element_classifications ec,
253: ff_formulas_f ff,
254: pay_cost_allocation_keyflex ca
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
328: and asg.assignment_id = ee.assignment_id
329: and ee.element_entry_id = eev.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
371: and asg.assignment_id = ee.assignment_id
372: and ee.element_entry_id = eev.element_entry_id