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.PAY_US_MAGW2_REPORTING dependencies on DUAL

Line 292: FROM dual

288: --Cursor for checking if any of the the archiver has errored for
289: --any of the assignments for federal W2
290: CURSOR c_arch_errored_asg (cp_payroll_action_id NUMBER) IS
291: SELECT '1'
292: FROM dual
293: WHERE EXISTS (SELECT '1'
294: FROM pay_assignment_actions paa
295: WHERE paa.payroll_action_id = cp_payroll_action_id
296: AND paa.action_status = 'E'

Line 308: FROM dual

304: --Cursor for checking if any of the assignments have been marked for retry
305:
306: CURSOR c_arch_retry_pending (cp_payroll_action_id NUMBER) IS
307: SELECT '1'
308: FROM dual
309: WHERE EXISTS (SELECT '1'
310: FROM pay_assignment_actions paa
311: WHERE paa.payroll_action_id = cp_payroll_action_id
312: AND paa.action_status = 'M')

Line 1111: FROM dual;

1107: IF (l_report_type = 'FEDW2' and l_value > 0) OR
1108: (l_report_type = 'STW2') then
1109: SELECT pay_assignment_actions_s.nextval
1110: INTO lockingactid
1111: FROM dual;
1112: hr_utility.set_location(
1113: 'pay_us_magw2_reporting.create_assignement_act', 60);
1114: hr_nonrun_asact.insact(lockingactid, l_assignment_id, p_pactid,
1115: p_chunk, l_tax_unit_id);