238:
239: i := 1;
240: j := 1;
241: FOR x IN (SELECT activity_budget_id, status_code, budget_source_id 242: FROM ozf_act_budgets 243: WHERE arc_act_budget_used_by = 'OFFR' AND
244: act_budget_used_by_id = l_qp_list_header_id)
245: LOOP
246: if(x.status_code ='APPROVED' ) then