118: l_message VARCHAR2(30) := null;
119:
120: cursor c5 is
121: select 'x'
122: from per_absence_attendance_types
123: where absence_attendance_type_id = p_abs_type_id
124: and date_effective <= p_date_start
125: and (nvl(date_end,p_eot) >= p_date_end or
126: p_date_end is null);
172:
173: cursor c1 is
174: select piv.element_type_id,
175: abt.hours_or_days
176: from per_absence_attendance_types abt,
177: pay_input_values_f piv
178: where abt.absence_attendance_type_id = p_abs_type_id
179: and abt.input_value_id = piv.input_value_id
180: and p_date_start between piv.effective_start_date
300:
301: cursor c1 is
302: select 'x'
303: from per_absence_attendances t,
304: per_absence_attendance_types a,
305: per_absence_attendance_types b
306: where t.person_id = p_person_id
307: and p_abs_type_id = a.absence_attendance_type_id
308: and t.absence_attendance_type_id = b.absence_attendance_type_id
301: cursor c1 is
302: select 'x'
303: from per_absence_attendances t,
304: per_absence_attendance_types a,
305: per_absence_attendance_types b
306: where t.person_id = p_person_id
307: and p_abs_type_id = a.absence_attendance_type_id
308: and t.absence_attendance_type_id = b.absence_attendance_type_id
309: and a.absence_category = 'S'
313: --
314: cursor c2 is
315: select 'x'
316: from per_absence_attendances t,
317: per_absence_attendance_types a,
318: per_absence_attendance_types b
319: where t.person_id = p_person_id
320: and p_abs_type_id = b.absence_attendance_type_id
321: and t.absence_attendance_type_id = a.absence_attendance_type_id
314: cursor c2 is
315: select 'x'
316: from per_absence_attendances t,
317: per_absence_attendance_types a,
318: per_absence_attendance_types b
319: where t.person_id = p_person_id
320: and p_abs_type_id = b.absence_attendance_type_id
321: and t.absence_attendance_type_id = a.absence_attendance_type_id
322: and a.absence_category = 'S'
616: l_flag varchar2(30);
617:
618: cursor c1 is
619: select increasing_or_decreasing_flag
620: from per_absence_attendance_types
621: where absence_attendance_type_id = p_abs_type_id;
622:
623: begin
624: --
889: a.hours_or_days,
890: a.increasing_or_decreasing_flag,
891: a.input_value_id
892: FROM pay_input_values_f iv,
893: per_absence_attendance_types a
894: WHERE a.absence_attendance_type_id = p_absence_att_type_id
895: AND a.input_value_id = iv.input_value_id (+);
896: */
897: --
1211: l_dummy varchar2(1);
1212: --
1213: cursor C3 IS
1214: SELECT null
1215: FROM per_absence_attendance_types paat,
1216: per_business_groups_perf pbg
1217: WHERE pbg.business_group_id = l_business_group_id
1218: AND pbg.legislation_code = 'GB'
1219: AND paat.absence_attendance_type_id = p_absence_att_type_id