APPS.PER_MLS_MIGRATION dependencies on PER_QUALIFICATION_TYPES

Line 766: delete from per_qualification_types_tl

762: ** Clear out any existing data for this range of records
763: **
764: ** Don't delete just yet.
765: **
766: delete from per_qualification_types_tl
767: where qualification_type_id between p_start_pkid
768: and p_end_pkid;
769: */
770:

Line 787: insert into per_qualification_types_tl(

783:
784: /*
785: ** Insert the TL rows.
786: */
787: insert into per_qualification_types_tl(
788: qualification_type_id,
789: language,
790: source_lang,
791: name,

Line 806: from per_qualification_types q

802: q.creation_date,
803: q.last_updated_by,
804: q.last_update_date,
805: q.last_update_login
806: from per_qualification_types q
807: where q.qualification_type_id between p_start_pkid
808: and p_end_pkid
809: and not exists (select '1'
810: from per_qualification_types_tl qtl

Line 810: from per_qualification_types_tl qtl

806: from per_qualification_types q
807: where q.qualification_type_id between p_start_pkid
808: and p_end_pkid
809: and not exists (select '1'
810: from per_qualification_types_tl qtl
811: where qtl.qualification_type_id = q.qualification_type_id
812: and qtl.language = l_current_language);
813:
814: l_rows_processed := l_rows_processed + SQL%ROWCOUNT;