APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_PER_PIN_F

Line 443: -- This is procedure to delete orphan records from BEN_PER_PIN_F

439: -- ----------------------------------------------------------------------------
440: -- |-------------------------< delete_per_pin_f >--------------------------|
441: -- ----------------------------------------------------------------------------
442: --
443: -- This is procedure to delete orphan records from BEN_PER_PIN_F
444: -- where deleted person_id is directly referenced.
445: --
446: procedure delete_per_pin_f
447: is

Line 457: DELETE FROM ben_per_pin_f a

453: --
454: hr_utility.set_location ('Entering ' || l_proc, 5);
455: --
456: --
457: DELETE FROM ben_per_pin_f a
458: WHERE NOT EXISTS (SELECT 1
459: FROM per_all_people_f per
460: WHERE per.person_id = a.person_id);
461: ben_batch_utils.write(p_text => 'BEN_PER_PIN_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

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

457: DELETE FROM ben_per_pin_f a
458: WHERE NOT EXISTS (SELECT 1
459: FROM per_all_people_f per
460: WHERE per.person_id = a.person_id);
461: ben_batch_utils.write(p_text => 'BEN_PER_PIN_F : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
462: --
463: hr_utility.set_location ('Leaving ' || l_proc, 10);
464: --
465: end delete_per_pin_f;