158: select * from pay_action_information where
159: action_context_id in
160: (
161: SELECT assignment_action_id
162: FROM fnd_concurrent_programs fcp
163: , fnd_concurrent_requests fcr
164: , pay_payroll_actions ppa
165: , pay_assignment_actions paa
166: where fcr.REQUEST_ID = ppa.REQUEST_ID
177: select * from pay_action_information where
178: action_context_id in
179: (
180: SELECT assignment_action_id
181: FROM fnd_concurrent_programs fcp
182: , fnd_concurrent_requests fcr
183: , pay_payroll_actions ppa
184: , pay_assignment_actions paa
185: where fcr.REQUEST_ID = ppa.REQUEST_ID