DBA Data[Home] [Help]

APPS.HR_NO_UTILITY dependencies on FND_NUMBER

Line 942: -- Using fnd_number.canonical_to_number on column value.

938: */
939:
940: -- Bug Fix 5943303 and 5943317
941: -- A numeric value from a varchar2 column is being returned to a number variable without any conversion.
942: -- Using fnd_number.canonical_to_number on column value.
943:
944: CURSOR csr_get_user_table_value (l_user_column_id NUMBER, l_user_row_id NUMBER) IS
945: SELECT fnd_number.canonical_to_number(value)
946: FROM pay_user_column_instances_f

Line 945: SELECT fnd_number.canonical_to_number(value)

941: -- A numeric value from a varchar2 column is being returned to a number variable without any conversion.
942: -- Using fnd_number.canonical_to_number on column value.
943:
944: CURSOR csr_get_user_table_value (l_user_column_id NUMBER, l_user_row_id NUMBER) IS
945: SELECT fnd_number.canonical_to_number(value)
946: FROM pay_user_column_instances_f
947: WHERE legislation_code = 'NO'
948: AND user_column_id = l_user_column_id
949: AND user_row_id = l_user_row_id