117: l_exists varchar2(1);
118: --
119: cursor c3 is
120: select null
121: from ben_elig_pyrl_prte_f
122: where payroll_id = p_payroll_id
123: and eligy_prfl_id = p_eligy_prfl_id
124: and elig_pyrl_prte_id <> nvl(p_elig_pyrl_prte_id,hr_api.g_number)
125: and business_group_id + 0 = p_business_group_id
296: l_proc varchar2(72) := g_package||'chk_duplicate_ordr_num';
297: l_dummy char(1);
298: cursor c1 is
299: select null
300: from ben_elig_pyrl_prte_f
301: where elig_pyrl_prte_id <> nvl(p_elig_pyrl_prte_id,-1)
302: and eligy_prfl_id = p_eligy_prfl_id
303: and ordr_num = p_ordr_num
304: and business_group_id = p_business_group_id;
667: --
668: cursor csr_leg_code is
669: select a.legislation_code
670: from per_business_groups a,
671: ben_elig_pyrl_prte_f b
672: where b.elig_pyrl_prte_id = p_elig_pyrl_prte_id
673: and a.business_group_id = b.business_group_id;
674: --
675: -- Declare local variables