APPS.BEN_CWB_PERSON_INFO_PKG dependencies on PAY_GRADE_RULES_F

Line 260: from pay_grade_rules_f grdrule

256: hr_utility.set_location('Entering:'|| l_proc, 10);
257: end if;
258: --
259: select fnd_number.canonical_to_number(minimum) into l_grd_min_val
260: from pay_grade_rules_f grdrule
261: where grdrule.rate_id = p_rate_id
262: and grdrule.grade_or_spinal_point_id = p_grade_id
263: and p_effective_date between grdrule.effective_start_date
264: and grdrule.effective_end_date;

Line 293: from pay_grade_rules_f grdrule

289: hr_utility.set_location('Entering:'|| l_proc, 10);
290: end if;
291: --
292: select fnd_number.canonical_to_number(maximum) into l_grd_max_val
293: from pay_grade_rules_f grdrule
294: where grdrule.rate_id = p_rate_id
295: and grdrule.grade_or_spinal_point_id = p_grade_id
296: and p_effective_date between grdrule.effective_start_date
297: and grdrule.effective_end_date;

Line 326: from pay_grade_rules_f grdrule

322: hr_utility.set_location('Entering:'|| l_proc, 10);
323: end if;
324: --
325: select fnd_number.canonical_to_number(mid_value) into l_grd_mid_point
326: from pay_grade_rules_f grdrule
327: where grdrule.rate_id = p_rate_id
328: and grdrule.grade_or_spinal_point_id = p_grade_id
329: and p_effective_date between grdrule.effective_start_date
330: and grdrule.effective_end_date;