213: 'PERSON_ID=P',
214: to_char(paa.person_id) person_id,
215: 'ASSIGNMENT_NUMBER=P',
216: paa.assignment_number assignment_number
217: from per_all_assignments_f paa,
218: pay_payroll_actions ppa,
219: pay_assignment_actions pac,
220: ff_archive_items fai,
221: ff_archive_item_contexts ac2
236: 'TAX_UNIT_ID=C',
237: to_number(ac2.context) tax_unit_id,
238: 'BASIS_YEAR=P',
239: pay_core_utils.get_parameter('BASIS_YEAR', ppa.legislative_parameters) basis_year
240: from per_all_assignments_f paa,
241: pay_payroll_actions ppa,
242: pay_assignment_actions pac,
243: ff_archive_items fai,
244: ff_archive_item_contexts ac2