APPS.PER_GB_ABSENCE_RULES dependencies on PER_ABSENCE_ATTENDANCE_TYPES

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 138: FROM per_absence_attendance_types paat,

134: l_proc VARCHAR2(30) ;
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: --

Line 143: l_abs_category per_absence_attendance_types.absence_category%TYPE;

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;
144: --
145: BEGIN
146: --
147: -- Added for GSI Bug 5472781

Line 196: FROM per_absence_attendance_types paat

192: ) IS
193:
194: CURSOR get_abs_category IS
195: SELECT paat.absence_category
196: FROM per_absence_attendance_types paat
197: WHERE paat.absence_attendance_type_id = p_absence_attendance_type_id
198: AND paat.business_group_id = p_business_group_id;
199:
200: CURSOR csr_absences

Line 213: l_abs_category per_absence_attendance_types.absence_category%TYPE;

209: where ABS.business_group_id = p_business_group_id
210: and ABS.person_id = p_person_id);
211:
212: l_absence NUMBER;
213: l_abs_category per_absence_attendance_types.absence_category%TYPE;
214:
215: BEGIN
216: --
217: -- Added for GSI Bug 5472781

Line 285: FROM per_absence_attendance_types paat

281:
282: CURSOR get_abs_category(p_abs_type_id number,
283: p_bus_group number) IS
284: SELECT paat.absence_category
285: FROM per_absence_attendance_types paat
286: WHERE paat.absence_attendance_type_id = p_abs_type_id
287: AND paat.business_group_id = p_bus_group;
288:
289: CURSOR csr_absences(p_person_id number,

Line 307: l_abs_category per_absence_attendance_types.absence_category%TYPE;

303: l_abs_type_id number;
304: l_param_start date;
305: l_current_start date;
306: l_current_end date;
307: l_abs_category per_absence_attendance_types.absence_category%TYPE;
308: --7287548 begin
309: l_date_start date;
310: l_time_start varchar2(5);
311: l_date_end date;

Line 479: FROM per_absence_attendance_types paat,

475:
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:

Line 495: l_abs_category per_absence_attendance_types.absence_category%TYPE;

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;
496:
497: --
498: BEGIN
499: --