823: (
824: SELECT pba.account_position_set_id,
825: pba.code_combination_id
826: FROM psb_set_relations rel ,
827: psb_budget_accounts pba
828: WHERE rel.gl_budget_id = l_gl_budget_rec.gl_budget_id
829: AND pba.account_position_set_id = rel.account_position_set_id
830: )
831: LOOP
840: (
841: SELECT gb.gl_budget_name
842: FROM psb_gl_budgets_v gb ,
843: psb_set_relations rel ,
844: psb_budget_accounts pba
845: WHERE gb.gl_budget_set_id = p_gl_budget_set_id
846: AND gb.gl_budget_id <> l_gl_budget_rec.gl_budget_id
847: AND rel.gl_budget_id = gb.gl_budget_id
848: AND pba.account_position_set_id = rel.account_position_set_id