APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_EXT_CHG_EVT_LOG

Line 246: -- This is procedure to delete orphan records from BEN_EXT_CHG_EVT_LOG

242: -- ----------------------------------------------------------------------------
243: -- |-------------------------< delete_ext_chg_evt_log >--------------------------|
244: -- ----------------------------------------------------------------------------
245: --
246: -- This is procedure to delete orphan records from BEN_EXT_CHG_EVT_LOG
247: -- where deleted person_id is directly referenced.
248: --
249: procedure delete_ext_chg_evt_log
250: is

Line 260: DELETE /*+ PARALLEL(A) */FROM ben_ext_chg_evt_log a

256: --
257: hr_utility.set_location ('Entering ' || l_proc, 5);
258: --
259: --
260: DELETE /*+ PARALLEL(A) */FROM ben_ext_chg_evt_log a
261: WHERE a.person_id IS NOT NULL
262: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
263: FROM per_all_people_f per);
264: ben_batch_utils.write(p_text => 'BEN_EXT_CHG_EVT_LOG : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

Line 264: ben_batch_utils.write(p_text => 'BEN_EXT_CHG_EVT_LOG : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

260: DELETE /*+ PARALLEL(A) */FROM ben_ext_chg_evt_log a
261: WHERE a.person_id IS NOT NULL
262: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
263: FROM per_all_people_f per);
264: ben_batch_utils.write(p_text => 'BEN_EXT_CHG_EVT_LOG : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
265: --
266: hr_utility.set_location ('Leaving ' || l_proc, 10);
267: --
268: end delete_ext_chg_evt_log;