DBA Data[Home] [Help]

APPS.PAY_CA_CITY_PKG dependencies on FND_NUMBER

Line 380: if fnd_number.canonical_to_number(substr(l_city_rec.city_code,2,3)) >

376: city codes to find the latest city code.
377: */
378: for l_city_rec in c_city_code loop
379:
380: if fnd_number.canonical_to_number(substr(l_city_rec.city_code,2,3)) >
381: l_max_ci_code then
382:
383: l_max_ci_code :=
384: fnd_number.canonical_to_number(substr(l_city_rec.city_code,2,3));

Line 384: fnd_number.canonical_to_number(substr(l_city_rec.city_code,2,3));

380: if fnd_number.canonical_to_number(substr(l_city_rec.city_code,2,3)) >
381: l_max_ci_code then
382:
383: l_max_ci_code :=
384: fnd_number.canonical_to_number(substr(l_city_rec.city_code,2,3));
385: hr_utility.trace ('Max city code is:'||
386: l_city_rec.city_code);
387:
388: end if;