DBA Data[Home] [Help]

APPS.PYUDET dependencies on FND_NUMBER

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

1151: FUNCTION get_uplift_value (p_tax_suffix in varchar2) return NUMBER
1152: IS
1153: cursor c_uplift is
1154: select usr.row_low_range_or_name suffix,
1155: fnd_number.canonical_to_number(uci.value) value
1156: from pay_user_tables ust,
1157: pay_user_columns usc,
1158: pay_user_rows_f usr,
1159: pay_user_column_instances_f uci

Line 1338: fnd_number.number_to_canonical(l_new_value) ||

1334: if l_new_value < 0 then
1335: p_paye_rec.tax_code_sv := '0T';
1336: else
1337: p_paye_rec.tax_code_sv := pysoytls.trim(p_paye_rec.tax_code_prefix ||
1338: fnd_number.number_to_canonical(l_new_value) ||
1339: p_paye_rec.tax_code_suffix);
1340: end if;
1341: p_paye_rec.tax_code_amended := TRUE;
1342: end if;

Line 1354: fnd_number.number_to_canonical(l_new_value) ||

1350: if l_new_value < 0 then
1351: p_paye_rec.tax_code_sv := '0T';
1352: else
1353: p_paye_rec.tax_code_sv := pysoytls.trim(p_paye_rec.tax_code_prefix ||
1354: fnd_number.number_to_canonical(l_new_value) ||
1355: p_paye_rec.tax_code_suffix);
1356: end if;
1357: p_paye_rec.tax_code_amended := TRUE;
1358: end if;