APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_CRT_ORDR_CVRD_PER

Line 162: -- This is procedure to delete orphan records from BEN_CRT_ORDR_CVRD_PER

158: -- ----------------------------------------------------------------------------
159: -- |-------------------------< delete_crt_ordr_cvrd_per >--------------------------|
160: -- ----------------------------------------------------------------------------
161: --
162: -- This is procedure to delete orphan records from BEN_CRT_ORDR_CVRD_PER
163: -- where deleted person_id is directly referenced.
164: --
165: procedure delete_crt_ordr_cvrd_per
166: is

Line 176: DELETE FROM ben_crt_ordr_cvrd_per a

172: --
173: hr_utility.set_location ('Entering ' || l_proc, 5);
174: --
175: --
176: DELETE FROM ben_crt_ordr_cvrd_per a
177: WHERE NOT EXISTS (SELECT 1
178: FROM per_all_people_f per
179: WHERE per.person_id = a.person_id);
180: ben_batch_utils.write(p_text => 'BEN_CRT_ORDR_CVRD_PER : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

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

176: DELETE FROM ben_crt_ordr_cvrd_per a
177: WHERE NOT EXISTS (SELECT 1
178: FROM per_all_people_f per
179: WHERE per.person_id = a.person_id);
180: ben_batch_utils.write(p_text => 'BEN_CRT_ORDR_CVRD_PER : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
181: --
182: hr_utility.set_location ('Leaving ' || l_proc, 10);
183: --
184: end delete_crt_ordr_cvrd_per;