APPS.PAY_CA_RULES dependencies on FND_NUMBER

Line 448: SELECT fnd_number.canonical_to_number (substr (serial_number,3))

444: FROM pay_action_interlocks
445: WHERE locking_action_id = arch_assact_id; */
446: /* Bug 14052902 - Modified the cursor to display appropriate advice number
447: in Emloyee details section when seperate payemnts are made */
448: SELECT fnd_number.canonical_to_number (substr (serial_number,3))
449: FROM pay_assignment_actions
450: WHERE assignment_action_id = arch_assact_id;
451:
452: /*Changes for bug 13870178 starts here */

Line 462: , fnd_number.canonical_to_number (substr (paa2.serial_number,3))

458: , pai.action_information7
459: , pai.action_information8
460: , pai.action_information9
461: , pai.action_information10
462: , fnd_number.canonical_to_number (substr (paa2.serial_number,3))
463: , pai.action_information16
464: , pai.action_information2
465: , pai.action_information11
466: , ppt.category

Line 1203: FND_NUMBER.CANONICAL_TO_NUMBER(

1199: INTO v_curr_day
1200: FROM DUAL;
1201:
1202: v_total_hours := v_total_hours +
1203: FND_NUMBER.CANONICAL_TO_NUMBER(
1204: hruserdt.get_table_value(p_bg_id,
1205: c_ws_tab_name,
1206: v_ws_name,
1207: v_curr_day));