APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_PTNL_LER_FOR_PER

Line 533: -- This is procedure to delete orphan records from BEN_PTNL_LER_FOR_PER

529: -- ----------------------------------------------------------------------------
530: -- |-------------------------< delete_ptnl_ler_for_per >--------------------------|
531: -- ----------------------------------------------------------------------------
532: --
533: -- This is procedure to delete orphan records from BEN_PTNL_LER_FOR_PER
534: -- where deleted person_id is directly referenced.
535: --
536: procedure delete_ptnl_ler_for_per
537: is

Line 547: DELETE /*+ PARALLEL(A) */FROM ben_ptnl_ler_for_per a

543: --
544: hr_utility.set_location ('Entering ' || l_proc, 5);
545: --
546: --
547: DELETE /*+ PARALLEL(A) */FROM ben_ptnl_ler_for_per a
548: WHERE a.person_id IS NOT NULL
549: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
550: FROM per_all_people_f per);
551: ben_batch_utils.write(p_text => 'BEN_PTNL_LER_FOR_PER : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

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

547: DELETE /*+ PARALLEL(A) */FROM ben_ptnl_ler_for_per a
548: WHERE a.person_id IS NOT NULL
549: AND a.person_id NOT IN (SELECT /*+ HASH_AJ INDEX_FFS(PER) PARALLEL_INDEX(PER) */ person_id
550: FROM per_all_people_f per);
551: ben_batch_utils.write(p_text => 'BEN_PTNL_LER_FOR_PER : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
552: --
553: hr_utility.set_location ('Leaving ' || l_proc, 10);
554: --
555: end delete_ptnl_ler_for_per;