APPS.PER_MLS_MIGRATION dependencies on PER_SUBJECTS_TAKEN

Line 671: delete from per_subjects_taken_tl

667: ** Clear out any existing data for this range of records
668: **
669: ** Don't delete just yet.
670: **
671: delete from per_subjects_taken_tl
672: where subjects_taken_id between p_start_pkid
673: and p_end_pkid;
674: */
675:

Line 692: insert into per_subjects_taken_tl(

688:
689: /*
690: ** Insert the TL rows.
691: */
692: insert into per_subjects_taken_tl(
693: subjects_taken_id,
694: language,
695: source_lang,
696: grade_attained,

Line 711: from per_subjects_taken s

707: s.creation_date,
708: s.last_updated_by,
709: s.last_update_date,
710: s.last_update_login
711: from per_subjects_taken s
712: where s.subjects_taken_id between p_start_pkid
713: and p_end_pkid
714: and not exists (select '1'
715: from per_subjects_taken_tl stl

Line 715: from per_subjects_taken_tl stl

711: from per_subjects_taken s
712: where s.subjects_taken_id between p_start_pkid
713: and p_end_pkid
714: and not exists (select '1'
715: from per_subjects_taken_tl stl
716: where stl.subjects_taken_id = s.subjects_taken_id
717: and stl.language = l_current_language);
718:
719: l_rows_processed := l_rows_processed + SQL%ROWCOUNT;