APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_PERSON_ACTIONS

Line 359: -- This is procedure to delete orphan records from BEN_PERSON_ACTIONS

355: -- ----------------------------------------------------------------------------
356: -- |-------------------------< delete_person_actions >--------------------------|
357: -- ----------------------------------------------------------------------------
358: --
359: -- This is procedure to delete orphan records from BEN_PERSON_ACTIONS
360: -- where deleted person_id is directly referenced.
361: --
362: procedure delete_person_actions
363: is

Line 373: DELETE /*+ PARALLEL(A) */FROM ben_person_actions a

369: --
370: hr_utility.set_location ('Entering ' || l_proc, 5);
371: --
372: --
373: DELETE /*+ PARALLEL(A) */FROM ben_person_actions a
374: WHERE a.person_id IS NOT NULL
375: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
376: FROM per_all_people_f per);
377: ben_batch_utils.write(p_text => 'BEN_PERSON_ACTIONS : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

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

373: DELETE /*+ PARALLEL(A) */FROM ben_person_actions a
374: WHERE a.person_id IS NOT NULL
375: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
376: FROM per_all_people_f per);
377: ben_batch_utils.write(p_text => 'BEN_PERSON_ACTIONS : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
378: --
379: hr_utility.set_location ('Leaving ' || l_proc, 10);
380: --
381: end delete_person_actions;