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.PQH_RSS_BUS dependencies on PER_GEN_HIERARCHY

Line 272: per_gen_hierarchy pgh,

268: Cursor c_CIVIL_SERVANTS_Grade_id is
269: SELECT
270: pg.NAME
271: FROM
272: per_gen_hierarchy pgh,
273: per_gen_hierarchy_versions pghv,
274: per_gen_hierarchy_nodes pghn,
275: PER_GEN_HIERARCHY_NODES pghn1 ,
276: PER_GEN_HIERARCHY_NODES pghn2 ,

Line 273: per_gen_hierarchy_versions pghv,

269: SELECT
270: pg.NAME
271: FROM
272: per_gen_hierarchy pgh,
273: per_gen_hierarchy_versions pghv,
274: per_gen_hierarchy_nodes pghn,
275: PER_GEN_HIERARCHY_NODES pghn1 ,
276: PER_GEN_HIERARCHY_NODES pghn2 ,
277: PER_GEN_HIERARCHY_NODES pghn3 ,

Line 274: per_gen_hierarchy_nodes pghn,

270: pg.NAME
271: FROM
272: per_gen_hierarchy pgh,
273: per_gen_hierarchy_versions pghv,
274: per_gen_hierarchy_nodes pghn,
275: PER_GEN_HIERARCHY_NODES pghn1 ,
276: PER_GEN_HIERARCHY_NODES pghn2 ,
277: PER_GEN_HIERARCHY_NODES pghn3 ,
278: PER_GEN_HIERARCHY_NODES pghn4 ,

Line 275: PER_GEN_HIERARCHY_NODES pghn1 ,

271: FROM
272: per_gen_hierarchy pgh,
273: per_gen_hierarchy_versions pghv,
274: per_gen_hierarchy_nodes pghn,
275: PER_GEN_HIERARCHY_NODES pghn1 ,
276: PER_GEN_HIERARCHY_NODES pghn2 ,
277: PER_GEN_HIERARCHY_NODES pghn3 ,
278: PER_GEN_HIERARCHY_NODES pghn4 ,
279: PER_GEN_HIERARCHY_NODES pghn5 ,

Line 276: PER_GEN_HIERARCHY_NODES pghn2 ,

272: per_gen_hierarchy pgh,
273: per_gen_hierarchy_versions pghv,
274: per_gen_hierarchy_nodes pghn,
275: PER_GEN_HIERARCHY_NODES pghn1 ,
276: PER_GEN_HIERARCHY_NODES pghn2 ,
277: PER_GEN_HIERARCHY_NODES pghn3 ,
278: PER_GEN_HIERARCHY_NODES pghn4 ,
279: PER_GEN_HIERARCHY_NODES pghn5 ,
280: PER_GEN_HIERARCHY_NODES pghn6 ,

Line 277: PER_GEN_HIERARCHY_NODES pghn3 ,

273: per_gen_hierarchy_versions pghv,
274: per_gen_hierarchy_nodes pghn,
275: PER_GEN_HIERARCHY_NODES pghn1 ,
276: PER_GEN_HIERARCHY_NODES pghn2 ,
277: PER_GEN_HIERARCHY_NODES pghn3 ,
278: PER_GEN_HIERARCHY_NODES pghn4 ,
279: PER_GEN_HIERARCHY_NODES pghn5 ,
280: PER_GEN_HIERARCHY_NODES pghn6 ,
281: PER_GRADES_VL pg

Line 278: PER_GEN_HIERARCHY_NODES pghn4 ,

274: per_gen_hierarchy_nodes pghn,
275: PER_GEN_HIERARCHY_NODES pghn1 ,
276: PER_GEN_HIERARCHY_NODES pghn2 ,
277: PER_GEN_HIERARCHY_NODES pghn3 ,
278: PER_GEN_HIERARCHY_NODES pghn4 ,
279: PER_GEN_HIERARCHY_NODES pghn5 ,
280: PER_GEN_HIERARCHY_NODES pghn6 ,
281: PER_GRADES_VL pg
282: WHERE pgh.TYPE='REMUNERATION_REGULATION'

