963: --
964: -- Description:
965: -- Checks if deletion of the absence type will be allowed.
966: -- Must be no records referencing absence type on the following tables.
967: -- per_abs_attendance_reasons, per_absence_attendances
968: --
969: -- Prerequisites:
970: --
971: -- In Arguments:
994: where absence_attendance_type_id = p_absence_attendance_type_id;
995: --
996: cursor csr_reason is
997: select 1
998: from per_abs_attendance_reasons
999: where absence_attendance_type_id = p_absence_attendance_type_id;
1000: --
1001: begin
1002: --