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.HRI_OPL_ACTLS dependencies on PER_ALL_ASSIGNMENTS_F

Line 215: FROM per_all_assignments_f paaf,

211: ,l_user_id
212: ,l_user_id
213: ,l_user_id
214: ,l_current_time
215: FROM per_all_assignments_f paaf,
216: pay_assignment_actions paa2,
217: pay_payroll_actions ppa2,
218: pay_run_results ppr,
219: pay_costs pc,

Line 312: FROM per_all_assignments_f asgn

308: p_sqlstr :=
309: 'SELECT /*+ PARALLEL(asgn, DEFAULT, DEFAULT) */
310: DISTINCT
311: asgn.assignment_id object_id
312: FROM per_all_assignments_f asgn
313: WHERE asgn.assignment_type in (''E'',''C'')
314: AND asgn.effective_end_date >= to_date(''' ||
315: to_char(g_refresh_start_date, 'DD-MM-YYYY') ||
316: ''',''DD-MM-YYYY'') - 1

Line 484: FROM per_all_assignments_f asgn

480: max(object_id) end_object_id
481: FROM (SELECT hri_opl_multi_thread.get_next_mthd_range_id(rownum,200) mthd_range_id
482: ,object_id
483: FROM (SELECT DISTINCT asgn.assignment_id object_id
484: FROM per_all_assignments_f asgn
485: WHERE asgn.assignment_type in ('E','C')
486: AND asgn.effective_end_date >= g_refresh_start_date - 1
487: ORDER BY asgn.assignment_id)
488: )