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 259: select fnd_number.canonical_to_number(minimum) into l_grd_min_val

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

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

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

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

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

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

1838: CURSOR csr_fte_fctr
1839: IS
1840: SELECT
1841: decode(g_fte_factor,
1842: 'NHBGWH',(select normal_hours /decode(fnd_number.canonical_to_number(working_hours), 0, to_number(NULL)
1843: ,fnd_number.canonical_to_number(working_hours))
1844: from per_all_assignments_f asg,
1845: per_business_groups bg
1846: where asg.assignment_id = p_assignment_id

Line 1843: ,fnd_number.canonical_to_number(working_hours))

1839: IS
1840: SELECT
1841: decode(g_fte_factor,
1842: 'NHBGWH',(select normal_hours /decode(fnd_number.canonical_to_number(working_hours), 0, to_number(NULL)
1843: ,fnd_number.canonical_to_number(working_hours))
1844: from per_all_assignments_f asg,
1845: per_business_groups bg
1846: where asg.assignment_id = p_assignment_id
1847: and asg.business_group_id = bg.business_group_id