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.PER_PERUSEOX_XMLP_PKG dependencies on HR_LOCATION_EXTRA_INFO

Line 77: from hr_location_extra_info hlei1,

73: end;
74: begin
75: select null
76: into l_dummy
77: from hr_location_extra_info hlei1,
78: hr_location_extra_info hlei2,
79: per_gen_hierarchy_nodes pgn,
80: hr_locations_all eloc
81: where pgn.hierarchy_version_id = p_hierarchy_version_id

Line 78: hr_location_extra_info hlei2,

74: begin
75: select null
76: into l_dummy
77: from hr_location_extra_info hlei1,
78: hr_location_extra_info hlei2,
79: per_gen_hierarchy_nodes pgn,
80: hr_locations_all eloc
81: where pgn.hierarchy_version_id = p_hierarchy_version_id
82: and pgn.node_type = 'EST'

Line 343: ,hr_location_extra_info hlei1

339: cursor c_eeo1_extra_info is
340: select 'Y'
341: from
342: per_all_assignments_f ass
343: ,hr_location_extra_info hlei1
344: ,hr_location_extra_info hlei2
345: where
346: ass.person_id = person_id1
347: and report_date_end between ass.effective_start_date

Line 344: ,hr_location_extra_info hlei2

340: select 'Y'
341: from
342: per_all_assignments_f ass
343: ,hr_location_extra_info hlei1
344: ,hr_location_extra_info hlei2
345: where
346: ass.person_id = person_id1
347: and report_date_end between ass.effective_start_date
348: and ass.effective_end_date