APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_PL_BNF_F

Line 471: -- This is procedure to delete orphan records from BEN_PL_BNF_F

467: -- ----------------------------------------------------------------------------
468: -- |-------------------------< delete_pl_bnf_f >--------------------------|
469: -- ----------------------------------------------------------------------------
470: --
471: -- This is procedure to delete orphan records from BEN_PL_BNF_F
472: -- where deleted person_id is directly referenced.
473: --
474: procedure delete_pl_bnf_f
475: is

Line 485: DELETE FROM ben_pl_bnf_f a

481: --
482: hr_utility.set_location ('Entering ' || l_proc, 5);
483: --
484: --
485: DELETE FROM ben_pl_bnf_f a
486: WHERE NOT EXISTS (
487: SELECT 1
488: FROM per_all_people_f per
489: WHERE per.person_id = a.bnf_person_id

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

487: SELECT 1
488: FROM per_all_people_f per
489: WHERE per.person_id = a.bnf_person_id
490: OR per.person_id = a.ttee_person_id);
491: ben_batch_utils.write(p_text => 'BEN_PL_BNF_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
492: --
493: hr_utility.set_location ('Leaving ' || l_proc, 10);
494: --
495: end delete_pl_bnf_f;