APPS.PAY_ARCHIVE_CHEQUEWRITER dependencies on FND_NUMBER

Line 24: sjawid 05-Jul-2011 115.3 12627884 Added fnd_number.canonical_to_number

20: sudedas
21: sudedas 15-Sep-2007 115.1 Added Order By Clause in Cursor
22: GET_MAG_ASG_ACT
23: sudedas 12-Feb-2008 115.2 6802173 Added Package Level TABLE Type
24: sjawid 05-Jul-2011 115.3 12627884 Added fnd_number.canonical_to_number
25: to order by clause of cursor GET_MAG_ASG_ACT
26: ========================================================================*/
27:
28: /****************************************************************************

Line 66: ORDER BY fnd_number.canonical_to_number(serial_number) asc; /*bug 12627884 */

62: SELECT 'TRANSFER_ACT_ID=P',
63: assignment_action_id
64: FROM pay_assignment_actions
65: WHERE payroll_action_id = pay_magtape_generic.get_parameter_value('PAYROLL_ACTION_ID')
66: ORDER BY fnd_number.canonical_to_number(serial_number) asc; /*bug 12627884 */
67:
68: END pay_archive_chequewriter;