DBA Data[Home] [Help]

APPS.PY_ZA_ROUTES dependencies on PAY_RUN_RESULT_VALUES

Line 21: pay_run_result_values TARGET,

17: select
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,

Line 69: pay_run_result_values TARGET,

65: select
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,

Line 121: pay_run_result_values TARGET,

117: select
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,

Line 174: pay_run_result_values TARGET,

170: select
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,

Line 227: pay_run_result_values TARGET,

223: select
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,

Line 275: pay_run_result_values TARGET,

271: select
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,

Line 327: pay_run_result_values TARGET,

323: select
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,

Line 380: pay_run_result_values TARGET,

376: select
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,

Line 428: pay_run_result_values TARGET,

424: select
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

Line 471: pay_run_result_values TARGET,

467: select
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,