76: -- SASmith 31-MAR-1998
77:
78: IF (p_organisation_id is null) then
79:
80: hr_utility.set_location ('hrgetact.get_actuals', 5);
81: DECLARE
82: CURSOR C IS
83: SELECT NVL(SUM(ABV.VALUE),0)
84: FROM per_assignment_budget_values_f abv,
112: OPEN C;
113: FETCH C INTO p_actual_start_val;
114: IF (C%NOTFOUND) THEN
115: p_actual_start_val := 0;
116: hr_utility.set_location ('hrgetact.get_actuals', 10);
117: END IF;
118: CLOSE C;
119: END;
120: hr_utility.set_location ('hrgetact.get_actuals', 15);
116: hr_utility.set_location ('hrgetact.get_actuals', 10);
117: END IF;
118: CLOSE C;
119: END;
120: hr_utility.set_location ('hrgetact.get_actuals', 15);
121: --
122: DECLARE
123: CURSOR C2 IS
124: SELECT NVL(SUM(ABV.VALUE),0)
153: OPEN C2;
154: FETCH C2 INTO l_actual_end_val;
155: IF (C2%NOTFOUND) THEN
156: l_actual_end_val := 0;
157: hr_utility.set_location ('hrgetact.get_actuals', 20);
158: END IF;
159: CLOSE C2;
160: END;
161:
159: CLOSE C2;
160: END;
161:
162: ELSE
163: hr_utility.set_location ('hrgetact.get_actuals', 25);
164: DECLARE
165: CURSOR C IS
166: SELECT NVL(SUM(ABV.VALUE),0)
167: FROM per_assignment_budget_values_f abv,
194: OPEN C;
195: FETCH C INTO p_actual_start_val;
196: IF (C%NOTFOUND) THEN
197: p_actual_start_val := 0;
198: hr_utility.set_location ('hrgetact.get_actuals', 30);
199: END IF;
200: CLOSE C;
201: END;
202: --
199: END IF;
200: CLOSE C;
201: END;
202: --
203: hr_utility.set_location ('hrgetact.get_actuals', 35);
204: DECLARE
205: CURSOR C2 IS
206: SELECT NVL(SUM(ABV.VALUE),0)
207: FROM per_assignment_budget_values_f abv,
234: OPEN C2;
235: FETCH C2 INTO l_actual_end_val;
236: IF (C2%NOTFOUND) THEN
237: l_actual_end_val := 0;
238: hr_utility.set_location ('hrgetact.get_actuals', 40);
239: END IF;
240: CLOSE C2;
241: END;
242:
240: CLOSE C2;
241: END;
242:
243: END IF;
244: hr_utility.set_location ('hrgetact.get_actuals',45);
245:
246:
247: --------------------------------------------------------------------
248: