18: nvl(sum(TARGET.result_value * FEED.scale),0)
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
66: nvl(sum(TARGET.result_value * FEED.scale),0)
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,
118: nvl(sum(TARGET.result_value * FEED.scale),0)
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,
171: nvl(sum(TARGET.result_value * FEED.scale),0)
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,
224: nvl(sum(TARGET.result_value * FEED.scale),0)
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
272: nvl(sum(TARGET.result_value * FEED.scale),0)
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,
324: nvl(sum(TARGET.result_value * FEED.scale),0)
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,
377: nvl(sum(TARGET.result_value * FEED.scale),0)
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
425: nvl(sum(TARGET.result_value * FEED.scale),0)
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
468: nvl(sum(TARGET.result_value * FEED.scale),0)
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,