APPS.PAY_IE_LEGISLATIVE_ARCHIVE dependencies on FND_NUMBER

Line 1468: , p_action_information4 => fnd_number.number_to_canonical(l_balance_value) -- Changed by rmakhija for 3574741

1464: , p_action_information_category => 'EMEA BALANCES'
1465: , p_action_information1 => p_defined_bal_id
1466: , p_action_information2 => NULL
1467: , p_action_information3 => NULL
1468: , p_action_information4 => fnd_number.number_to_canonical(l_balance_value) -- Changed by rmakhija for 3574741
1469: , p_action_information5 => l_record_count);
1470:
1471: END IF;
1472:

Line 1588: ltrim(rtrim(to_char(fnd_number.canonical_to_number(rec_element_value.result_value), '999999999999999990.00'))),

1584: ELSE
1585: -- Added for bug 5387406. This checks for UOM, if it is money set the
1586: -- format mask to '999999999999999990.00'
1587: SELECT decode(g_element_table(l_index).uom, 'M',
1588: ltrim(rtrim(to_char(fnd_number.canonical_to_number(rec_element_value.result_value), '999999999999999990.00'))),
1589: rec_element_value.result_value)
1590: INTO l_result_value
1591: FROM dual;
1592:

Line 2468: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||

2464: WHERE paa.run_type_id = prt.run_type_id
2465: AND prt.run_method = 'S'
2466: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2467: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa)
2468: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2469: paa.assignment_action_id),16)) child_assignment_action_id
2470: FROM pay_assignment_actions paa,
2471: pay_payroll_actions ppa
2472: WHERE paa.assignment_id = p_assignment_id

Line 2488: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||

2484: WHERE paa.run_type_id = prt.run_type_id
2485: AND prt.run_method IN ('N','P')
2486: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2487: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa) */
2488: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2489: paa.assignment_action_id),16)) child_assignment_action_id
2490: FROM pay_assignment_actions paa,
2491: pay_payroll_actions ppa
2492: WHERE paa.assignment_id = p_assignment_id

Line 2528: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||

2524: WHERE paa.run_type_id = prt.run_type_id
2525: AND prt.run_method IN ('N','P')
2526: AND p_effective_date BETWEEN prt.effective_start_date AND prt.effective_end_date
2527: AND paa.assignment_action_id = (SELECT /*+ USE_NL(paa, ppa)
2528: fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||
2529: paa.assignment_action_id),16))
2530: FROM pay_assignment_actions paa,
2531: pay_payroll_actions ppa
2532: WHERE paa.assignment_id = p_assignment_id