APPS.BEN_PZR_BUS dependencies on BEN_PSTL_ZIP_RT_F

Line 135: from ben_pstl_zip_rt_f

131: --
132:
133: cursor c3 is
134: select null
135: from ben_pstl_zip_rt_f
136: where pstl_zip_rng_id = p_pstl_zip_rng_id
137: and vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
138: and pstl_zip_rt_id <> nvl(p_pstl_zip_rt_id,hr_api.g_number)
139: and business_group_id + 0 = p_business_group_id

Line 234: from ben_pstl_zip_rt_f

230: is
231: l_proc varchar2(72) := g_package||' chk_duplicate_ordr_num ';
232: l_dummy char(1);
233: cursor c1 is select null
234: from ben_pstl_zip_rt_f
235: where vrbl_rt_prfl_id = p_vrbl_rt_prfl_id
236: and pstl_zip_rt_id <> nvl(p_pstl_zip_rt_id,-1)
237: and p_effective_date between effective_start_date
238: and effective_end_date

Line 693: ben_pstl_zip_rt_f b

689: --
690: cursor csr_leg_code is
691: select a.legislation_code
692: from per_business_groups a,
693: ben_pstl_zip_rt_f b
694: where b.pstl_zip_rt_id = p_pstl_zip_rt_id
695: and a.business_group_id = b.business_group_id;
696: --
697: -- Declare local variables