Line 279: PER_GEN_HIERARCHY_NODES pghn5 ,

275: PER_GEN_HIERARCHY_NODES pghn1 ,
276: PER_GEN_HIERARCHY_NODES pghn2 ,
277: PER_GEN_HIERARCHY_NODES pghn3 ,
278: PER_GEN_HIERARCHY_NODES pghn4 ,
279: PER_GEN_HIERARCHY_NODES pghn5 ,
280: PER_GEN_HIERARCHY_NODES pghn6 ,
281: PER_GRADES_VL pg
282: WHERE pgh.TYPE='REMUNERATION_REGULATION'
283: and pgh.HIERARCHY_ID=pghv.HIERARCHY_ID

Line 280: PER_GEN_HIERARCHY_NODES pghn6 ,

276: PER_GEN_HIERARCHY_NODES pghn2 ,
277: PER_GEN_HIERARCHY_NODES pghn3 ,
278: PER_GEN_HIERARCHY_NODES pghn4 ,
279: PER_GEN_HIERARCHY_NODES pghn5 ,
280: PER_GEN_HIERARCHY_NODES pghn6 ,
281: PER_GRADES_VL pg
282: WHERE pgh.TYPE='REMUNERATION_REGULATION'
283: and pgh.HIERARCHY_ID=pghv.HIERARCHY_ID
284: and p_Effective_Date between pghv.Date_from and Nvl(pghv.Date_To,Trunc(Sysdate))

Line 299: per_gen_hierarchy pgh,

295: and pg.GRADE_ID = pghn.ENTITY_ID
296: union all
297: select pg.NAME
298: from
299: per_gen_hierarchy pgh,
300: per_gen_hierarchy_versions pghv,
301: per_gen_hierarchy_nodes pghn,
302: PER_GEN_HIERARCHY_NODES pghn1 ,
303: PER_GEN_HIERARCHY_NODES pghn2 ,

Line 300: per_gen_hierarchy_versions pghv,

296: union all
297: select pg.NAME
298: from
299: per_gen_hierarchy pgh,
300: per_gen_hierarchy_versions pghv,
301: per_gen_hierarchy_nodes pghn,
302: PER_GEN_HIERARCHY_NODES pghn1 ,
303: PER_GEN_HIERARCHY_NODES pghn2 ,
304: PER_GEN_HIERARCHY_NODES pghn3 ,

Line 301: per_gen_hierarchy_nodes pghn,

297: select pg.NAME
298: from
299: per_gen_hierarchy pgh,
300: per_gen_hierarchy_versions pghv,
301: per_gen_hierarchy_nodes pghn,
302: PER_GEN_HIERARCHY_NODES pghn1 ,
303: PER_GEN_HIERARCHY_NODES pghn2 ,
304: PER_GEN_HIERARCHY_NODES pghn3 ,
305: PER_GEN_HIERARCHY_NODES pghn4 ,

Line 302: PER_GEN_HIERARCHY_NODES pghn1 ,

298: from
299: per_gen_hierarchy pgh,
300: per_gen_hierarchy_versions pghv,
301: per_gen_hierarchy_nodes pghn,
302: PER_GEN_HIERARCHY_NODES pghn1 ,
303: PER_GEN_HIERARCHY_NODES pghn2 ,
304: PER_GEN_HIERARCHY_NODES pghn3 ,
305: PER_GEN_HIERARCHY_NODES pghn4 ,
306: PER_GEN_HIERARCHY_NODES pghn5 ,

Line 303: PER_GEN_HIERARCHY_NODES pghn2 ,

