APPS.BEN_EDP_BUS dependencies on BEN_ELIG_DPNT_CVRD_OTHR_PL_F

Line 130: from ben_elig_dpnt_cvrd_othr_pl_f edp

126: between pln.effective_start_date and pln.effective_end_date;
127: --
128: cursor c3 is
129: select null
130: from ben_elig_dpnt_cvrd_othr_pl_f edp
131: where edp.pl_id = p_pl_id
132: and edp.eligy_prfl_id = p_eligy_prfl_id
133: and edp.elig_dpnt_cvrd_othr_pl_id <> nvl(p_elig_dpnt_cvrd_othr_pl_id,hr_api.g_number)
134:

Line 370: from ben_elig_dpnt_cvrd_othr_pl_f

366: l_proc varchar2(72) := g_package||'chk_duplicate_ordr_num';
367: l_dummy char(1);
368: cursor c1 is
369: select null
370: from ben_elig_dpnt_cvrd_othr_pl_f
371: where elig_dpnt_cvrd_othr_pl_id <> nvl(p_elig_dpnt_cvrd_othr_pl_id,-1)
372: and eligy_prfl_id = p_eligy_prfl_id
373: and ordr_num = p_ordr_num
374: and business_group_id = p_business_group_id;

Line 763: ben_elig_dpnt_cvrd_othr_pl_f b

759: --
760: cursor csr_leg_code is
761: select a.legislation_code
762: from per_business_groups a,
763: ben_elig_dpnt_cvrd_othr_pl_f b
764: where b.elig_dpnt_cvrd_othr_pl_id = p_elig_dpnt_cvrd_othr_pl_id
765: and a.business_group_id = b.business_group_id;
766: --
767: -- Declare local variables