APPS.BEN_DELETE_ORPHAN_ROWS dependencies on BEN_CRT_ORDR

Line 134: -- This is procedure to delete orphan records from BEN_CRT_ORDR

130: -- ----------------------------------------------------------------------------
131: -- |-------------------------< delete_crt_ordr >--------------------------|
132: -- ----------------------------------------------------------------------------
133: --
134: -- This is procedure to delete orphan records from BEN_CRT_ORDR
135: -- where deleted person_id is directly referenced.
136: --
137: procedure delete_crt_ordr
138: is

Line 148: DELETE FROM ben_crt_ordr a

144: --
145: hr_utility.set_location ('Entering ' || l_proc, 5);
146: --
147: --
148: DELETE FROM ben_crt_ordr a
149: WHERE NOT EXISTS (SELECT 1
150: FROM per_all_people_f per
151: WHERE per.person_id = a.person_id);
152: ben_batch_utils.write(p_text => 'BEN_CRT_ORDR : ' || nvl(to_char(SQL%ROWCOUNT),'0'));

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

148: DELETE FROM ben_crt_ordr a
149: WHERE NOT EXISTS (SELECT 1
150: FROM per_all_people_f per
151: WHERE per.person_id = a.person_id);
152: ben_batch_utils.write(p_text => 'BEN_CRT_ORDR : ' || nvl(to_char(SQL%ROWCOUNT),'0'));
153: --
154: hr_utility.set_location ('Leaving ' || l_proc, 10);
155: --
156: end delete_crt_ordr;

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;