16: and pds.period_of_service_id = asg.period_of_service_id
17: and ppa.effective_date between pds.date_start and nvl(pds.final_process_date, ppa.effective_date)
18: and exists
19: ( select paa.assignment_id
20: from pay_assignment_actions paa
21: where paa.payroll_action_id = to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, ''BAL_ADJ_ACTION_ID'', null))
22: and paa.assignment_id = asg.assignment_id
23: and paa.action_status in (''C'', ''S'')
24: )
130: select /*+
131: ordered
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
146: --
147: and not exists(
148: select null
149: from pay_payroll_actions ppa4,
150: pay_assignment_actions paa4
151: where paa4.assignment_id = asg.assignment_id
152: and paa4.source_action_id is null
153: and ppa4.payroll_action_id = paa4.payroll_action_id
154: and ppa4.action_type IN ('X','B')
160: -- Include if BA has been processed
161: --
162: and exists (
163: select null
164: from pay_assignment_actions paa6
165: where paa6.payroll_action_id = to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'BAL_ADJ_ACTION_ID', null))
166: and paa6.assignment_id = asg.assignment_id
167: and paa6.action_status in ('C', 'S')) -- Bug 4442484: Include 'S'kipped assacts
168: --
172: p_assignment_id number )
173: IS
174: Select asg.assignment_action_id
175: ,asg.tax_unit_id
176: from pay_assignment_actions asg
177: where asg.payroll_action_id = p_bal_adj_action_id
178: and asg.assignment_id = p_assignment_id
179: and asg.action_status in ('C', 'S') ; -- Bug 4442484: Include 'S'kipped assacts
180: ------------------------------------------------------------------------------------
183: initialization_code(p_payroll_action_id);
184: --
185: for l_asg in csr_asg(g_pact.payroll_id)
186: loop
187: select pay_assignment_actions_s.nextval
188: into l_locking_action_id
189: from dual;
190: --
191: open csr_bal_asg(g_pact.bal_adj_action_id, l_asg.assignment_id);
243: select /*+
244: ordered
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
259: --
260: and exists(
261: select null
262: from pay_payroll_actions ppa4,
263: pay_assignment_actions paa4
264: where paa4.assignment_id = asg.assignment_id
265: and paa4.source_action_id is null
266: and ppa4.payroll_action_id = paa4.payroll_action_id
267: and ppa4.action_type IN ('X','B')
274: --
275: and not exists(
276: select null
277: from pay_payroll_actions ppa3,
278: pay_assignment_actions paa3
279: where paa3.assignment_id = asg.assignment_id
280: and paa3.source_action_id is null
281: and ppa3.payroll_action_id = paa3.payroll_action_id
282: and ppa3.effective_date > ppa.effective_date
288: -- Include if BA has been processed
289: --
290: and exists (
291: select null
292: from pay_assignment_actions paa6
293: where paa6.payroll_action_id = to_number(pay_kr_ff_functions_pkg.get_legislative_parameter(ppa.payroll_action_id, 'BAL_ADJ_ACTION_ID', null))
294: and paa6.assignment_id = asg.assignment_id
295: and paa6.action_status in ('C', 'S')) -- Bug 4442484: Include 'S'kipped assacts
296: --
300: p_assignment_id number )
301: IS
302: Select asg.assignment_action_id
303: ,asg.tax_unit_id
304: from pay_assignment_actions asg
305: where asg.payroll_action_id = p_bal_adj_action_id
306: and asg.assignment_id = p_assignment_id
307: and asg.action_status in ('C', 'S'); -- Bug 4442484: Include 'S'kipped assacts
308:
309: begin
310: initialization_code(p_payroll_action_id);
311: --
312: for l_asg in csr_asg(g_pact.payroll_id) loop
313: select pay_assignment_actions_s.nextval
314: into l_locking_action_id
315: from dual;
316: --
317: open csr_bal_asg(g_pact.bal_adj_action_id, l_asg.assignment_id);
349: p_assignment_action_id number )
350: IS
351: Select asg_b.assignment_action_id
352: ,asg_b.assignment_id
353: from pay_assignment_actions asg
354: ,pay_assignment_actions asg_b
355: where asg_b.payroll_action_id = p_bal_adj_action_id
356: and asg_b.assignment_id = asg.assignment_id
357: and asg.assignment_action_id = p_assignment_action_id
350: IS
351: Select asg_b.assignment_action_id
352: ,asg_b.assignment_id
353: from pay_assignment_actions asg
354: ,pay_assignment_actions asg_b
355: where asg_b.payroll_action_id = p_bal_adj_action_id
356: and asg_b.assignment_id = asg.assignment_id
357: and asg.assignment_action_id = p_assignment_action_id
358: and asg_b.action_status in ('C', 'S') ; -- Bug 4442484: Include 'S'kipped assacts