2728: ,cp_element_entry_id NUMBER)
2729: is
2730: SELECT nvl(SUM(fnd_number.canonical_to_number(TARGET.result_value)
2731: * FEED.scale),0) tot
2732: FROM pay_run_result_values TARGET
2733: , pay_balance_feeds_f FEED
2734: , pay_run_results RR
2735: , pay_assignment_actions ASSACT
2736: , pay_assignment_actions BAL_ASSACT
2760: ,cp_element_entry_id NUMBER
2761: ,cp_element_type_id NUMBER)
2762: IS
2763: SELECT target.result_value tot
2764: FROM pay_run_result_values TARGET
2765: , pay_balance_feeds_f FEED
2766: , pay_run_results RR
2767: , pay_assignment_actions ASSACT
2768: , pay_assignment_actions BAL_ASSACT