APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_EXT_RSLT_DTL

Line 274: -- This is procedure to delete orphan records from BEN_EXT_RSLT_DTL

270: -- ----------------------------------------------------------------------------
271: -- |-------------------------< delete_ext_rslt_dtl >--------------------------|
272: -- ----------------------------------------------------------------------------
273: --
274: -- This is procedure to delete orphan records from BEN_EXT_RSLT_DTL
275: -- where deleted person_id is directly referenced.
276: --
277: procedure delete_ext_rslt_dtl
278: is

Line 288: DELETE /*+ PARALLEL(A) */FROM ben_ext_rslt_dtl a

284: --
285: hr_utility.set_location ('Entering ' || l_proc, 5);
286: --
287: --
288: DELETE /*+ PARALLEL(A) */FROM ben_ext_rslt_dtl a
289: WHERE a.person_id IS NOT NULL
290: AND a.person_id NOT IN (0, 999999999999)
291: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
292: FROM per_all_people_f per);

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

289: WHERE a.person_id IS NOT NULL
290: AND a.person_id NOT IN (0, 999999999999)
291: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
292: FROM per_all_people_f per);
293: ben_batch_utils.write(p_text => 'BEN_EXT_RSLT_DTL : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
294: --
295: hr_utility.set_location ('Leaving ' || l_proc, 10);
296: --
297: end delete_ext_rslt_dtl;