APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_PER_DLVRY_MTHD_F

Line 415: -- This is procedure to delete orphan records from BEN_PER_DLVRY_MTHD_F

411: -- ----------------------------------------------------------------------------
412: -- |-------------------------< delete_per_dlvry_mthd_f >--------------------------|
413: -- ----------------------------------------------------------------------------
414: --
415: -- This is procedure to delete orphan records from BEN_PER_DLVRY_MTHD_F
416: -- where deleted person_id is directly referenced.
417: --
418: procedure delete_per_dlvry_mthd_f
419: is

Line 429: DELETE FROM ben_per_dlvry_mthd_f a

425: --
426: hr_utility.set_location ('Entering ' || l_proc, 5);
427: --
428: --
429: DELETE FROM ben_per_dlvry_mthd_f a
430: WHERE NOT EXISTS (SELECT 1
431: FROM per_all_people_f per
432: WHERE per.person_id = a.person_id);
433: ben_batch_utils.write(p_text => 'BEN_PER_DLVRY_MTHD_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

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

429: DELETE FROM ben_per_dlvry_mthd_f a
430: WHERE NOT EXISTS (SELECT 1
431: FROM per_all_people_f per
432: WHERE per.person_id = a.person_id);
433: ben_batch_utils.write(p_text => 'BEN_PER_DLVRY_MTHD_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
434: --
435: hr_utility.set_location ('Leaving ' || l_proc, 10);
436: --
437: end delete_per_dlvry_mthd_f;