APPS.IGW_BUDGETS_PVT dependencies on IGW_BUDGET_PERIODS

Line 40: delete from igw_budget_periods

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
41: where proposal_id = p_proposal_id
42: and version_id = p_version_id;
43:
44: delete from igw_prop_rates

Line 118: , igw_budget_periods ibp

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
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'

Line 142: , igw_budget_periods ibp

138: , ibc.oh_cost indirect_cost
139: , ibp.start_date
140: , ibp.end_date
141: FROM igw_budgets ib
142: , igw_budget_periods ibp
143: , igw_budget_complete_v ibc
144: WHERE ib.proposal_id = ibp.proposal_id
145: AND ib.version_id = ibp.version_id
146: AND ib.final_version_flag = 'Y'

Line 160: , igw_budget_periods ibp

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

Line 179: , igw_budget_periods ibp

175: /*
176: SELECT ibc.budget_period_id
177: , sum(ibc.oh_cost) indirect_cost
178: FROM igw_budgets ib
179: , igw_budget_periods ibp
180: , igw_budget_complete_v ibc
181: WHERE ib.proposal_id = ibp.proposal_id
182: AND ib.version_id = ibp.version_id
183: AND ib.final_version_flag = 'Y'

Line 428: from igw_budget_periods

424: select igw_award_budget_s.nextval into l_award_budget_id from dual;
425:
426: select start_date, end_date
427: into l_start_date, l_end_date
428: from igw_budget_periods
429: where proposal_id = p_proposal_id
430: and version_id = l_version_id
431: and budget_period_id = rec_budget_indirect_cost.budget_period_id;
432:

Line 924: igw_budget_periods_tbh.insert_row(

920: LOOP
921: l_budget_period := nvl(l_budget_period,0) +1;
922:
923: if l_period_end_date < l_end_date then
924: igw_budget_periods_tbh.insert_row(
925: p_proposal_id => p_proposal_id
926: ,p_version_id => l_version_id
927: ,p_budget_period_id => l_budget_period
928: ,p_start_date => l_period_start_date

Line 948: igw_budget_periods_tbh.insert_row(

944: l_period_end_date := add_months(l_period_start_date,12)-1;
945: GOTO PERIOD_LOOP;
946: else
947: l_period_end_date := l_end_date;
948: igw_budget_periods_tbh.insert_row(
949: p_proposal_id => p_proposal_id
950: ,p_version_id => l_version_id
951: ,p_budget_period_id => l_budget_period
952: ,p_start_date => l_period_start_date