DBA Data[Home] [Help]

APPS.IGW_PROP_COSTS dependencies on IGW_BUDGETS

Line 9: from igw_budget_periods ibp, igw_budgets ib

5: o_annual_cost number;
6: Begin
7: select ibp.total_direct_cost
8: into o_annual_cost
9: from igw_budget_periods ibp, igw_budgets ib
10: where ibp.proposal_id = i_prop_id and
11: ibp.proposal_id = ib.proposal_id and
12: ibp.version_id = ib.version_id and
13: ib.final_version_flag = 'Y' and

Line 30: from igw_budgets

26: o_total_cost number;
27: Begin
28: select total_cost
29: into o_total_cost
30: from igw_budgets
31: where proposal_id = i_prop_id and
32: final_version_flag = 'Y';
33:
34: RETURN o_total_cost;