19: from
20: pay_balance_feeds_f FEED,
21: pay_run_result_values TARGET,
22: pay_run_results RR,
23: pay_payroll_actions PACT,
24: pay_assignment_actions ASSACT,
25: pay_payroll_actions BACT,
26: pay_assignment_actions BAL_ASSACT
27: where BAL_ASSACT.assignment_action_id = assact_id
21: pay_run_result_values TARGET,
22: pay_run_results RR,
23: pay_payroll_actions PACT,
24: pay_assignment_actions ASSACT,
25: pay_payroll_actions BACT,
26: pay_assignment_actions BAL_ASSACT
27: where BAL_ASSACT.assignment_action_id = assact_id
28: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
29: and FEED.balance_type_id = baltype
67: from
68: pay_balance_feeds_f FEED,
69: pay_run_result_values TARGET,
70: pay_run_results RR,
71: pay_payroll_actions PACT,
72: pay_assignment_actions ASSACT,
73: pay_payroll_actions BACT,
74: per_time_periods BPTP,
75: per_time_periods PPTP,
69: pay_run_result_values TARGET,
70: pay_run_results RR,
71: pay_payroll_actions PACT,
72: pay_assignment_actions ASSACT,
73: pay_payroll_actions BACT,
74: per_time_periods BPTP,
75: per_time_periods PPTP,
76: pay_assignment_actions BAL_ASSACT
77: where BAL_ASSACT.assignment_action_id = assact_id
119: from
120: pay_balance_feeds_f FEED,
121: pay_run_result_values TARGET,
122: pay_run_results RR,
123: pay_payroll_actions PACT,
124: pay_assignment_actions ASSACT,
125: pay_payroll_actions BACT,
126: per_time_periods BPTP,
127: per_time_periods PPTP,
121: pay_run_result_values TARGET,
122: pay_run_results RR,
123: pay_payroll_actions PACT,
124: pay_assignment_actions ASSACT,
125: pay_payroll_actions BACT,
126: per_time_periods BPTP,
127: per_time_periods PPTP,
128: pay_assignment_actions BAL_ASSACT
129: where BAL_ASSACT.assignment_action_id = assact_id
172: from
173: pay_balance_feeds_f FEED,
174: pay_run_result_values TARGET,
175: pay_run_results RR,
176: pay_payroll_actions PACT,
177: pay_assignment_actions ASSACT,
178: pay_payroll_actions BACT,
179: per_time_periods BPTP,
180: per_time_periods PPTP,
174: pay_run_result_values TARGET,
175: pay_run_results RR,
176: pay_payroll_actions PACT,
177: pay_assignment_actions ASSACT,
178: pay_payroll_actions BACT,
179: per_time_periods BPTP,
180: per_time_periods PPTP,
181: pay_assignment_actions BAL_ASSACT
182: where BAL_ASSACT.assignment_action_id = assact_id
225: from
226: pay_balance_feeds_f FEED,
227: pay_run_result_values TARGET,
228: pay_run_results RR,
229: pay_payroll_actions PACT,
230: pay_assignment_actions ASSACT,
231: pay_payroll_actions BACT,
232: pay_assignment_actions BAL_ASSACT
233: where BAL_ASSACT.assignment_action_id = assact_id
227: pay_run_result_values TARGET,
228: pay_run_results RR,
229: pay_payroll_actions PACT,
230: pay_assignment_actions ASSACT,
231: pay_payroll_actions BACT,
232: pay_assignment_actions BAL_ASSACT
233: where BAL_ASSACT.assignment_action_id = assact_id
234: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
235: and FEED.balance_type_id = baltype
273: from
274: pay_balance_feeds_f FEED,
275: pay_run_result_values TARGET,
276: pay_run_results RR,
277: pay_payroll_actions PACT,
278: pay_assignment_actions ASSACT,
279: pay_payroll_actions BACT,
280: per_time_periods BPTP,
281: per_time_periods PPTP,
275: pay_run_result_values TARGET,
276: pay_run_results RR,
277: pay_payroll_actions PACT,
278: pay_assignment_actions ASSACT,
279: pay_payroll_actions BACT,
280: per_time_periods BPTP,
281: per_time_periods PPTP,
282: pay_assignment_actions BAL_ASSACT
283: where BAL_ASSACT.assignment_action_id = assact_id
325: from
326: pay_balance_feeds_f FEED,
327: pay_run_result_values TARGET,
328: pay_run_results RR,
329: pay_payroll_actions PACT,
330: pay_assignment_actions ASSACT,
331: pay_payroll_actions BACT,
332: per_time_periods BPTP,
333: per_time_periods PPTP,
327: pay_run_result_values TARGET,
328: pay_run_results RR,
329: pay_payroll_actions PACT,
330: pay_assignment_actions ASSACT,
331: pay_payroll_actions BACT,
332: per_time_periods BPTP,
333: per_time_periods PPTP,
334: pay_assignment_actions BAL_ASSACT
335: where BAL_ASSACT.assignment_action_id = assact_id
378: from
379: pay_balance_feeds_f FEED,
380: pay_run_result_values TARGET,
381: pay_run_results RR,
382: pay_payroll_actions PACT,
383: pay_assignment_actions ASSACT,
384: pay_payroll_actions BACT,
385: pay_assignment_actions BAL_ASSACT
386: where BAL_ASSACT.assignment_action_id = assact_id
380: pay_run_result_values TARGET,
381: pay_run_results RR,
382: pay_payroll_actions PACT,
383: pay_assignment_actions ASSACT,
384: pay_payroll_actions BACT,
385: pay_assignment_actions BAL_ASSACT
386: where BAL_ASSACT.assignment_action_id = assact_id
387: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
388: and FEED.balance_type_id = baltype
426: from
427: pay_balance_feeds_f FEED,
428: pay_run_result_values TARGET,
429: pay_run_results RR,
430: pay_payroll_actions PACT,
431: pay_assignment_actions ASSACT
432: where ASSACT.assignment_action_id = assact_id
433: and FEED.balance_type_id = baltype
434: and FEED.input_value_id = TARGET.input_value_id
469: from
470: pay_balance_feeds_f FEED,
471: pay_run_result_values TARGET,
472: pay_run_results RR,
473: pay_payroll_actions PACT,
474: pay_assignment_actions ASSACT,
475: pay_action_interlocks INTLK,
476: pay_payroll_actions BACT,
477: pay_assignment_actions BAL_ASSACT
472: pay_run_results RR,
473: pay_payroll_actions PACT,
474: pay_assignment_actions ASSACT,
475: pay_action_interlocks INTLK,
476: pay_payroll_actions BACT,
477: pay_assignment_actions BAL_ASSACT
478: where BAL_ASSACT.assignment_action_id = assact_id
479: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
480: and FEED.balance_type_id = baltype
491: and PACT.action_type <> 'V' /* not reversals */
492: and ASSACT.assignment_id = BAL_ASSACT.assignment_id
493: and not exists
494: (select null
495: from pay_payroll_actions RPACT,
496: pay_assignment_actions RASSACT,
497: pay_action_interlocks RINTLK
498: where ASSACT.assignment_action_id = RINTLK.locked_action_id
499: and RINTLK.locking_action_id = RASSACT.assignment_action_id