583: from (select mad.units,
584: mad.employee_id,
585: mad.deprn_expense_ccid,
586: mad.location_id
587: from fa_massadd_distributions mad
588: where mad.mass_addition_id = p_massadd_id
589: union all
590: select mad.units,
591: mad.employee_id,
590: select mad.units,
591: mad.employee_id,
592: mad.deprn_expense_ccid,
593: mad.location_id
594: from fa_massadd_distributions mad,
595: fa_mass_additions mac,
596: fa_mass_additions map
597: where map.sum_units = 'YES'
598: and map.mass_addition_id = p_massadd_id