eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PY_ZA_ROUTES dependencies on PAY_PAYROLL_ACTIONS

Line 23: pay_payroll_actions PACT,

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

Line 25: pay_payroll_actions BACT,

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

Line 71: pay_payroll_actions PACT,

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,

Line 73: pay_payroll_actions BACT,

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

Line 123: pay_payroll_actions PACT,

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,

Line 125: pay_payroll_actions BACT,

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

Line 176: pay_payroll_actions PACT,

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,

Line 178: pay_payroll_actions BACT,

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

Line 229: pay_payroll_actions PACT,

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

Line 231: pay_payroll_actions BACT,

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

Line 277: pay_payroll_actions PACT,

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,

Line 279: pay_payroll_actions BACT,

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

Line 329: pay_payroll_actions PACT,

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,

Line 331: pay_payroll_actions BACT,

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

Line 382: pay_payroll_actions PACT,

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

Line 384: pay_payroll_actions BACT,

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

Line 430: pay_payroll_actions PACT,

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

Line 473: pay_payroll_actions PACT,

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

Line 476: pay_payroll_actions BACT,

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

Line 495: from pay_payroll_actions RPACT,

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