582: and ast.per_system_status = 'ACTIVE_ASSIGN'
583: and asg.organization_id in (
584: select be.organization_id
585: from per_budget_values bval
586: , per_budget_elements be
587: , per_budget_versions bver
588: , per_time_periods tp
589: , per_budgets_v bud
590: where bud.budget_id = cp_budget_id
600: , cp_report_date DATE )
601: is
602: select distinct be.organization_id
603: from per_budget_values bval
604: , per_budget_elements be
605: , per_budget_versions bver
606: , per_time_periods tp
607: , per_budgets_v bud
608: where bud.budget_id = cp_budget_id
621: is
622: select sum(bval.value) budget_value
623: , be.organization_id
624: from per_budget_values bval
625: , per_budget_elements be
626: , per_budget_versions bver
627: , per_time_periods tp
628: , per_budgets_v bud
629: where bud.budget_id = cp_budget_id