DBA Data[Home] [Help]

APPS.PAY_NL_ATS_REPORT dependencies on PAY_PAYROLL_ACTIONS

Line 297: from pay_payroll_actions ppa

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'

Line 1894: from pay_payroll_actions ppa

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'