APPS.IGW_BUDGETS_PVT dependencies on IGW_BUDGET_DETAILS

Line 32: delete from igw_budget_details_cal_amts

28: delete from igw_budget_personnel_details
29: where proposal_id = p_proposal_id
30: and version_id = p_version_id;
31:
32: delete from igw_budget_details_cal_amts
33: where proposal_id = p_proposal_id
34: and version_id = p_version_id;
35:
36: delete from igw_budget_details

Line 36: delete from igw_budget_details

32: delete from igw_budget_details_cal_amts
33: where proposal_id = p_proposal_id
34: and version_id = p_version_id;
35:
36: delete from igw_budget_details
37: where proposal_id = p_proposal_id
38: and version_id = p_version_id;
39:
40: delete from igw_budget_periods

Line 62: delete from igw_budget_details_cal_amts

58: where proposal_id = p_proposal_id
59: and version_id = p_version_id
60: and budget_period_id = p_budget_period_id;
61:
62: delete from igw_budget_details_cal_amts
63: where proposal_id = p_proposal_id
64: and version_id = p_version_id
65: and budget_period_id = p_budget_period_id;
66:

Line 67: delete from igw_budget_details

63: where proposal_id = p_proposal_id
64: and version_id = p_version_id
65: and budget_period_id = p_budget_period_id;
66:
67: delete from igw_budget_details
68: where proposal_id = p_proposal_id
69: and version_id = p_version_id
70: and budget_period_id = p_budget_period_id;
71:

Line 82: delete from igw_budget_details_cal_amts

78:
79: delete from igw_budget_personnel_details
80: where line_item_id = p_line_item_id;
81:
82: delete from igw_budget_details_cal_amts
83: where line_item_id = p_line_item_id;
84:
85: elsif p_delete_level = 'BUDGET_PERSONNEL' then
86:

Line 119: , igw_budget_details ibc

115: , ibp.start_date
116: , ibp.end_date
117: FROM igw_budgets ib
118: , igw_budget_periods ibp
119: , igw_budget_details ibc
120: WHERE ib.proposal_id = ibp.proposal_id
121: AND ib.version_id = ibp.version_id
122: AND ib.final_version_flag = 'Y'
123: AND ibp.proposal_id = ibc.proposal_id

Line 161: , igw_budget_details ibc

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
163: AND ib.version_id = ibp.version_id
164: AND ib.final_version_flag = 'Y'
165: AND ibp.proposal_id = ibc.proposal_id

Line 679: from igw_budget_details

675: l_line_item_id number(15);
676:
677: cursor c_budget_lines is
678: select line_item_id
679: from igw_budget_details
680: where proposal_id = p_proposal_id
681: and version_id = p_version_id;
682: begin
683: x_return_status := 'S';

Line 1253: update igw_budget_details

1249:
1250: x_return_status := l_return_status;
1251:
1252: --updating budget lines for inflation flag with new value
1253: update igw_budget_details
1254: set apply_inflation_flag = p_apply_inflation_setup_rates
1255: where proposal_id = p_proposal_id
1256: and version_id = p_version_id;
1257: