870:
871: CURSOR lc_get_absences (p_person_id IN per_people_f.person_id%TYPE)
872: IS
873: SELECT count(att.absence_attendance_id) total_number_of_absences
874: FROM per_absence_attendances att
875: WHERE att.person_id = p_person_id;
876:
877: BEGIN
878:
911:
912: CURSOR lc_get_absences (p_person_id IN per_people_f.person_id%TYPE)
913: IS
914: SELECT sum(NVL(att.absence_days,0)) total_absence_days
915: FROM per_absence_attendances att
916: WHERE att.person_id = p_person_id;
917:
918: BEGIN
919: OPEN lc_get_absences(p_person_id => p_person_id);
951:
952: CURSOR lc_get_absences (p_person_id IN per_people_f.person_id%TYPE)
953: IS
954: SELECT sum(NVL(att.absence_hours,0)) total_absence_hours
955: FROM per_absence_attendances att
956: WHERE att.person_id = p_person_id;
957:
958: BEGIN
959: OPEN lc_get_absences(p_person_id => p_person_id);