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.POA_EDW_GEOGRAPHY_M_SIZE dependencies on HR_LOCATIONS_ALL

Line 23: from hr_locations_all

19: and greatest(vns.last_update_date, vnd.last_update_date)
20: between p_from_date and p_to_date
21: union all
22: select count(*) cnt
23: from hr_locations_all
24: where last_update_date between p_from_date and p_to_date
25: union all
26: select count(*) cnt
27: from

Line 158: from HR_LOCATIONS_ALL where last_update_date

154: avg(nvl(vsize(address_line_1),0)),
155: avg(nvl(vsize(address_line_2),0)),
156: avg(nvl(vsize(address_line_3),0)),
157: avg(nvl(vsize(location_code),0))
158: from HR_LOCATIONS_ALL where last_update_date
159: between p_from_date and p_to_date;
160:
161: cursor c3 is
162: select avg(nvl(vsize(city),0)),