763: and asg.organization_id in (
764: select distinct bdet.organization_id
765: from pqh_budgets bud
766: , pqh_budget_versions bver
767: , pqh_budget_details bdet
768: , pqh_budget_periods bper
769: , per_shared_types pst1
770: , per_time_periods ptp
771: where bud.budget_id = cp_budget_id
783: is
784: select distinct bdet.organization_id
785: from pqh_budgets bud
786: , pqh_budget_versions bver
787: , pqh_budget_details bdet
788: , pqh_budget_periods bper
789: , per_shared_types pst1
790: , per_time_periods ptp
791: where bud.budget_id = cp_budget_id
806: , SUM(bper.budget_unit3_value) budget_value3
807: , bdet.organization_id
808: from pqh_budgets bud
809: , pqh_budget_versions bver
810: , pqh_budget_details bdet
811: , pqh_budget_periods bper
812: , per_shared_types pst1
813: , per_shared_types pst2
814: , per_shared_types pst3