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_ASSIGNMENT_ACTIONS

Line 24: pay_assignment_actions ASSACT,

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
28: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id

Line 26: pay_assignment_actions BAL_ASSACT

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
30: and FEED.input_value_id = TARGET.input_value_id

Line 72: pay_assignment_actions ASSACT,

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,
76: pay_assignment_actions BAL_ASSACT

Line 76: pay_assignment_actions BAL_ASSACT

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
78: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
79: and FEED.balance_type_id = baltype
80: and FEED.input_value_id = TARGET.input_value_id

Line 124: pay_assignment_actions ASSACT,

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,
128: pay_assignment_actions BAL_ASSACT

Line 128: pay_assignment_actions BAL_ASSACT

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
130: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
131: and FEED.balance_type_id = baltype
132: and FEED.input_value_id = TARGET.input_value_id

Line 177: pay_assignment_actions ASSACT,

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,
181: pay_assignment_actions BAL_ASSACT

Line 181: pay_assignment_actions BAL_ASSACT

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
183: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
184: and FEED.balance_type_id = baltype
185: and FEED.input_value_id = TARGET.input_value_id

Line 230: pay_assignment_actions ASSACT,

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
234: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id

Line 232: pay_assignment_actions BAL_ASSACT

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
236: and FEED.input_value_id = TARGET.input_value_id

Line 278: pay_assignment_actions ASSACT,

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,
282: pay_assignment_actions BAL_ASSACT

Line 282: pay_assignment_actions BAL_ASSACT

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
284: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
285: and FEED.balance_type_id = baltype
286: and FEED.input_value_id = TARGET.input_value_id

Line 330: pay_assignment_actions ASSACT,

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,
334: pay_assignment_actions BAL_ASSACT

Line 334: pay_assignment_actions BAL_ASSACT

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
336: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id
337: and FEED.balance_type_id = baltype
338: and FEED.input_value_id = TARGET.input_value_id

Line 383: pay_assignment_actions ASSACT,

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
387: and BAL_ASSACT.payroll_action_id = BACT.payroll_action_id

Line 385: pay_assignment_actions BAL_ASSACT

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
389: and FEED.input_value_id = TARGET.input_value_id

Line 431: pay_assignment_actions ASSACT

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
435: and TARGET.run_result_id = RR.run_result_id

Line 474: pay_assignment_actions ASSACT,

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
478: where BAL_ASSACT.assignment_action_id = assact_id

Line 477: pay_assignment_actions BAL_ASSACT

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
481: and FEED.input_value_id = TARGET.input_value_id

Line 496: pay_assignment_actions RASSACT,

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
500: and RPACT.payroll_action_id = RASSACT.payroll_action_id