266: l_dummy varchar2(1);
267: --
268: cursor c1 is
269: select null
270: from ben_pymt_sched_py_freq a
271: where a.acty_rt_pymt_sched_id = p_acty_rt_pymt_sched_id;
272: --
273: Begin
274: --
274: --
275: hr_utility.set_location('Entering:'||l_proc,5);
276: --
277: --
278: -- check if child rows exists in ben_pymt_sched_py_freq.
279: --
280: open c1;
281: --
282: fetch c1 into l_dummy;
481: p_argument => 'acty_rt_pymt_sched_id',
482: p_argument_value => p_acty_rt_pymt_sched_id);
483: --
484: If (psq_rows_exists(p_acty_rt_pymt_sched_id => p_acty_rt_pymt_sched_id)) Then
485: l_table_name := 'ben_pymt_sched_py_freq';
486: Raise l_rows_exist;
487: End If;
488: --
489: --