108: SELECT ibc.proposal_id
109: , ibc.budget_period_id
110: , ibc.expenditure_type
111: , ibc.expenditure_category_flag
112: , nvl(ibc.line_item_cost,0)+nvl(igw_budget_integration.get_eb_cost_ss(ibc.line_item_id),0) direct_cost
113: , ibc.line_item_cost
114: , igw_budget_integration.get_oh_cost_ss(ibc.line_item_id) indirect_cost
115: , ibp.start_date
116: , ibp.end_date
110: , ibc.expenditure_type
111: , ibc.expenditure_category_flag
112: , nvl(ibc.line_item_cost,0)+nvl(igw_budget_integration.get_eb_cost_ss(ibc.line_item_id),0) direct_cost
113: , ibc.line_item_cost
114: , igw_budget_integration.get_oh_cost_ss(ibc.line_item_id) indirect_cost
115: , ibp.start_date
116: , ibp.end_date
117: FROM igw_budgets ib
118: , igw_budget_periods ibp
154:
155:
156: cursor c_budget_indirect_cost is
157: SELECT ibc.budget_period_id
158: , sum(igw_budget_integration.get_oh_cost_ss(ibc.line_item_id)) indirect_cost
159: FROM igw_budgets ib
160: , igw_budget_periods ibp
161: , igw_budget_details ibc
162: WHERE ib.proposal_id = ibp.proposal_id