APPS.PER_ABS_BUS dependencies on FND_NUMBER

Line 98: -- select /*+ leading(PAA) */ nvl(fnd_number.canonical_to_number(pev.screen_entry_value), 0),

94: from per_absence_attendance_types abt
95: where abt.absence_attendance_type_id = p_absence_attendance_type_id;
96:
97: cursor c_get_upload_elements is
98: -- select /*+ leading(PAA) */ nvl(fnd_number.canonical_to_number(pev.screen_entry_value), 0),
99: select nvl(fnd_number.canonical_to_number(pev.screen_entry_value), 0), -- bug 7579341, hint removed
100: pev.effective_start_date,
101: pev.effective_end_date
102: from pay_element_entry_values_f pev,

Line 99: select nvl(fnd_number.canonical_to_number(pev.screen_entry_value), 0), -- bug 7579341, hint removed

95: where abt.absence_attendance_type_id = p_absence_attendance_type_id;
96:
97: cursor c_get_upload_elements is
98: -- select /*+ leading(PAA) */ nvl(fnd_number.canonical_to_number(pev.screen_entry_value), 0),
99: select nvl(fnd_number.canonical_to_number(pev.screen_entry_value), 0), -- bug 7579341, hint removed
100: pev.effective_start_date,
101: pev.effective_end_date
102: from pay_element_entry_values_f pev,
103: pay_element_entries_f pee,

Line 1407: p_absence_hours := round(fnd_number.canonical_to_number(l_outputs(i_output).value),2);

1403: -- is returned in hours.
1404: --
1405: if l_hours_or_days = 'H'
1406: or (p_time_start is not null and p_time_end is not null) then
1407: p_absence_hours := round(fnd_number.canonical_to_number(l_outputs(i_output).value),2);
1408: else
1409: p_absence_days := round(fnd_number.canonical_to_number(l_outputs(i_output).value),2);
1410: end if;
1411: end if;

Line 1409: p_absence_days := round(fnd_number.canonical_to_number(l_outputs(i_output).value),2);

1405: if l_hours_or_days = 'H'
1406: or (p_time_start is not null and p_time_end is not null) then
1407: p_absence_hours := round(fnd_number.canonical_to_number(l_outputs(i_output).value),2);
1408: else
1409: p_absence_days := round(fnd_number.canonical_to_number(l_outputs(i_output).value),2);
1410: end if;
1411: end if;
1412:
1413: elsif l_outputs(i_output).name = 'INVALID_MSG' then