[Home] [Help]
204: p_input_val_id_med in number,
205: p_ele_type_id in number,
206: p_report_item_type in varchar2,
207: p_input_val_id_tax in number) IS
208: select paa.assignment_id, sum(fnd_number.canonical_to_number(prrv1.result_value)) result_value --paa.assignment_action_id, paa.payroll_action_id
209: from pay_assignment_actions paa,
210: pay_payroll_actions ppa,
211: pay_run_results prr,
212: pay_run_result_values prrv,
223: and prrv1.input_value_id = p_input_val_id_tax
224: and ppa.effective_date between to_date('01/01/2007','DD/MM/RRRR') and l_effective_date
225: and ppa.action_type in ('R','Q','B','V')
226: group by paa.assignment_id
227: having sum(fnd_number.canonical_to_number(prrv1.result_value)) <> 0
228: order by paa.assignment_id;
229:
230: -- Cursor to get result values
231: cursor csr_get_value (p_ele_type_id in number,
381: fetch csr_get_value into l_result_val;
382: close csr_get_value;
383:
384: l_result_val_num := l_result_val_num + to_number(l_result_val);
385: l_result_val_num := l_result_val_num + fnd_number.canonical_to_number(l_result_val);
386: */
387: -- get the Person_name, assignment_number
388: open csr_person_details (l_csr_assig_act.assignment_id);
389: fetch csr_person_details into l_full_name, l_assig_number;