463:
464: BEGIN
465: select units_assigned
466: into l_curr_units
467: from fa_distribution_history
468: where asset_id = p_asset_id
469: and distribution_id = p_distribution_id
470: and date_ineffective IS NULL;
471:
504: -- and get current units as it's needed in calling procedure
505:
506: select units_assigned
507: into l_curr_units
508: from fa_distribution_history
509: where asset_id = p_asset_id
510: and distribution_id = p_distribution_id_from
511: and date_ineffective IS NULL;
512: