APPS.BEN_CWB_PERSON_INFO_PKG dependencies on PAY_GRADE_RULES_F

Line 267: from pay_grade_rules_f grdrule

263: hr_utility.set_location('Entering:'|| l_proc, 10);
264: end if;
265: --
266: select fnd_number.canonical_to_number(minimum) into l_grd_min_val
267: from pay_grade_rules_f grdrule
268: where grdrule.rate_id = p_rate_id
269: and grdrule.grade_or_spinal_point_id = p_grade_id
270: and p_effective_date between grdrule.effective_start_date
271: and grdrule.effective_end_date;

Line 300: from pay_grade_rules_f grdrule

296: hr_utility.set_location('Entering:'|| l_proc, 10);
297: end if;
298: --
299: select fnd_number.canonical_to_number(maximum) into l_grd_max_val
300: from pay_grade_rules_f grdrule
301: where grdrule.rate_id = p_rate_id
302: and grdrule.grade_or_spinal_point_id = p_grade_id
303: and p_effective_date between grdrule.effective_start_date
304: and grdrule.effective_end_date;

Line 333: from pay_grade_rules_f grdrule

329: hr_utility.set_location('Entering:'|| l_proc, 10);
330: end if;
331: --
332: select fnd_number.canonical_to_number(mid_value) into l_grd_mid_point
333: from pay_grade_rules_f grdrule
334: where grdrule.rate_id = p_rate_id
335: and grdrule.grade_or_spinal_point_id = p_grade_id
336: and p_effective_date between grdrule.effective_start_date
337: and grdrule.effective_end_date;