APPS.PQH_DE_GRADE_COMPUTE dependencies on PER_GEN_HIERARCHY

Line 23: from Per_gen_Hierarchy_Nodes

19: Order By To_Number(Job_Feature_Code) Desc;
20:
21: Cursor Case_group_Algor(p_Entity_Id In Varchar2) is
22: Select Entity_Id, PARENT_HIERARCHY_NODE_ID, Nvl(Information2,0) Perc, Hierarchy_Version_Id
23: from Per_gen_Hierarchy_Nodes
24: Where Node_type = 'JOB_FTR' and
25: Entity_Id = p_Entity_Id and
26: Hierarchy_Version_Id in
27: (Select HIERARCHY_VERSION_ID from

Line 28: Per_gen_Hierarchy_Versions

24: Where Node_type = 'JOB_FTR' and
25: Entity_Id = p_Entity_Id and
26: Hierarchy_Version_Id in
27: (Select HIERARCHY_VERSION_ID from
28: Per_gen_Hierarchy_Versions
29: where Trunc(Sysdate) between Date_From and Nvl(date_To,Sysdate)
30: and Hierarchy_Id in
31: (Select Hierarchy_Id from
32: Per_Gen_Hierarchy

Line 32: Per_Gen_Hierarchy

28: Per_gen_Hierarchy_Versions
29: where Trunc(Sysdate) between Date_From and Nvl(date_To,Sysdate)
30: and Hierarchy_Id in
31: (Select Hierarchy_Id from
32: Per_Gen_Hierarchy
33: Where type = 'REMUNERATION_REGULATION' and Business_Group_id=p_Business_Group_id))
34: Order By Perc Desc;
35:
36: Cursor Grade(p_Hierarchy_Node_id In Varchar2, p_Hierarchy_Version_Id In Number) is

Line 38: Per_gen_Hierarchy_Nodes b, Per_gen_Hierarchy_Nodes a

34: Order By Perc Desc;
35:
36: Cursor Grade(p_Hierarchy_Node_id In Varchar2, p_Hierarchy_Version_Id In Number) is
37: Select a.Entity_Id, b.Entity_Id from
38: Per_gen_Hierarchy_Nodes b, Per_gen_Hierarchy_Nodes a
39: Where a.Node_type = 'CASE_GROUP'
40: and a.Hierarchy_Node_id = p_Hierarchy_Node_id
41: and a.Hierarchy_Version_Id = p_Hierarchy_Version_Id
42: and b.HIERARCHY_NODE_ID = a.PARENT_HIERARCHY_NODE_ID