DBA Data[Home] [Help]

APPS.PAY_JP_IWHT_REPORT_ARCH_PKG dependencies on PAY_ASSIGNMENT_ACTIONS

Line 181: pay_assignment_actions paa

177: --
178: select COUNT(1)
179: into l_count
180: from pay_payroll_actions ppa,
181: pay_assignment_actions paa
182: where ppa.request_id = l_request_id
183: and ppa.action_type = 'X'
184: and paa.payroll_action_id = ppa.payroll_action_id
185: and paa.action_status <> 'C';