eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_US_ARCHIVE dependencies on FND_NUMBER

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

1247: CURSOR c_get_latest_asg(cp_person_id number
1248: ,cp_tax_unit_id in number
1249: ,cp_period_start in date
1250: ,cp_period_end in date) IS
1251: select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')
1252: ||lpad(paa.assignment_action_id,15,'0')),16))
1253: from pay_assignment_actions paa,
1254: per_all_assignments_f paf,
1255: pay_payroll_actions ppa,

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

3154: -- Modified the cursor to remove the order by clause that was there before.
3155: -- The select clause has been modified to get the Assignment Action ID
3156: -- associated with Maximum Action Sequence
3157: CURSOR c_get_latest_asg(p_person_id number ) IS
3158: select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')
3159: ||lpad(paa.assignment_action_id,15,'0')),16))
3160: from pay_assignment_actions paa,
3161: per_all_assignments_f paf,
3162: pay_payroll_actions ppa,