DBA Data[Home] [Help]

APPS.PAY_IE_TAX_VAL dependencies on FND_NUMBER

Line 505: select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) aa

501:
502: -- For Bug 5724436
503: -- Cursor to get the max assignment action id, to fetch the P45 details.
504: cursor get_p45_details (p_assignment_id number) is
505: select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) aa
506: from pay_assignment_actions paa,
507: pay_payroll_actions ppa
508: where ppa.payroll_action_id = paa.payroll_action_id
509: and paa.assignment_id = p_assignment_id