APPS.BEN_DPC_BUS dependencies on BEN_DPNT_CVRD_ANTHR_PL_CVG_F

Line 259: cursor c1 is select null from ben_dpnt_cvrd_anthr_pl_cvg_f

255: l_proc varchar2(72) := g_package||'chk_duplicate_rows';
256: l_api_updating boolean;
257:
258: dummy varchar2(1);
259: cursor c1 is select null from ben_dpnt_cvrd_anthr_pl_cvg_f
260: where (dpnt_cvrd_anthr_pl_cvg_id <> p_dpnt_cvrd_anthr_pl_cvg_id or p_dpnt_cvrd_anthr_pl_cvg_id is null) and
261: dpnt_cvg_eligy_prfl_id = p_dpnt_cvg_eligy_prfl_id and
262: pl_id = p_pl_id and
263: business_group_id = p_business_group_id and

Line 326: from ben_dpnt_cvrd_anthr_pl_cvg_f

322: is
323: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
324: l_dummy char(1);
325: cursor c1 is select null
326: from ben_dpnt_cvrd_anthr_pl_cvg_f
327: where dpnt_cvg_eligy_prfl_id = p_dpnt_cvg_eligy_prfl_id
328: and dpnt_cvrd_anthr_pl_cvg_id <> nvl(p_dpnt_cvrd_anthr_pl_cvg_id,-1)
329: and p_validation_start_date <= effective_end_date
330: and p_validation_end_date >= effective_start_date

Line 727: ben_dpnt_cvrd_anthr_pl_cvg_f b

723: --
724: cursor csr_leg_code is
725: select a.legislation_code
726: from per_business_groups a,
727: ben_dpnt_cvrd_anthr_pl_cvg_f b
728: where b.dpnt_cvrd_anthr_pl_cvg_id = p_dpnt_cvrd_anthr_pl_cvg_id
729: and a.business_group_id = b.business_group_id;
730: --
731: -- Declare local variables