APPS.PER_MLS_MIGRATION dependencies on PER_RATING_SCALES

Line 257: delete from per_rating_scales_tl

253: ** Clear out any existing data for this range of records
254: **
255: ** Don't delete just yet.
256: **
257: delete from per_rating_scales_tl
258: where rating_scale_id between p_start_pkid
259: and p_end_pkid;
260: */
261:

Line 278: insert into per_rating_scales_tl(

274:
275: /*
276: ** Insert the TL rows.
277: */
278: insert into per_rating_scales_tl(
279: rating_scale_id,
280: language,
281: source_lang,
282: name,

Line 299: from per_rating_scales r

295: r.creation_date,
296: r.last_updated_by,
297: r.last_update_date,
298: r.last_update_login
299: from per_rating_scales r
300: where r.rating_scale_id between p_start_pkid
301: and p_end_pkid
302: and not exists (select '1'
303: from per_rating_scales_tl rtl

Line 303: from per_rating_scales_tl rtl

299: from per_rating_scales r
300: where r.rating_scale_id between p_start_pkid
301: and p_end_pkid
302: and not exists (select '1'
303: from per_rating_scales_tl rtl
304: where rtl.rating_scale_id = r.rating_scale_id
305: and rtl.language = l_current_language);
306:
307: l_rows_processed := l_rows_processed + SQL%ROWCOUNT;