DBA Data[Home] [Help]

APPS.BEN_PET_BUS dependencies on BEN_ENRT_PERD

Line 215: from ben_enrt_perd enp

211: l_dummy varchar2(1);
212: --
213: cursor c1 is
214: select null
215: from ben_enrt_perd enp
216: where enp.popl_enrt_typ_cycl_id = p_popl_enrt_typ_cycl_id;
217: --
218: Begin
219: --

Line 223: -- check if child rows exists in ben_enrt_perd.

219: --
220: hr_utility.set_location('Entering:'||l_proc,5);
221: --
222: --
223: -- check if child rows exists in ben_enrt_perd.
224: --
225: open c1;
226: --
227: fetch c1 into l_dummy;

Line 436: l_table_name := 'ben_enrt_perd';

432: p_argument => 'popl_enrt_typ_cycl_id',
433: p_argument_value => p_popl_enrt_typ_cycl_id);
434: --
435: If (enp_rows_exists(p_popl_enrt_typ_cycl_id => p_popl_enrt_typ_cycl_id)) then
436: l_table_name := 'ben_enrt_perd';
437: Raise l_rows_exist;
438: End If;
439: --
440: If (dt_api.rows_exist