APPS.PAY_NO_ARCHIVE_ABSENCE dependencies on HR_LOC_WORK_SCHEDULE

Line 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);

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

Line 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);

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*/

Line 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);

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);

Line 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);

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: