132: use_nl(ppa2)
133: */ null
134: from pay_assignment_actions paa2,
135: pay_payroll_actions ppa2,
136: pay_action_classifications pac
137: where paa2.assignment_id = asg.assignment_id
138: and paa2.action_status not in ('C', 'S') -- Bug 4442484: 'S'kipped assact is not an errored one
139: and paa2.source_action_id is null
140: and ppa2.payroll_action_id = paa2.payroll_action_id
245: use_nl(ppa2)
246: */ null
247: from pay_assignment_actions paa2,
248: pay_payroll_actions ppa2,
249: pay_action_classifications pac
250: where paa2.assignment_id = asg.assignment_id
251: and paa2.action_status not in ('C', 'S') -- Bug 4442484: 'S'kipped assact is not an errored one
252: and paa2.source_action_id is null
253: and ppa2.payroll_action_id = paa2.payroll_action_id