APPS.PAY_US_SQWL_ARCHIVE dependencies on FND_NUMBER

Line 228: the 11i fnd_date and fnd_number changes

224: c_rts_dup_wage cursor. This SQL was
225: changed due to Fidelity performance
226: problem.
227: 12-JUN-2000 asasthan 115.5 update till Q2 2000 changes and includes
228: the 11i fnd_date and fnd_number changes
229: 22-MAY-2000 ashgupta 40.12 1237099 Added the error messages in the
230: preprocess_check function
231: 02-MAR-2000 rpotnuru 40.11 1220213 Terminated Employees not showing for $th Qtr
232: NY sqwl. Range cursor date range will now the whole

Line 345: select fnd_number.canonical_to_number(UE.creator_id)

341:
342: /* Get the defined_balance_id for the specified balance DB item. */
343:
344: cursor csr_defined_balance is
345: select fnd_number.canonical_to_number(UE.creator_id)
346: from ff_user_entities UE,
347: ff_database_items DI
348: where DI.user_name = p_db_item_name
349: and UE.user_entity_id = DI.user_entity_id

Line 3983: select fnd_number.canonical_to_number(substr(legislative_parameters, l_from , l_length ))

3979: l_length := l_to - l_from - 1 ;
3980:
3981: hr_utility.trace('l_length is '||to_char(l_length));
3982:
3983: select fnd_number.canonical_to_number(substr(legislative_parameters, l_from , l_length ))
3984: into l_tax_unit_id
3985: from pay_payroll_actions
3986: where payroll_action_id = pactid;
3987: