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_VER_BUS dependencies on PER_GEN_HIERARCHY

Line 222: Per_gen_Hierarchy_Nodes a, Per_gen_Hierarchy_Nodes b

218: l_Result Varchar2(1);
219:
220: Cursor Tariff_Contract is
221: Select '1' from
222: Per_gen_Hierarchy_Nodes a, Per_gen_Hierarchy_Nodes b
223: Where
224: a.Node_Type = 'TARIFF_CONTRACT' and a.Entity_Id = p_rec.Tariff_Contract_Code And
225: b.Node_Type = 'EMP_TYPE' and b.Entity_Id = l_Emp_Type and
226: b.Hierarchy_Node_Id = a.Parent_Hierarchy_Node_Id And

Line 228: Per_Gen_Hierarchy_versions a, Per_gen_Hierarchy b where

224: a.Node_Type = 'TARIFF_CONTRACT' and a.Entity_Id = p_rec.Tariff_Contract_Code And
225: b.Node_Type = 'EMP_TYPE' and b.Entity_Id = l_Emp_Type and
226: b.Hierarchy_Node_Id = a.Parent_Hierarchy_Node_Id And
227: a.Hierarchy_Version_Id in (Select Hierarchy_Version_Id from
228: Per_Gen_Hierarchy_versions a, Per_gen_Hierarchy b where
229: Type = 'REMUNERATION_REGULATION' AND
230: a.Hierarchy_Id = b.Hierarchy_Id And
231: p_effective_date between a.Date_From and Nvl(a.Date_To,Trunc(Sysdate)) and
232: b.Business_Group_Id=p_rec.Business_Group_Id

Line 276: Per_gen_Hierarchy_Nodes a, Per_gen_Hierarchy_Nodes b

272: l_Reslt Varchar2(1);
273:
274: Cursor Tariff_Group is
275: Select '1' from
276: Per_gen_Hierarchy_Nodes a, Per_gen_Hierarchy_Nodes b
277: Where
278: a.Node_Type = 'TARIFF_GROUP' and a.Entity_Id = p_rec.Tariff_Group_Code And
279: b.Node_Type = 'TARIFF_CONTRACT' and b.Entity_Id = p_rec.Tariff_Contract_Code and
280: b.Hierarchy_Node_Id = a.Parent_Hierarchy_Node_Id And

Line 282: Per_Gen_Hierarchy_versions a, Per_gen_Hierarchy b where

278: a.Node_Type = 'TARIFF_GROUP' and a.Entity_Id = p_rec.Tariff_Group_Code And
279: b.Node_Type = 'TARIFF_CONTRACT' and b.Entity_Id = p_rec.Tariff_Contract_Code and
280: b.Hierarchy_Node_Id = a.Parent_Hierarchy_Node_Id And
281: a.Hierarchy_Version_Id in (Select Hierarchy_Version_Id from
282: Per_Gen_Hierarchy_versions a, Per_gen_Hierarchy b where
283: Type = 'REMUNERATION_REGULATION' AND
284: a.Hierarchy_Id = b.Hierarchy_Id And
285: p_effective_date between a.Date_From and Nvl(a.Date_To,Trunc(Sysdate)) and
286: b.Business_Group_Id=p_rec.Business_Group_Id ) and

Line 321: Per_gen_Hierarchy_Nodes a, Per_gen_Hierarchy_Nodes b,

317: Cursor Grade_Dtls(p_Grade_Id In Number) is
318: Select d.Node_Type, d.Entity_Id, e.Node_type, e.Entity_Id,
319: F.Node_type, f.Entity_Id, g.Node_Type, g.Entity_Id
320: from
321: Per_gen_Hierarchy_Nodes a, Per_gen_Hierarchy_Nodes b,
322: Per_gen_Hierarchy_Nodes c, Per_gen_Hierarchy_Nodes d,
323: Per_gen_Hierarchy_Nodes e, Per_gen_Hierarchy_Nodes f,
324: Per_gen_Hierarchy_Nodes g
325: Where

Line 322: Per_gen_Hierarchy_Nodes c, Per_gen_Hierarchy_Nodes d,

318: Select d.Node_Type, d.Entity_Id, e.Node_type, e.Entity_Id,
319: F.Node_type, f.Entity_Id, g.Node_Type, g.Entity_Id
320: from
321: Per_gen_Hierarchy_Nodes a, Per_gen_Hierarchy_Nodes b,
322: Per_gen_Hierarchy_Nodes c, Per_gen_Hierarchy_Nodes d,
323: Per_gen_Hierarchy_Nodes e, Per_gen_Hierarchy_Nodes f,
324: Per_gen_Hierarchy_Nodes g
325: Where
326: a.Node_TYpe = 'PAY_GRADE' and

Line 323: Per_gen_Hierarchy_Nodes e, Per_gen_Hierarchy_Nodes f,

319: F.Node_type, f.Entity_Id, g.Node_Type, g.Entity_Id
320: from
321: Per_gen_Hierarchy_Nodes a, Per_gen_Hierarchy_Nodes b,
322: Per_gen_Hierarchy_Nodes c, Per_gen_Hierarchy_Nodes d,
323: Per_gen_Hierarchy_Nodes e, Per_gen_Hierarchy_Nodes f,
324: Per_gen_Hierarchy_Nodes g
325: Where
326: a.Node_TYpe = 'PAY_GRADE' and
327: a.Entity_Id = p_GRADE_ID and

Line 324: Per_gen_Hierarchy_Nodes g

320: from
321: Per_gen_Hierarchy_Nodes a, Per_gen_Hierarchy_Nodes b,
322: Per_gen_Hierarchy_Nodes c, Per_gen_Hierarchy_Nodes d,
323: Per_gen_Hierarchy_Nodes e, Per_gen_Hierarchy_Nodes f,
324: Per_gen_Hierarchy_Nodes g
325: Where
326: a.Node_TYpe = 'PAY_GRADE' and
327: a.Entity_Id = p_GRADE_ID and
328: b.Hierarchy_node_Id = a.Parent_Hierarchy_Node_Id and

Line 335: Per_Gen_Hierarchy_versions a, Per_gen_Hierarchy b where

331: e.Hierarchy_Node_Id = d.Parent_Hierarchy_Node_Id and
332: f.Hierarchy_Node_Id = e.Parent_Hierarchy_Node_Id and
333: g.Hierarchy_Node_Id = f.Parent_Hierarchy_Node_Id and
334: a.Hierarchy_Version_Id in (Select Hierarchy_Version_Id from
335: Per_Gen_Hierarchy_versions a, Per_gen_Hierarchy b where
336: Type = 'REMUNERATION_REGULATION' AND
337: a.Hierarchy_Id = b.Hierarchy_Id And
338: p_Effective_Date between
339: a.Date_From and Nvl(a.Date_To,Trunc(Sysdate))and

Line 348: g_Node_type Per_gen_hierarchy_Nodes.Node_Type%TYPE;

344: e.Hierarchy_Version_id = a.Hierarchy_Version_id and
345: f.Hierarchy_Version_id = a.Hierarchy_Version_id and
346: g.Hierarchy_Version_id = a.Hierarchy_Version_id;
347:
348: g_Node_type Per_gen_hierarchy_Nodes.Node_Type%TYPE;
349: f_Node_type Per_gen_hierarchy_Nodes.Node_Type%TYPE;
350: e_Node_type Per_gen_hierarchy_Nodes.Node_Type%TYPE;
351: d_Node_type Per_gen_hierarchy_Nodes.Node_Type%TYPE;
352: g_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;

Line 349: f_Node_type Per_gen_hierarchy_Nodes.Node_Type%TYPE;

345: f.Hierarchy_Version_id = a.Hierarchy_Version_id and
346: g.Hierarchy_Version_id = a.Hierarchy_Version_id;
347:
348: g_Node_type Per_gen_hierarchy_Nodes.Node_Type%TYPE;
349: f_Node_type Per_gen_hierarchy_Nodes.Node_Type%TYPE;
350: e_Node_type Per_gen_hierarchy_Nodes.Node_Type%TYPE;
351: d_Node_type Per_gen_hierarchy_Nodes.Node_Type%TYPE;
352: g_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;
353: f_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;

Line 350: e_Node_type Per_gen_hierarchy_Nodes.Node_Type%TYPE;

346: g.Hierarchy_Version_id = a.Hierarchy_Version_id;
347:
348: g_Node_type Per_gen_hierarchy_Nodes.Node_Type%TYPE;
349: f_Node_type Per_gen_hierarchy_Nodes.Node_Type%TYPE;
350: e_Node_type Per_gen_hierarchy_Nodes.Node_Type%TYPE;
351: d_Node_type Per_gen_hierarchy_Nodes.Node_Type%TYPE;
352: g_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;
353: f_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;
354: e_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;

Line 351: d_Node_type Per_gen_hierarchy_Nodes.Node_Type%TYPE;

347:
348: g_Node_type Per_gen_hierarchy_Nodes.Node_Type%TYPE;
349: f_Node_type Per_gen_hierarchy_Nodes.Node_Type%TYPE;
350: e_Node_type Per_gen_hierarchy_Nodes.Node_Type%TYPE;
351: d_Node_type Per_gen_hierarchy_Nodes.Node_Type%TYPE;
352: g_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;
353: f_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;
354: e_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;
355: d_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;

Line 352: g_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;

348: g_Node_type Per_gen_hierarchy_Nodes.Node_Type%TYPE;
349: f_Node_type Per_gen_hierarchy_Nodes.Node_Type%TYPE;
350: e_Node_type Per_gen_hierarchy_Nodes.Node_Type%TYPE;
351: d_Node_type Per_gen_hierarchy_Nodes.Node_Type%TYPE;
352: g_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;
353: f_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;
354: e_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;
355: d_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;
356: l_Grade_id Pqh_De_Wrkplc_Vldtn_Vers.USER_ENTERABLE_GRADE_ID%TYPE := NULL;

Line 353: f_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;

349: f_Node_type Per_gen_hierarchy_Nodes.Node_Type%TYPE;
350: e_Node_type Per_gen_hierarchy_Nodes.Node_Type%TYPE;
351: d_Node_type Per_gen_hierarchy_Nodes.Node_Type%TYPE;
352: g_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;
353: f_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;
354: e_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;
355: d_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;
356: l_Grade_id Pqh_De_Wrkplc_Vldtn_Vers.USER_ENTERABLE_GRADE_ID%TYPE := NULL;
357: l_Cnt Number(2) := 0;

Line 354: e_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;

350: e_Node_type Per_gen_hierarchy_Nodes.Node_Type%TYPE;
351: d_Node_type Per_gen_hierarchy_Nodes.Node_Type%TYPE;
352: g_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;
353: f_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;
354: e_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;
355: d_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;
356: l_Grade_id Pqh_De_Wrkplc_Vldtn_Vers.USER_ENTERABLE_GRADE_ID%TYPE := NULL;
357: l_Cnt Number(2) := 0;
358: Begin

Line 355: d_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;

351: d_Node_type Per_gen_hierarchy_Nodes.Node_Type%TYPE;
352: g_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;
353: f_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;
354: e_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;
355: d_Entity_Id Per_gen_hierarchy_Nodes.Entity_Id%TYPE;
356: l_Grade_id Pqh_De_Wrkplc_Vldtn_Vers.USER_ENTERABLE_GRADE_ID%TYPE := NULL;
357: l_Cnt Number(2) := 0;
358: Begin
359: hr_utility.set_location(l_proc, 10);