eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_CWB_PERSON_INFO_PKG dependencies on FND_NUMBER

Line 266: select fnd_number.canonical_to_number(minimum) into l_grd_min_val

262: if g_debug then
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

Line 299: select fnd_number.canonical_to_number(maximum) into l_grd_max_val

295: if g_debug then
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

Line 332: select fnd_number.canonical_to_number(mid_value) into l_grd_mid_point

328: if g_debug then
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

Line 1903: 'NHBGWH',(select normal_hours /decode(fnd_number.canonical_to_number(working_hours), 0, to_number(NULL)

1899: CURSOR csr_fte_fctr
1900: IS
1901: SELECT
1902: decode(g_fte_factor,
1903: 'NHBGWH',(select normal_hours /decode(fnd_number.canonical_to_number(working_hours), 0, to_number(NULL)
1904: ,fnd_number.canonical_to_number(working_hours))
1905: from per_all_assignments_f asg,
1906: per_business_groups bg
1907: where asg.assignment_id = p_assignment_id

Line 1904: ,fnd_number.canonical_to_number(working_hours))

1900: IS
1901: SELECT
1902: decode(g_fte_factor,
1903: 'NHBGWH',(select normal_hours /decode(fnd_number.canonical_to_number(working_hours), 0, to_number(NULL)
1904: ,fnd_number.canonical_to_number(working_hours))
1905: from per_all_assignments_f asg,
1906: per_business_groups bg
1907: where asg.assignment_id = p_assignment_id
1908: and asg.business_group_id = bg.business_group_id