APPS.BEN_EPL_BUS dependencies on BEN_ELIG_PSTL_CD_R_RNG_CVG_F

Line 186: cursor c1 is select null from ben_elig_pstl_cd_r_rng_cvg_f

182: l_proc varchar2(72) := g_package||'chk_duplicate_rows';
183: l_api_updating boolean;
184:
185: dummy varchar2(1);
186: cursor c1 is select null from ben_elig_pstl_cd_r_rng_cvg_f
187: where (elig_pstl_cd_r_rng_cvg_id <> p_elig_pstl_cd_r_rng_cvg_id or p_elig_pstl_cd_r_rng_cvg_id is null) and
188: dpnt_cvg_eligy_prfl_id = p_dpnt_cvg_eligy_prfl_id and
189: pstl_zip_rng_id = p_pstl_zip_rng_id and
190: business_group_id = p_business_group_id and

Line 254: from ben_elig_pstl_cd_r_rng_cvg_f

250: is
251: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
252: l_dummy char(1);
253: cursor c1 is select null
254: from ben_elig_pstl_cd_r_rng_cvg_f
255: where dpnt_cvg_eligy_prfl_id = p_dpnt_cvg_eligy_prfl_id
256: and elig_pstl_cd_r_rng_cvg_id <> nvl(p_elig_pstl_cd_r_rng_cvg_id,-1)
257: and p_validation_start_date <= effective_end_date
258: and p_validation_end_date >= effective_start_date

Line 643: ben_elig_pstl_cd_r_rng_cvg_f b

639: --
640: cursor csr_leg_code is
641: select a.legislation_code
642: from per_business_groups a,
643: ben_elig_pstl_cd_r_rng_cvg_f b
644: where b.elig_pstl_cd_r_rng_cvg_id = p_elig_pstl_cd_r_rng_cvg_id
645: and a.business_group_id = b.business_group_id;
646: --
647: -- Declare local variables