APPS.BEN_DCL_BUS dependencies on BEN_DPNT_CVRD_OTHR_PL_RT_F

Line 130: from ben_dpnt_cvrd_othr_pl_rt_f dcl

126: between pln.effective_start_date and pln.effective_end_date;
127: --
128: cursor c3 is
129: select null
130: from ben_dpnt_cvrd_othr_pl_rt_f dcl
131: where dcl.pl_id = p_pl_id
132: and dcl.vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
133: and dcl.dpnt_cvrd_othr_pl_rt_id <> nvl(p_dpnt_cvrd_othr_pl_rt_id,hr_api.g_number)
134:

Line 376: from ben_dpnt_cvrd_othr_pl_rt_f

372: is
373: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
374: l_dummy char(1);
375: cursor c1 is select null
376: from ben_dpnt_cvrd_othr_pl_rt_f
377: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
378: and dpnt_cvrd_othr_pl_rt_id <> nvl(p_dpnt_cvrd_othr_pl_rt_id ,-1)
379: --and p_effective_date between effective_start_date
380: -- and effective_end_date

Line 783: ben_dpnt_cvrd_othr_pl_rt_f b

779: --
780: cursor csr_leg_code is
781: select a.legislation_code
782: from per_business_groups a,
783: ben_dpnt_cvrd_othr_pl_rt_f b
784: where b.dpnt_cvrd_othr_pl_rt_id = p_dpnt_cvrd_othr_pl_rt_id
785: and a.business_group_id = b.business_group_id;
786: --
787: -- Declare local variables