[Home] [Help]
537: -- Get the Root Budget Group for the Budget Group
538: FOR l_bg_rec IN
539: (
540: SELECT nvl(root_budget_group_id, budget_group_id) root_budget_group_id
541: FROM psb_budget_groups_v
542: WHERE budget_group_id = p_parent_budget_group_id
543: )
544: LOOP
545: l_root_budget_group_id := l_bg_rec.root_budget_group_id;