299: per_gen_hierarchy pgh,
300: per_gen_hierarchy_versions pghv,
301: per_gen_hierarchy_nodes pghn,
302: PER_GEN_HIERARCHY_NODES pghn1 ,
303: PER_GEN_HIERARCHY_NODES pghn2 ,
304: PER_GEN_HIERARCHY_NODES pghn3 ,
305: PER_GEN_HIERARCHY_NODES pghn4 ,
306: PER_GEN_HIERARCHY_NODES pghn5 ,
307: PER_GEN_HIERARCHY_NODES pghn6 ,

Line 304: PER_GEN_HIERARCHY_NODES pghn3 ,

300: per_gen_hierarchy_versions pghv,
301: per_gen_hierarchy_nodes pghn,
302: PER_GEN_HIERARCHY_NODES pghn1 ,
303: PER_GEN_HIERARCHY_NODES pghn2 ,
304: PER_GEN_HIERARCHY_NODES pghn3 ,
305: PER_GEN_HIERARCHY_NODES pghn4 ,
306: PER_GEN_HIERARCHY_NODES pghn5 ,
307: PER_GEN_HIERARCHY_NODES pghn6 ,
308: PER_GEN_HIERARCHY_NODES pghn7 ,

Line 305: PER_GEN_HIERARCHY_NODES pghn4 ,

301: per_gen_hierarchy_nodes pghn,
302: PER_GEN_HIERARCHY_NODES pghn1 ,
303: PER_GEN_HIERARCHY_NODES pghn2 ,
304: PER_GEN_HIERARCHY_NODES pghn3 ,
305: PER_GEN_HIERARCHY_NODES pghn4 ,
306: PER_GEN_HIERARCHY_NODES pghn5 ,
307: PER_GEN_HIERARCHY_NODES pghn6 ,
308: PER_GEN_HIERARCHY_NODES pghn7 ,
309: PER_GRADES_VL pg

Line 306: PER_GEN_HIERARCHY_NODES pghn5 ,

302: PER_GEN_HIERARCHY_NODES pghn1 ,
303: PER_GEN_HIERARCHY_NODES pghn2 ,
304: PER_GEN_HIERARCHY_NODES pghn3 ,
305: PER_GEN_HIERARCHY_NODES pghn4 ,
306: PER_GEN_HIERARCHY_NODES pghn5 ,
307: PER_GEN_HIERARCHY_NODES pghn6 ,
308: PER_GEN_HIERARCHY_NODES pghn7 ,
309: PER_GRADES_VL pg
310: where pgh.TYPE='REMUNERATION_REGULATION'

Line 307: PER_GEN_HIERARCHY_NODES pghn6 ,

303: PER_GEN_HIERARCHY_NODES pghn2 ,
304: PER_GEN_HIERARCHY_NODES pghn3 ,
305: PER_GEN_HIERARCHY_NODES pghn4 ,
306: PER_GEN_HIERARCHY_NODES pghn5 ,
307: PER_GEN_HIERARCHY_NODES pghn6 ,
308: PER_GEN_HIERARCHY_NODES pghn7 ,
309: PER_GRADES_VL pg
310: where pgh.TYPE='REMUNERATION_REGULATION'
311: and pgh.HIERARCHY_ID=pghv.HIERARCHY_ID

Line 308: PER_GEN_HIERARCHY_NODES pghn7 ,

304: PER_GEN_HIERARCHY_NODES pghn3 ,
305: PER_GEN_HIERARCHY_NODES pghn4 ,
306: PER_GEN_HIERARCHY_NODES pghn5 ,
307: PER_GEN_HIERARCHY_NODES pghn6 ,
308: PER_GEN_HIERARCHY_NODES pghn7 ,
309: PER_GRADES_VL pg
310: where pgh.TYPE='REMUNERATION_REGULATION'
311: and pgh.HIERARCHY_ID=pghv.HIERARCHY_ID
312: and p_Effective_Date between pghv.Date_from and Nvl(pghv.Date_To,Trunc(Sysdate))