APPS.BEN_DCP_BUS dependencies on BEN_DPNT_CVRD_PLIP_RT_F

Line 270: from ben_dpnt_cvrd_plip_rt_f

266: l_exists varchar2(1);
267: --
268: cursor c_dup is
269: select null
270: from ben_dpnt_cvrd_plip_rt_f
271: where plip_id = p_plip_id
272: and enrl_det_dt_cd = p_enrl_det_dt_cd
273: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
274: and dpnt_cvrd_plip_rt_id <> nvl(p_dpnt_cvrd_plip_rt_id,hr_api.g_number)

Line 354: from ben_dpnt_cvrd_plip_rt_f

350: is
351: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
352: l_dummy char(1);
353: cursor c1 is select null
354: from ben_dpnt_cvrd_plip_rt_f
355: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
356: and dpnt_cvrd_plip_rt_id <> nvl(p_dpnt_cvrd_plip_rt_id ,-1)
357: -- changed against bug: 5113011
358: -- and plip_id <> nvl(p_plip_id ,-1)

Line 765: ben_dpnt_cvrd_plip_rt_f b

761: --
762: cursor csr_leg_code is
763: select a.legislation_code
764: from per_business_groups a,
765: ben_dpnt_cvrd_plip_rt_f b
766: where b.dpnt_cvrd_plip_rt_id = p_dpnt_cvrd_plip_rt_id
767: and a.business_group_id = b.business_group_id;
768: --
769: -- Declare local variables