APPS.PAY_FR_SICKNESS_ABSENCE dependencies on PAY_FR_PTO_PKG

Line 401: l_fr_plan_info pay_fr_pto_pkg.g_fr_plan_info;

397: and date_end < p_date_start
398: and date_start >= p_from_date
399: and absence_attendance_type_id = p_absence_attendance_type_id;
400: --
401: l_fr_plan_info pay_fr_pto_pkg.g_fr_plan_info;
402: l_accrual_plan_id number;
403: l_absence_type varchar2(30);
404: l_ent_m number :=0;
405: l_hiredate date;

Line 428: l_fr_plan_info := pay_fr_pto_pkg.get_fr_accrual_plan_info(

424: close csr_get_accrual_plan;
425: hr_utility.set_location('Absence type is : '||l_absence_type,22);
426: --
427: IF l_absence_type = 'FR_ADDITIONAL_HOLIDAY' THEN
428: l_fr_plan_info := pay_fr_pto_pkg.get_fr_accrual_plan_info(
429: p_accrual_plan_id => l_accrual_plan_id
430: ,p_accrual_date => p_date_start );
431: -- Get the hire date
432: -- to get the date range for checking absence

Line 524: l_fr_plan_info pay_fr_pto_pkg.g_fr_plan_info;

520: and date_end < p_date_start
521: and date_start >= p_from_date
522: and absence_attendance_type_id = p_absence_attendance_type_id;
523: --
524: l_fr_plan_info pay_fr_pto_pkg.g_fr_plan_info;
525: l_accrual_plan_id number;
526: l_absence_type varchar2(30);
527: l_person_id number;
528: l_absence_attendance_type_id number;

Line 555: l_fr_plan_info := pay_fr_pto_pkg.get_fr_accrual_plan_info(

551: IF l_absence_type = 'FR_ADDITIONAL_HOLIDAY' THEN
552: hr_utility.set_location('Absence is additional type', 22);
553: hr_utility.set_location('Plan id is : '||to_char(l_accrual_plan_id),22);
554: hr_utility.set_location('Accrual Date is : '||to_char(p_date_start),22);
555: l_fr_plan_info := pay_fr_pto_pkg.get_fr_accrual_plan_info(
556: p_accrual_plan_id => l_accrual_plan_id
557: ,p_accrual_date => p_date_start );
558: -- Get the hire date
559: -- to get the date range for checking absence