DBA Data[Home] [Help]

APPS.PY_ZA_ROUTES dependencies on PAY_RUN_RESULTS

Line 22: pay_run_results RR,

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

Line 70: pay_run_results RR,

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,

Line 122: pay_run_results RR,

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,

Line 175: pay_run_results RR,

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,

Line 228: pay_run_results RR,

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

Line 276: pay_run_results RR,

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,

Line 328: pay_run_results RR,

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,

Line 381: pay_run_results RR,

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

Line 429: pay_run_results RR,

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

Line 472: pay_run_results RR,

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,