APPS.PER_MLS_MIGRATION dependencies on PER_GRADES

Line 152: delete from per_grades_tl

148: ** Clear out any existing data for this range of records
149: **
150: ** Don't delete just yet.
151: **
152: delete from per_grades_tl
153: where grade_id between p_start_pkid
154: and p_end_pkid;
155: */
156:

Line 178: insert into per_grades_tl(

174:
175: /*
176: ** Insert the TL rows.
177: */
178: insert into per_grades_tl(
179: grade_id,
180: language,
181: source_lang,
182: name,

Line 200: from per_grades g,

196: g.creation_date,
197: g.last_updated_by,
198: g.last_update_date,
199: g.last_update_login
200: from per_grades g,
201: per_grade_definitions gd
202: where g.grade_definition_id = gd.grade_definition_id
203: and g.grade_id between p_start_pkid
204: and p_end_pkid

Line 206: from per_grades_tl gtl

202: where g.grade_definition_id = gd.grade_definition_id
203: and g.grade_id between p_start_pkid
204: and p_end_pkid
205: and not exists (select '1'
206: from per_grades_tl gtl
207: where gtl.grade_id = g.grade_id
208: and gtl.language = l_current_language);
209:
210: l_rows_processed := l_rows_processed + SQL%ROWCOUNT;