133: , p_local_unit pay_run_results.local_unit_id%type)
134: is
135: select
136: nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)
137: from pay_balance_feeds_f feed
138: ,pay_run_result_values target
139: ,pay_run_results rr
140: ,pay_payroll_actions pact
141: ,pay_assignment_actions assact
173: ) is
174: select nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale),0)
175: from
176:
177: pay_balance_feeds_f feed
178: ,pay_run_result_values target
179: ,pay_run_results rr
180: ,pay_payroll_actions pact
181: ,pay_assignment_actions assact