APPS.HR_MEE_VIEWS_GEN dependencies on PER_ABSENCE_ATTENDANCES

Line 831: FROM per_absence_attendances att

827:
828: CURSOR lc_get_absences (p_person_id IN per_people_f.person_id%TYPE)
829: IS
830: SELECT count(att.absence_attendance_id) total_number_of_absences
831: FROM per_absence_attendances att
832: WHERE att.person_id = p_person_id;
833:
834: BEGIN
835:

Line 872: FROM per_absence_attendances att

868:
869: CURSOR lc_get_absences (p_person_id IN per_people_f.person_id%TYPE)
870: IS
871: SELECT sum(NVL(att.absence_days,0)) total_absence_days
872: FROM per_absence_attendances att
873: WHERE att.person_id = p_person_id;
874:
875: BEGIN
876: OPEN lc_get_absences(p_person_id => p_person_id);

Line 912: FROM per_absence_attendances att

908:
909: CURSOR lc_get_absences (p_person_id IN per_people_f.person_id%TYPE)
910: IS
911: SELECT sum(NVL(att.absence_hours,0)) total_absence_hours
912: FROM per_absence_attendances att
913: WHERE att.person_id = p_person_id;
914:
915: BEGIN
916: OPEN lc_get_absences(p_person_id => p_person_id);