APPS.PER_GB_ABSENCE_RULES dependencies on PER_ABSENCE_ATTENDANCES

Line 26: from per_absence_attendances abs, per_absence_attendance_types paat

22:
23: -- 6888892 Changed this cursor, so that the check is based on Absence Categories
24: cursor c_abs_overlap_another is
25: select 1
26: from per_absence_attendances abs, per_absence_attendance_types paat
27: where paat.absence_category = p_absence_category
28: and paat.absence_attendance_type_id = abs.absence_attendance_type_id
29: and abs.person_id = p_person_id
30: and (p_absence_attendance_id is null or

Line 80: from per_absence_attendances abs, per_absence_attendance_types paat

76: ,p_absence_category IN VARCHAR2) IS
77:
78: cursor c_abs_overlap_another is
79: select nvl(abs.time_start,'00:00') start_time, nvl(abs.time_end,'23:59') end_time
80: from per_absence_attendances abs, per_absence_attendance_types paat
81: where paat.absence_category = p_absence_category
82: and paat.absence_attendance_type_id = abs.absence_attendance_type_id
83: and abs.person_id = p_person_id
84: and (p_absence_attendance_id is null or

Line 139: per_absence_attendances paa

135: --
136: CURSOR get_abs_category IS
137: SELECT paat.absence_category
138: FROM per_absence_attendance_types paat,
139: per_absence_attendances paa
140: WHERE paa.absence_attendance_id = p_absence_attendance_id
141: AND paa.absence_attendance_type_id = paat.absence_attendance_type_id;
142: --
143: l_abs_category per_absence_attendance_types.absence_category%TYPE;

Line 203: FROM per_absence_attendances PAA

199:
200: CURSOR csr_absences
201: IS
202: SELECT 1
203: FROM per_absence_attendances PAA
204: WHERE PAA.person_id = p_person_id
205: and PAA.business_group_id = p_business_group_id
206: AND PAA.sickness_start_date is not null
207: AND p_date_start < (select max(ABS.sickness_start_date)

Line 208: from per_absence_attendances ABS

204: WHERE PAA.person_id = p_person_id
205: and PAA.business_group_id = p_business_group_id
206: AND PAA.sickness_start_date is not null
207: AND p_date_start < (select max(ABS.sickness_start_date)
208: from per_absence_attendances ABS
209: where ABS.business_group_id = p_business_group_id
210: and ABS.person_id = p_person_id);
211:
212: l_absence NUMBER;

Line 279: from per_absence_attendances

275: sickness_end_date
276: --7287548 begin
277: ,date_start,time_start,date_end,time_end
278: --7287548 End
279: from per_absence_attendances
280: where absence_attendance_id = p_absence_attendance_id;
281:
282: CURSOR get_abs_category(p_abs_type_id number,
283: p_bus_group number) IS

Line 293: FROM per_absence_attendances PAA

289: CURSOR csr_absences(p_person_id number,
290: p_business_group_id number,
291: p_start date)IS
292: SELECT 1
293: FROM per_absence_attendances PAA
294: WHERE PAA.person_id = p_person_id
295: and PAA.business_group_id = p_business_group_id
296: AND PAA.sickness_start_date is not null
297: AND PAA.sickness_start_date > p_start

Line 480: per_absence_attendances paa

476:
477: CURSOR get_abs_category IS
478: SELECT paat.absence_category
479: FROM per_absence_attendance_types paat,
480: per_absence_attendances paa
481: WHERE paa.absence_attendance_id = p_absence_attendance_id
482: AND paa.absence_attendance_type_id = paat.absence_attendance_type_id;
483:
484:

Line 487: FROM per_absence_attendances PAA

483:
484:
485: CURSOR csr_absences IS
486: SELECT 1
487: FROM per_absence_attendances PAA
488: WHERE PAA.absence_attendance_id = p_absence_attendance_id
489: AND PAA.sickness_start_date is not null
490: AND PAA.sickness_start_date < (select max(ABS.sickness_start_date)
491: from per_absence_attendances ABS

Line 491: from per_absence_attendances ABS

487: FROM per_absence_attendances PAA
488: WHERE PAA.absence_attendance_id = p_absence_attendance_id
489: AND PAA.sickness_start_date is not null
490: AND PAA.sickness_start_date < (select max(ABS.sickness_start_date)
491: from per_absence_attendances ABS
492: where ABS.person_id =PAA.person_id);
493:
494: l_absence NUMBER;
495: l_abs_category per_absence_attendance_types.absence_category%TYPE;