APPS.BEN_EPZ_BUS dependencies on BEN_ELIG_PSTL_CD_R_RNG_PRTE_F

Line 131: from ben_elig_pstl_cd_r_rng_prte_f

127: nvl(a.effective_end_date, p_effective_date);
128: --
129: cursor c3 is
130: select null
131: from ben_elig_pstl_cd_r_rng_prte_f
132: where pstl_zip_rng_id = p_pstl_zip_rng_id
133: and eligy_prfl_id = p_eligy_prfl_id
134: and elig_pstl_cd_r_rng_prte_id <> nvl(p_elig_pstl_cd_r_rng_prte_id,hr_api.g_number)
135: and business_group_id + 0 = p_business_group_id

Line 301: from ben_elig_pstl_cd_r_rng_prte_f

297: l_proc varchar2(72) := g_package||'chk_duplicate_ordr_num';
298: l_dummy char(1);
299: cursor c1 is
300: select null
301: from ben_elig_pstl_cd_r_rng_prte_f
302: where elig_pstl_cd_r_rng_prte_id <> nvl(p_elig_pstl_cd_r_rng_prte_id,-1)
303: and eligy_prfl_id = p_eligy_prfl_id
304: and ordr_num = p_ordr_num
305: and business_group_id = p_business_group_id;

Line 683: ben_elig_pstl_cd_r_rng_prte_f b

679: --
680: cursor csr_leg_code is
681: select a.legislation_code
682: from per_business_groups a,
683: ben_elig_pstl_cd_r_rng_prte_f b
684: where b.elig_pstl_cd_r_rng_prte_id = p_elig_pstl_cd_r_rng_prte_id
685: and a.business_group_id = b.business_group_id;
686: --
687: -- Declare local variables