APPS.PAY_PAYSUDAP_PKG dependencies on PAY_ACCRUAL_BANDS

Line 15: from pay_accrual_bands

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

Line 58: from pay_accrual_bands

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)