320: -- Cursor to obtain the list of base and installed languages
321: --
322: cursor csr_ins_langs is
323: select l.language_code 324: from fnd_languages l 325: where l.installed_flag in ('I','B')
326: and not exists (select null
327: from per_abs_attendance_types_tl abt
328: where abt.absence_attendance_type_id = p_absence_attendance_type_id