DBA Data[Home] [Help]

APPS.IGW_BUDGET_PERSONNEL_OH_PVT dependencies on IGW_BUDGET_PERSONNEL_CAL_AMTS

Line 153: FROM igw_budget_personnel_cal_amts

149:
150:
151: BEGIN
152: SELECT 'x' INTO l_dummy
153: FROM igw_budget_personnel_cal_amts
154: WHERE ((budget_personnel_detail_id = p_budget_personnel_detail_id
155: and rate_class_id = p_rate_class_id --bug 2515925
156: and rate_type_id = p_rate_type_id) --bug 2515925
157: OR rowid = p_rowid)

Line 199: update igw_budget_personnel_cal_amts

195: end if;
196:
197: if (NOT FND_API.TO_BOOLEAN (p_validate_only)) then
198:
199: update igw_budget_personnel_cal_amts
200: set apply_rate_flag = nvl(p_apply_rate_flag_oh, apply_rate_flag)
201: , calculated_cost = l_calculated_cost
202: , calculated_cost_sharing = l_calculated_cost_sharing
203: , record_version_number = record_version_number + 1

Line 207: update igw_budget_personnel_cal_amts

203: , record_version_number = record_version_number + 1
204: where budget_personnel_detail_id = p_budget_personnel_detail_id
205: and rate_class_id IN (select rate_class_id from igw_rate_classes where rate_class_type = 'O');
206:
207: update igw_budget_personnel_cal_amts
208: set apply_rate_flag = nvl(p_apply_rate_flag_eb, apply_rate_flag)
209: , calculated_cost = l_calculated_cost
210: , calculated_cost_sharing = l_calculated_cost_sharing
211: , record_version_number = record_version_number + 1