487: IS
488: Cursor csr_paid_amount
489: IS
490: Select sum(prrv.result_value)
491: from pay_run_result_values prrv
492: ,pay_input_values_f piv
493: ,pay_run_results prr
494: where prr.source_id = p_element_entry_id
495: and prr.assignment_action_id = p_assignment_action_id
704: IS
705: Cursor csr_interest
706: IS
707: Select prrv.result_value
708: from pay_run_result_values prrv
709: ,pay_input_values_f piv
710: ,pay_run_results prr
711: ,pay_element_types_f pet
712: where prr.source_id = p_element_entry_id