APPS.PAY_IE_TAX_VAL dependencies on PAY_PAYROLL_ACTIONS

Line 322: pay_payroll_actions ppa

318: -- Cursor to get the max assignment action id, to fetch the P45 details.
319: cursor get_p45_details (p_assignment_id number) is
320: select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) aa
321: from pay_assignment_actions paa,
322: pay_payroll_actions ppa
323: where ppa.payroll_action_id = paa.payroll_action_id
324: and paa.assignment_id = p_assignment_id
325: and to_number(to_char(ppa.effective_date,'YYYY')) = p_tax_year;
326:

Line 3475: pay_payroll_actions ppa

3471: -- Cursor to get the max assignment action id, to fetch the P45 details.
3472: cursor get_p45_details (p_assignment_id number) is
3473: select fnd_number.canonical_to_number(substr(max(lpad(paa.action_sequence,15,'0')||paa.assignment_action_id),16)) aa
3474: from pay_assignment_actions paa,
3475: pay_payroll_actions ppa
3476: where ppa.payroll_action_id = paa.payroll_action_id
3477: and paa.assignment_id = p_assignment_id
3478: and to_number(to_char(ppa.effective_date,'YYYY')) = p_tax_year;
3479: