APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_PER_BNFTS_BAL_F

Line 387: -- This is procedure to delete orphan records from BEN_PER_BNFTS_BAL_F

383: -- ----------------------------------------------------------------------------
384: -- |-------------------------< delete_per_bnfts_bal_f >--------------------------|
385: -- ----------------------------------------------------------------------------
386: --
387: -- This is procedure to delete orphan records from BEN_PER_BNFTS_BAL_F
388: -- where deleted person_id is directly referenced.
389: --
390: procedure delete_per_bnfts_bal_f
391: is

Line 401: DELETE FROM ben_per_bnfts_bal_f a

397: --
398: hr_utility.set_location ('Entering ' || l_proc, 5);
399: --
400: --
401: DELETE FROM ben_per_bnfts_bal_f a
402: WHERE NOT EXISTS (SELECT 1
403: FROM per_all_people_f per
404: WHERE per.person_id = a.person_id);
405: ben_batch_utils.write(p_text => 'BEN_PER_BNFTS_BAL_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

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

401: DELETE FROM ben_per_bnfts_bal_f a
402: WHERE NOT EXISTS (SELECT 1
403: FROM per_all_people_f per
404: WHERE per.person_id = a.person_id);
405: ben_batch_utils.write(p_text => 'BEN_PER_BNFTS_BAL_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
406: --
407: hr_utility.set_location ('Leaving ' || l_proc, 10);
408: --
409: end delete_per_bnfts_bal_f;