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_SUPH_EVENTS dependencies on HRI_EQ_SPRVSR_HRCHY_CHGS

Line 137: hri_eq_sprvsr_hrchy_chgs eq

133: ,asg.assignment_status_type_id
134: ,asg.assignment_type
135: ,asg.business_group_id
136: FROM
137: hri_eq_sprvsr_hrchy_chgs eq
138: ,per_all_assignments_f asg
139: ,per_assignment_status_types ast
140: WHERE asg.assignment_type IN ('E', 'C')
141: AND asg.primary_flag = 'Y'

Line 422: ,hri_eq_sprvsr_hrchy_chgs eq

418: WHERE ase.rowid IN
419: (SELECT ase2.rowid
420: FROM
421: hri_cs_asgn_suph_events_ct ase2
422: ,hri_eq_sprvsr_hrchy_chgs eq
423: WHERE eq.assignment_id = ase2.assignment_id
424: AND ase2.effective_start_date >= eq.erlst_evnt_effective_date);
425:
426: -- commit

Line 433: FROM hri_eq_sprvsr_hrchy_chgs evt

429: -- End date rows to be updated incrementally
430: UPDATE hri_cs_asgn_suph_events_ct ase
431: SET effective_end_date =
432: (SELECT (evt.erlst_evnt_effective_date - 1)
433: FROM hri_eq_sprvsr_hrchy_chgs evt
434: WHERE evt.assignment_id = ase.assignment_id)
435: WHERE ase.rowid IN
436: (SELECT ase2.rowid
437: FROM

Line 439: ,hri_eq_sprvsr_hrchy_chgs eq

435: WHERE ase.rowid IN
436: (SELECT ase2.rowid
437: FROM
438: hri_cs_asgn_suph_events_ct ase2
439: ,hri_eq_sprvsr_hrchy_chgs eq
440: WHERE eq.assignment_id = ase2.assignment_id
441: AND ase2.effective_end_date >= eq.erlst_evnt_effective_date);
442:
443: -- commit

Line 450: FROM hri_eq_sprvsr_hrchy_chgs eq

446: -- Set the SQL statement for the incremental range
447: p_sqlstr :=
448: 'SELECT /*+ PARALLEL(eq, DEFAULT, DEFAULT) */
449: assignment_id object_id
450: FROM hri_eq_sprvsr_hrchy_chgs eq
451: ORDER BY assignment_id';
452:
453: END IF;
454: