APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_ELIG_PER_F

Line 218: -- This is procedure to delete orphan records from BEN_ELIG_PER_F

214: -- ----------------------------------------------------------------------------
215: -- |-------------------------< delete_elig_per_f >--------------------------|
216: -- ----------------------------------------------------------------------------
217: --
218: -- This is procedure to delete orphan records from BEN_ELIG_PER_F
219: -- where deleted person_id is directly referenced.
220: --
221: procedure delete_elig_per_f
222: is

Line 232: DELETE /*+ PARALLEL(A) */FROM ben_elig_per_f a

228: --
229: hr_utility.set_location ('Entering ' || l_proc, 5);
230: --
231: --
232: DELETE /*+ PARALLEL(A) */FROM ben_elig_per_f a
233: WHERE a.person_id IS NOT NULL
234: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
235: FROM per_all_people_f per);
236: ben_batch_utils.write(p_text => 'BEN_ELIG_PER_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

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

232: DELETE /*+ PARALLEL(A) */FROM ben_elig_per_f a
233: WHERE a.person_id IS NOT NULL
234: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
235: FROM per_all_people_f per);
236: ben_batch_utils.write(p_text => 'BEN_ELIG_PER_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
237: --
238: hr_utility.set_location ('Leaving ' || l_proc, 10);
239: --
240: end delete_elig_per_f;