APPS.PAY_CA_ARCHIVE dependencies on FND_NUMBER

Line 289: fnd_number.canonical_to_number(substr(legislative_parameters,11,(decode(instr(legislative_parameters,'' ''),0,10,instr(legislative_parameters,'' '')-11))))

285: -- The first 10 characters of legislative_parameters
286: -- has 'PERSON_ID= '
287:
288: str := 'select
289: fnd_number.canonical_to_number(substr(legislative_parameters,11,(decode(instr(legislative_parameters,'' ''),0,10,instr(legislative_parameters,'' '')-11))))
290: from pay_payroll_actions ppa
291: where ppa.payroll_action_id=:pactid';
292:
293: end if;

Line 427: l_hour := fnd_number.canonical_to_number(

423: for i in 1..7 loop
424:
425: v_curr_day := to_char(l_working_date,'DY');
426:
427: l_hour := fnd_number.canonical_to_number(
428: hruserdt.get_table_value(p_business_group_id,
429: c_ws_tab_name,
430: l_user_column_name,
431: v_curr_day));