[Home] [Help]
182: l_proc varchar2(72) := g_package||'chk_duplicate_rows';
183: l_api_updating boolean;
184: dummy varchar2(1);
185: -- Bug 3297243
186: cursor c1 is select null from ben_pstl_zip_rng_f
187: where (pstl_zip_rng_id <> p_pstl_zip_rng_id or p_pstl_zip_rng_id is null) and
188: from_value = p_from_value and
189: (to_value = p_to_value or to_value is null) and
190: business_group_id = p_business_group_id and
583: --
584: cursor csr_leg_code is
585: select a.legislation_code
586: from per_business_groups a,
587: ben_pstl_zip_rng_f b
588: where b.pstl_zip_rng_id = p_pstl_zip_rng_id
589: and a.business_group_id = b.business_group_id;
590: --
591: -- Declare local variables