APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_EXT_RSLT_ERR

Line 303: -- This is procedure to delete orphan records from BEN_EXT_RSLT_ERR

299: -- ----------------------------------------------------------------------------
300: -- |-------------------------< delete_ext_rslt_err >--------------------------|
301: -- ----------------------------------------------------------------------------
302: --
303: -- This is procedure to delete orphan records from BEN_EXT_RSLT_ERR
304: -- where deleted person_id is directly referenced.
305: --
306: procedure delete_ext_rslt_err
307: is

Line 317: DELETE /*+ PARALLEL(A) */FROM ben_ext_rslt_err a

313: --
314: hr_utility.set_location ('Entering ' || l_proc, 5);
315: --
316: --
317: DELETE /*+ PARALLEL(A) */FROM ben_ext_rslt_err a
318: WHERE a.person_id IS NOT NULL
319: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
320: FROM per_all_people_f per);
321: ben_batch_utils.write(p_text => 'BEN_EXT_RSLT_ERR : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

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

317: DELETE /*+ PARALLEL(A) */FROM ben_ext_rslt_err a
318: WHERE a.person_id IS NOT NULL
319: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
320: FROM per_all_people_f per);
321: ben_batch_utils.write(p_text => 'BEN_EXT_RSLT_ERR : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
322: --
323: hr_utility.set_location ('Leaving ' || l_proc, 10);
324: --
325: end delete_ext_rslt_err;