APPS.PAY_JP_ITW_REPORT_ARCHIVE dependencies on PAY_ASSIGNMENT_ACTIONS

Line 190: pay_assignment_actions paa

186: --
187: select COUNT(1)
188: into l_count
189: from pay_payroll_actions ppa,
190: pay_assignment_actions paa
191: where ppa.request_id = l_request_id
192: and ppa.action_type = 'X'
193: and paa.payroll_action_id = ppa.payroll_action_id
194: and paa.action_status <> 'C';