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_ARCHIVE_MISSING_ASG_PKG dependencies on DUAL

Line 241: from dual;

237: END IF;
238:
239: select pay_assignment_actions_s.nextval
240: into lockingactid
241: from dual;
242:
243: l_step := 4;
244: -- insert the action record.
245: hr_nonrun_asact.insact(lockingactid =>lockingactid,

Line 382: FROM DUAL

378: cp_tax_unit_id number,
379: cp_bal_attribute_id number
380: ) IS
381: SELECT 1
382: FROM DUAL
383: WHERE EXISTS(
384: select 1
385: from pay_run_balances prb,
386: pay_balance_attributes pba,

Line 400: SELECT 1 FROM dual

396:
397: CURSOR c_non_zero_run_result(cp_assignment_id number,
398: cp_effective_date date,
399: cp_tax_unit_id number) is
400: SELECT 1 FROM dual
401: WHERE EXISTS (SELECT 1
402: FROM pay_run_results prr,
403: pay_run_result_values prrv,
404: pay_input_values_f piv,

Line 436: FROM dual;

432:
433:
434: CURSOR c_get_session_id IS
435: SELECT userenv('sessionid')
436: FROM dual;
437:
438: lv_result_value number:=0;
439: lv_count number;
440: l_asgid pay_assignment_actions.assignment_id%TYPE;