DBA Data[Home] [Help]

APPS.PER_MLS_MIGRATION dependencies on HR_ALL_POSITIONS_F_TL

Line 41: delete from hr_all_positions_f_tl

37: ** Clear out any existing data for this range of records
38: **
39: ** Don't delete just yet.
40: **
41: delete from hr_all_positions_f_tl
42: where position_id between p_start_pkid
43: and p_end_pkid;
44: */
45:

Line 67: insert into hr_all_positions_f_tl (

63:
64: /*
65: ** Insert the TL rows.
66: */
67: insert into hr_all_positions_f_tl (
68: position_id,
69: language,
70: source_lang,
71: name,

Line 101: from hr_all_positions_f_tl jtl

97: from hr_all_positions_f pos
98: where pos.position_id = j.position_id)
99: -- Fix for bug 3359423 ends here.
100: and not exists (select '1'
101: from hr_all_positions_f_tl jtl
102: where jtl.position_id = j.position_id
103: and jtl.language = l_current_language);
104:
105: l_rows_processed := l_rows_processed + SQL%ROWCOUNT;