[Home] [Help]
275: AND EXISTS (
276: SELECT
277: 'x'
278: FROM
279: pay_assignment_actions paa2
280: WHERE nvl(paa2.tax_unit_id,-9999) = nvl(pai.tax_unit_id,-9999)
281: AND paa2.assignment_action_id = pai.action_context_id
282: AND paa2.assignment_id = pai.assignment_id )
283: ORDER BY pai.effective_date desc,