APPS.PER_GB_ABSENCE_RULES dependencies on PER_ABSENCE_ATTENDANCES

Line 22: from per_absence_attendances abs, per_absence_attendance_types paat

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

Line 77: per_absence_attendances paa

73: --
74: CURSOR get_abs_category IS
75: SELECT paat.absence_category
76: FROM per_absence_attendance_types paat,
77: per_absence_attendances paa
78: WHERE paa.absence_attendance_id = p_absence_attendance_id
79: AND paa.absence_attendance_type_id = paat.absence_attendance_type_id;
80: --
81: l_abs_category per_absence_attendance_types.absence_category%TYPE;

Line 141: FROM per_absence_attendances PAA

137:
138: CURSOR csr_absences
139: IS
140: SELECT 1
141: FROM per_absence_attendances PAA
142: WHERE PAA.person_id = p_person_id
143: and PAA.business_group_id = p_business_group_id
144: AND PAA.sickness_start_date is not null
145: AND p_date_start < (select max(ABS.sickness_start_date)

Line 146: from per_absence_attendances ABS

142: WHERE PAA.person_id = p_person_id
143: and PAA.business_group_id = p_business_group_id
144: AND PAA.sickness_start_date is not null
145: AND p_date_start < (select max(ABS.sickness_start_date)
146: from per_absence_attendances ABS
147: where ABS.business_group_id = p_business_group_id
148: and ABS.person_id = p_person_id);
149:
150: l_absence NUMBER;

Line 214: from per_absence_attendances

210: sickness_end_date
211: --7287548 begin
212: ,date_start,time_start,date_end,time_end
213: --7287548 End
214: from per_absence_attendances
215: where absence_attendance_id = p_absence_attendance_id;
216:
217: CURSOR get_abs_category(p_abs_type_id number,
218: p_bus_group number) IS

Line 228: FROM per_absence_attendances PAA

224: CURSOR csr_absences(p_person_id number,
225: p_business_group_id number,
226: p_start date)IS
227: SELECT 1
228: FROM per_absence_attendances PAA
229: WHERE PAA.person_id = p_person_id
230: and PAA.business_group_id = p_business_group_id
231: AND PAA.sickness_start_date is not null
232: AND PAA.sickness_start_date > p_start

Line 375: per_absence_attendances paa

371:
372: CURSOR get_abs_category IS
373: SELECT paat.absence_category
374: FROM per_absence_attendance_types paat,
375: per_absence_attendances paa
376: WHERE paa.absence_attendance_id = p_absence_attendance_id
377: AND paa.absence_attendance_type_id = paat.absence_attendance_type_id;
378:
379:

Line 382: FROM per_absence_attendances PAA

378:
379:
380: CURSOR csr_absences IS
381: SELECT 1
382: FROM per_absence_attendances PAA
383: WHERE PAA.absence_attendance_id = p_absence_attendance_id
384: AND PAA.sickness_start_date is not null
385: AND PAA.sickness_start_date < (select max(ABS.sickness_start_date)
386: from per_absence_attendances ABS

Line 386: from per_absence_attendances ABS

382: FROM per_absence_attendances PAA
383: WHERE PAA.absence_attendance_id = p_absence_attendance_id
384: AND PAA.sickness_start_date is not null
385: AND PAA.sickness_start_date < (select max(ABS.sickness_start_date)
386: from per_absence_attendances ABS
387: where ABS.person_id =PAA.person_id);
388:
389: l_absence NUMBER;
390: l_abs_category per_absence_attendance_types.absence_category%TYPE;