DBA Data[Home] [Help]

APPS.IGW_BUDGETS_PVT dependencies on IGW_BUDGET_INTEGRATION

Line 112: , nvl(ibc.line_item_cost,0)+nvl(igw_budget_integration.get_eb_cost_ss(ibc.line_item_id),0) direct_cost

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

Line 114: , igw_budget_integration.get_oh_cost_ss(ibc.line_item_id) indirect_cost

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

Line 158: , sum(igw_budget_integration.get_oh_cost_ss(ibc.line_item_id)) indirect_cost

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