[Home] [Help]
155: CURSOR c_get_all_aaid_for_mast(cp_run_action_id number)
156: IS
157: select assact.assignment_action_id,
158: assact.assignment_id
159: from pay_action_interlocks intlk
160: ,pay_assignment_actions assact
161: ,pay_payroll_actions ppa
162: where intlk.locking_action_id = cp_run_action_id
163: and intlk.locked_action_id = assact.assignment_action_id
167: and not exists
168: (select null
169: from pay_payroll_actions rpact
170: , pay_assignment_actions rassact
171: , pay_action_interlocks rintlk
172: where assact.assignment_action_id = rintlk.locked_action_id
173: and rintlk.locking_action_id = rassact.assignment_action_id
174: and rpact.payroll_action_id = rassact.payroll_action_id
175: and rpact.action_type = 'V')
178: select assact.assignment_action_id,
179: assact.assignment_id,
180: prt.shortname,
181: prt.run_type_id
182: from pay_action_interlocks intlk
183: ,pay_assignment_actions assact
184: ,pay_run_types_f prt
185: where intlk.locking_action_id = cp_run_action_id
186: and intlk.locked_action_id = assact.assignment_action_id
189: and not exists
190: (select null
191: from pay_payroll_actions rpact
192: , pay_assignment_actions rassact
193: , pay_action_interlocks rintlk
194: where assact.assignment_action_id = rintlk.locked_action_id
195: and rintlk.locking_action_id = rassact.assignment_action_id
196: and rpact.payroll_action_id = rassact.payroll_action_id
197: and rpact.action_type = 'V')
231: and not exists
232: (select null
233: from pay_payroll_actions rpact
234: , pay_assignment_actions rassact
235: , pay_action_interlocks rintlk
236: where assact.assignment_action_id = rintlk.locked_action_id
237: and rintlk.locking_action_id = rassact.assignment_action_id
238: and rpact.payroll_action_id = rassact.payroll_action_id
239: and rpact.action_type = 'V')