DBA Data[Home] [Help]

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: pev.effective_start_date,
100: pev.effective_end_date
101: from pay_element_entry_values_f pev,
102: pay_element_entries_f pee,

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

1216: -- is returned in hours.
1217: --
1218: if l_hours_or_days = 'H'
1219: or (p_time_start is not null and p_time_end is not null) then
1220: p_absence_hours := round(fnd_number.canonical_to_number(l_outputs(i_output).value),2);
1221: else
1222: p_absence_days := round(fnd_number.canonical_to_number(l_outputs(i_output).value),2);
1223: end if;
1224: end if;

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

1218: if l_hours_or_days = 'H'
1219: or (p_time_start is not null and p_time_end is not null) then
1220: p_absence_hours := round(fnd_number.canonical_to_number(l_outputs(i_output).value),2);
1221: else
1222: p_absence_days := round(fnd_number.canonical_to_number(l_outputs(i_output).value),2);
1223: end if;
1224: end if;
1225:
1226: elsif l_outputs(i_output).name = 'INVALID_MSG' then