APPS.PER_ABT_MIGRATION SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 25

    select language_code,
           nls_Language
      from fnd_languages
     where installed_flag in ('I', 'B');

Line: 41

  delete from per_abs_attendance_types_tl t
  where not exists
       (select null
        from per_absence_attendance_types b
        where b.absence_attendance_type_id = t.absence_attendance_type_id
        );

Line: 50

  ** For each installed language insert a new record into the TL table for
  ** each record in the range provided that is present in the base table.
  */
  for c_language in csr_installed_languages loop

    /*
    ** Set language for iteration....
    */
    hr_kflex_utility.set_session_nls_language(c_language.nls_language);

Line: 62

    ** Insert the TL rows.
    */
    insert into per_abs_attendance_types_tl(
        absence_attendance_type_id,
	language,
	source_lang,
	name,
	created_by,
	creation_date,
	last_updated_by,
	last_update_date,
	last_update_login)
    select b.absence_attendance_type_id,
           l_current_language,
	   l_userenv_language_code,
	   b.name,
	   b.created_by,
	   b.creation_date,
	   b.last_updated_by,
	   b.last_update_date,
	   b.last_update_login
      from per_absence_attendance_types b
     where not exists (select '1'
                      from per_abs_attendance_types_tl tl
		      where tl.absence_attendance_type_id = b.absence_attendance_type_id
			  and tl.language = l_current_language);