APPS.PAY_CA_ARCHIVE dependencies on FND_NUMBER

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

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

Line 431: l_hour := fnd_number.canonical_to_number(

427: for i in 1..7 loop
428:
429: v_curr_day := to_char(l_working_date,'DY');
430:
431: l_hour := fnd_number.canonical_to_number(
432: hruserdt.get_table_value(p_business_group_id,
433: c_ws_tab_name,
434: l_user_column_name,
435: v_curr_day));