DBA Data[Home] [Help]

APPS.PAY_US_SQWL_ARCHIVE dependencies on FND_NUMBER

Line 174: the 11i fnd_date and fnd_number changes

170: c_rts_dup_wage cursor. This SQL was
171: changed due to Fidelity performance
172: problem.
173: 12-JUN-2000 asasthan 115.5 update till Q2 2000 changes and includes
174: the 11i fnd_date and fnd_number changes
175: 22-MAY-2000 ashgupta 40.12 1237099 Added the error messages in the
176: preprocess_check function
177: 02-MAR-2000 rpotnuru 40.11 1220213 Terminated Employees not showing for $th Qtr
178: NY sqwl. Range cursor date range will now the whole

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

286:
287: /* Get the defined_balance_id for the specified balance DB item. */
288:
289: cursor csr_defined_balance is
290: select fnd_number.canonical_to_number(UE.creator_id)
291: from ff_user_entities UE,
292: ff_database_items DI
293: where DI.user_name = p_db_item_name
294: and UE.user_entity_id = DI.user_entity_id

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

2983: l_length := l_to - l_from - 1 ;
2984:
2985: hr_utility.trace('l_length is '||to_char(l_length));
2986:
2987: select fnd_number.canonical_to_number(substr(legislative_parameters, l_from , l_length ))
2988: into l_tax_unit_id
2989: from pay_payroll_actions
2990: where payroll_action_id = pactid;
2991: