APPS.PER_MLS_MIGRATION dependencies on PER_QUALIFICATIONS

Line 562: delete from per_qualifications_tl

558: ** Clear out any existing data for this range of records
559: **
560: ** Don't delete just yet.
561: **
562: delete from per_qualifications_tl
563: where qualification_id between p_start_pkid
564: and p_end_pkid;
565: */
566:

Line 583: insert into per_qualifications_tl(

579:
580: /*
581: ** Insert the TL rows.
582: */
583: insert into per_qualifications_tl(
584: qualification_id,
585: language,
586: source_lang,
587: title,

Line 616: from per_qualifications q

612: q.creation_date,
613: q.last_updated_by,
614: q.last_update_date,
615: q.last_update_login
616: from per_qualifications q
617: where q.qualification_id between p_start_pkid
618: and p_end_pkid
619: and not exists (select '1'
620: from per_qualifications_tl qtl

Line 620: from per_qualifications_tl qtl

616: from per_qualifications q
617: where q.qualification_id between p_start_pkid
618: and p_end_pkid
619: and not exists (select '1'
620: from per_qualifications_tl qtl
621: where qtl.qualification_id = q.qualification_id
622: and qtl.language = l_current_language);
623:
624: l_rows_processed := l_rows_processed + SQL%ROWCOUNT;