1390: ) is
1391: select BAL_TYPE.balance_name,
1392: nvl(sum(fnd_number.canonical_to_number(TARGET.result_value) * FEED.scale), 0)
1393: from pay_balance_feeds_f FEED,
1394: pay_balance_types BAL_TYPE,
1395: pay_run_result_values TARGET,
1396: pay_run_results RR,
1397: pay_payroll_actions PACT,
1398: pay_assignment_actions ASSACT,
1430: FEED.effective_end_date
1431: group by
1432: BAL_TYPE.balance_name ;
1433: --
1434: l_bal_name pay_balance_types.balance_name%type ;
1435: l_bal_value number ;
1436: --
1437: begin
1438: --