209: and pai2.locked_action_id = paa2.assignment_action_id
210: )
211: and not exists (
212: select null
213: from pay_action_classifications acl,
214: pay_payroll_actions pa2,
215: pay_assignment_actions ac2
216: where ac2.assignment_id = paa.assignment_id
217: and pa2.payroll_action_id = ac2.payroll_action_id
221: and ac2.action_sequence > paa.action_sequence
222: )
223: and not exists (
224: select null
225: from pay_action_classifications acl,
226: pay_payroll_actions pa2,
227: pay_assignment_actions ac2
228: where ac2.assignment_id = paa.assignment_id
229: and pa2.payroll_action_id = ac2.payroll_action_id
294: and pai2.locked_action_id = paa2.assignment_action_id
295: )
296: and not exists (
297: select 1
298: from pay_action_classifications acl,
299: pay_payroll_actions pa2,
300: pay_assignment_actions ac2
301: where ac2.assignment_id = paa.assignment_id
302: and pa2.payroll_action_id = ac2.payroll_action_id