APPS.BEN_DCO_BUS dependencies on BEN_DPNT_CVRD_OTHR_PTIP_RT_F

Line 270: from ben_dpnt_cvrd_othr_ptip_rt_f

266: l_exists varchar2(1);
267: --
268: cursor c_dup is
269: select null
270: from ben_dpnt_cvrd_othr_ptip_rt_f
271: where ptip_id = p_ptip_id
272: and enrl_det_dt_cd = p_enrl_det_dt_cd
273: -- and nvl(only_pls_subj_cobra_flag,'N') = p_only_pls_subj_cobra_flag
274: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id

Line 426: from ben_dpnt_cvrd_othr_ptip_rt_f

422: is
423: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
424: l_dummy char(1);
425: cursor c1 is select null
426: from ben_dpnt_cvrd_othr_ptip_rt_f
427: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
428: -- changed against bug: 5113011
429: and dpnt_cvrd_othr_ptip_rt_id <> nvl(p_dpnt_cvrd_othr_ptip_rt_id ,-1)
430: -- and ptip_id <> nvl(p_ptip_id ,-1)

Line 852: ben_dpnt_cvrd_othr_ptip_rt_f b

848: --
849: cursor csr_leg_code is
850: select a.legislation_code
851: from per_business_groups a,
852: ben_dpnt_cvrd_othr_ptip_rt_f b
853: where b.dpnt_cvrd_othr_ptip_rt_id = p_dpnt_cvrd_othr_ptip_rt_id
854: and a.business_group_id = b.business_group_id;
855: --
856: -- Declare local variables