[Home] [Help]
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';