476: If csr_abs.quaterstart = csr_abs.quaterend then
477:
478:
479:
480: l_hr_work_schedule:=hr_loc_work_schedule.calc_sch_based_dur(csr_abs.assignment_id,'D','Y',csr_abs.date_start,csr_abs.date_end,'00','23',l_absence_days);
481:
482: l_absence_days := l_absence_days * l_full_time_percentage/100;
483:
484: if csr_abs.absence_category in ('PTS') then
528: End if;
529: elsif qtrs <> 0 then
530: l_qtr_end_date :=trunc(add_months(l_qtr_start_date,3),'Q')-1;
531: end if;
532: l_hr_work_schedule:=hr_loc_work_schedule.calc_sch_based_dur(csr_abs.assignment_id,'D','Y',l_qtr_start_date,l_qtr_end_date,'00','23',l_absence_days);
533: hr_utility.set_location(' ****1111Absence Days : '||l_absence_days||' : '||l_full_time_percentage,5);
534: l_absence_days := l_absence_days * l_full_time_percentage/100;
535:
536: /*Added for Bugs 5409100,5409124*/
585:
586: End if;
587:
588: l_pos_assignment_id := csr_possible_wrk_days1.assignment_id;
589: l_hr_work_schedule:=hr_loc_work_schedule.calc_sch_based_dur(l_pos_assignment_id,'D','Y',l_quater_start,l_quater_end,'00','23',l_possible_working_days);
590: l_total_possible_working_days := nvl(l_total_possible_working_days,0) + (nvl(l_possible_working_days,0)*l_full_time_percentage/100);
591:
592: End loop;
593: hr_utility.trace('Entered l_quater_end ******* '||l_quater_end);
657: l_full_time_percentage:=100;
658:
659: End if;
660: l_pos_assignment_id := csr_possible_wrk_days1.assignment_id;
661: l_hr_work_schedule:=hr_loc_work_schedule.calc_sch_based_dur(l_pos_assignment_id,'D','Y',l_quater_start,l_quater_end,'00','23',l_possible_working_days);
662: l_total_possible_working_days := nvl(l_total_possible_working_days,0) + (nvl(l_possible_working_days,0)*l_full_time_percentage/100);
663:
664: End loop;
665: