APPS.PAY_US_ARCHIVE dependencies on FND_NUMBER

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

1551: CURSOR c_get_latest_asg(cp_person_id number
1552: ,cp_tax_unit_id in number
1553: ,cp_period_start in date
1554: ,cp_period_end in date) IS
1555: select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')
1556: ||lpad(paa.assignment_action_id,15,'0')),16))
1557: from pay_assignment_actions paa,
1558: per_all_assignments_f paf,
1559: pay_payroll_actions ppa,

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

3741: -- Modified the cursor to remove the order by clause that was there before.
3742: -- The select clause has been modified to get the Assignment Action ID
3743: -- associated with Maximum Action Sequence
3744: CURSOR c_get_latest_asg(p_person_id number ) IS
3745: select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')
3746: ||lpad(paa.assignment_action_id,15,'0')),16))
3747: from pay_assignment_actions paa,
3748: per_all_assignments_f paf,
3749: pay_payroll_actions ppa,

Line 5214: l_psd_balance_value := fnd_number.number_to_canonical(

5210: into l_psd_def_bal_id,
5211: lv_user_entity_name;
5212: close pay_us_payroll_utils.c_get_defined_balance_id;
5213:
5214: l_psd_balance_value := fnd_number.number_to_canonical(
5215: nvl(pay_balance_pkg.get_value(p_defined_balance_id => l_psd_def_bal_id
5216: ,p_assignment_action_id => l_aaid),0));
5217: hr_utility.trace('l_psd_bal_value in archive data: '||l_psd_balance_value);
5218:

Line 5234: ln_bal_value := fnd_number.number_to_canonical(

5230: ln_psd_def_bal_id :=
5231: pay_us_archive.ltr_psd_tax_bal(k).defined_balance;
5232:
5233:
5234: ln_bal_value := fnd_number.number_to_canonical(
5235: nvl(pay_balance_pkg.get_value(p_defined_balance_id => ln_psd_def_bal_id
5236: ,p_assignment_action_id => l_aaid),0));
5237:
5238: hr_utility.trace('ln_bal_value = '|| ln_bal_value);