11: l_comb_exists VARCHAR2(2);
12: --
13: CURSOR dup_rec IS
14: select 'Y'
15: from pay_accrual_bands
16: where (p_lower_limit between lower_limit and upper_limit
17: or
18: p_upper_limit between lower_limit and upper_limit
19: or
54: l_record_exists VARCHAR2(2);
55: --
56: CURSOR dup_rec IS
57: select 'Y'
58: from pay_accrual_bands
59: where accrual_plan_id = p_accrual_plan_id
60: and (p_accrual_band_id is null
61: or p_accrual_band_id is not null
62: and accrual_band_id <> p_accrual_band_id)