293: BEGIN
294:
295: select max(ppa.payroll_action_id)
296: into l_archive_action
297: from pay_payroll_actions ppa
298: where ppa.report_qualifier='NL'
299: and ppa.business_group_id=p_bg_id
300: and ppa.report_type='NL_TAXOFFICE_ARCHIVE'
301: and ppa.report_category='ARCHIVE'
1890: BEGIN
1891:
1892: select max(ppa.payroll_action_id)
1893: into l_archive_action
1894: from pay_payroll_actions ppa
1895: where ppa.report_qualifier='NL'
1896: and ppa.business_group_id=p_bg_id
1897: and ppa.report_type='NL_TAXOFFICE_ARCHIVE'
1898: and ppa.report_category='ARCHIVE'