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.HR_PARAMETER_HRMNPSUM dependencies on DUAL

Line 131: from sys.dual

127: i IN Number) IS
128:
129: cursor c_bpl is
130: select -1 plan_id, ' ' plan_name
131: from sys.dual
132: union
133: select plan_id, description plan_name
134: from bisbv_business_plans
135: where current_plan_flag='Y'

Line 201: from dual

197:
198: cursor c_area is
199: select '-1' area_code
200: , ' ' area
201: from dual
202: union
203: select area_code
204: , name area
205: from bis_areas_v

Line 228: from dual

224:
225: cursor c_product_category is
226: select '-1' id
227: , ' ' value
228: from dual
229: UNION
230: select id
231: , value
232: from bis_product_categories_v

Line 282: from dual

278:
279: cursor c_job_category is
280: select '__ALL__' lookup_code
281: , ' ' meaning
282: from dual
283: union
284: select lookup_code, meaning
285: from fnd_common_lookups
286: where lookup_type = 'JOB_CATEGORIES'

Line 422: from dual

418: -- Cursor for Geography Level Parameter
419: cursor c_area is
420: select '-1' area_code
421: , ' ' area
422: from dual
423: union
424: select area_code
425: , name area
426: from bis_areas_v

Line 433: from dual

429: -- Cursor for Geography Value (Country) Parameter
430: cursor c_country is
431: select '-1' territory_code
432: , ' ' country
433: from dual
434: union
435: select territory_code
436: , replace(territory_short_name,'''','_') country
437: from fnd_territories_vl

Line 444: from dual

440: -- Cursor for Geography Value (Region) Parameter
441: cursor c_region is
442: select '-1' region_code
443: , ' ' region
444: from dual
445: union
446: select region_code
447: , name region
448: from bis_regions_v