309: BEGIN
310:
311: select max(ppa.payroll_action_id)
312: into l_archive_action
313: from pay_payroll_actions ppa
314: where ppa.report_qualifier='NL'
315: and ppa.business_group_id=p_bg_id
316: and ppa.report_type='NL_TAXOFFICE_ARCHIVE'
317: and ppa.report_category='ARCHIVE'
1937: BEGIN
1938:
1939: select max(ppa.payroll_action_id)
1940: into l_archive_action
1941: from pay_payroll_actions ppa
1942: where ppa.report_qualifier='NL'
1943: and ppa.business_group_id=p_bg_id
1944: and ppa.report_type='NL_TAXOFFICE_ARCHIVE'
1945: and ppa.report_category='ARCHIVE'