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.XNP_CORE dependencies on XNP_GEO_HIERARCHY

Line 281: FROM xnp_geo_hierarchy

277: AND sysdate >= effective_date;
278:
279: CURSOR c_geo_id (l_starting_geo_id IN NUMBER) IS
280: SELECT child_geo_area_id
281: FROM xnp_geo_hierarchy
282: START WITH child_geo_area_id = l_starting_geo_id
283: CONNECT BY PRIOR parent_geo_area_id = child_geo_area_id;
284:
285: CURSOR c_nrc_id(l_geo_id IN NUMBER) IS