[Home] [Help]
87: --
88: -- Prorate the records if start date / end date are between the specified dates
89: -- Add all the salary between the specified dates
90: --
91: hr_utility.set_location('Entering get_pc_budgeted_salary' , 100);
92:
93: for l_budget_elements in c_budget_elements
94: loop
95:
113: l_salary := nvl(l_salary,0) + l_temp_bdgt_element_value;
114: --
115: --
116: end loop;
117: hr_utility.set_location('l_salary '||l_salary , 101);
118: --
119: -- Return the Total salary
120: --
121: return(trunc(l_salary,2));
215: l_hours := nvl(l_hours,0) + l_temp_bdgt_period_value;
216: --
217: --
218: end loop;
219: hr_utility.set_location('l_hours '|| l_hours , 101);
220: --
221: -- Return the Total Hours
222: --
223: return(trunc(l_hours,2));
278: open no_periods_tp(p_period_set_name, p_period_start_date, p_period_end_date);
279: fetch no_periods_tp into l_no_total_periods;
280: close no_periods_tp;
281: --
282: hr_utility.set_location('l_no_total_periods = ' || l_no_total_periods, 100);
283: --
284: --
285: -- Fetch the start_date and end_date of the period which contains p_start_date
286: -- and p_end_date from calendar p_period_set_name
305: l_temp_ratio := 1;
306: --
307: end if;
308: --
309: hr_utility.set_location('l_temp_ratio = ' || l_temp_ratio, 110);
310: l_total_ratio := l_total_ratio + l_temp_ratio;
311: end loop;
312: --
313: hr_utility.set_location('l_total_ratio = ' || l_total_ratio, 120);
309: hr_utility.set_location('l_temp_ratio = ' || l_temp_ratio, 110);
310: l_total_ratio := l_total_ratio + l_temp_ratio;
311: end loop;
312: --
313: hr_utility.set_location('l_total_ratio = ' || l_total_ratio, 120);
314: --
315: return((l_total_ratio)/l_no_total_periods);
316: --
317: end;