APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_LE_CLSN_N_RSTR

Line 331: -- This is procedure to delete orphan records from BEN_LE_CLSN_N_RSTR

327: -- ----------------------------------------------------------------------------
328: -- |-------------------------< delete_le_clsn_n_rstr >--------------------------|
329: -- ----------------------------------------------------------------------------
330: --
331: -- This is procedure to delete orphan records from BEN_LE_CLSN_N_RSTR
332: -- where deleted person_id is directly referenced.
333: --
334: procedure delete_le_clsn_n_rstr
335: is

Line 345: DELETE /*+ PARALLEL(A) */FROM ben_le_clsn_n_rstr a

341: --
342: hr_utility.set_location ('Entering ' || l_proc, 5);
343: --
344: --
345: DELETE /*+ PARALLEL(A) */FROM ben_le_clsn_n_rstr a
346: WHERE a.person_id IS NOT NULL
347: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
348: FROM per_all_people_f per);
349: ben_batch_utils.write(p_text => 'BEN_LE_CLSN_N_RSTR : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

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

345: DELETE /*+ PARALLEL(A) */FROM ben_le_clsn_n_rstr a
346: WHERE a.person_id IS NOT NULL
347: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
348: FROM per_all_people_f per);
349: ben_batch_utils.write(p_text => 'BEN_LE_CLSN_N_RSTR : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
350: --
351: hr_utility.set_location ('Leaving ' || l_proc, 10);
352: --
353: end delete_le_clsn_n_rstr;