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_CMNTS dependencies on PER_ALL_ASSIGNMENTS_F

Line 196: per_all_assignments_f paaf,

192: ,l_user_id
193: ,SYSDATE
194: FROM pqh_element_commitments pec,
195: pqh_bdgt_cmmtmnt_elmnts pbce,
196: per_all_assignments_f paaf,
197: per_pay_bases ppb,
198: pay_element_types_f petf
199: WHERE pec.assignment_id = paaf.assignment_id
200: AND pec.element_type_id = petf.element_type_id

Line 283: FROM per_all_assignments_f asgn

279: p_sqlstr :=
280: 'SELECT /*+ PARALLEL(asgn, DEFAULT, DEFAULT) */
281: DISTINCT
282: asgn.assignment_id object_id
283: FROM per_all_assignments_f asgn
284: WHERE asgn.assignment_type in (''E'',''C'')
285: AND asgn.effective_end_date >= to_date(''' ||
286: to_char(g_refresh_start_date, 'DD-MM-YYYY') ||
287: ''',''DD-MM-YYYY'') - 1

Line 455: FROM per_all_assignments_f asgn

451: max(object_id) end_object_id
452: FROM (SELECT hri_opl_multi_thread.get_next_mthd_range_id(rownum,200) mthd_range_id
453: ,object_id
454: FROM (SELECT DISTINCT asgn.assignment_id object_id
455: FROM per_all_assignments_f asgn
456: WHERE asgn.assignment_type in ('E','C')
457: AND asgn.effective_end_date >= g_refresh_start_date - 1
458: ORDER BY asgn.assignment_id)
459: )