DBA Data[Home] [Help]

APPS.PYUDET dependencies on FND_NUMBER

Line 1281: fnd_number.canonical_to_number(uci.value) value

1277: FUNCTION get_uplift_value (p_tax_suffix in varchar2) return NUMBER
1278: IS
1279: cursor c_uplift is
1280: select usr.row_low_range_or_name suffix,
1281: fnd_number.canonical_to_number(uci.value) value
1282: from pay_user_tables ust,
1283: pay_user_columns usc,
1284: pay_user_rows_f usr,
1285: pay_user_column_instances_f uci

Line 1493: fnd_number.number_to_canonical(l_new_value) ||

1489: if l_new_value < 0 then
1490: p_paye_rec.tax_code_sv := '0T';
1491: else
1492: p_paye_rec.tax_code_sv := pysoytls.trim(p_paye_rec.tax_code_prefix ||
1493: fnd_number.number_to_canonical(l_new_value) ||
1494: p_paye_rec.tax_code_suffix);
1495: end if;
1496: p_paye_rec.tax_code_amended := TRUE;
1497: end if;

Line 1509: fnd_number.number_to_canonical(l_new_value) ||

1505: if l_new_value < 0 then
1506: p_paye_rec.tax_code_sv := '0T';
1507: else
1508: p_paye_rec.tax_code_sv := pysoytls.trim(p_paye_rec.tax_code_prefix ||
1509: fnd_number.number_to_canonical(l_new_value) ||
1510: p_paye_rec.tax_code_suffix);
1511: end if;
1512: p_paye_rec.tax_code_amended := TRUE;
1513: end if;