APPS.PQH_DE_OPERATION dependencies on PER_GEN_HIERARCHY_VERSIONS

Line 14: l_Hierarchy_Version_Id Per_gen_Hierarchy_Versions.Hierarchy_Version_Id%TYPE;

10: ,p_HIERARCHY_NODE_ID Out NOCOPY NUMBER
11: ,p_Status Out NOCOPY Varchar2
12: ,p_Object_Version_Number Out NOCOPY Number) Is
13:
14: l_Hierarchy_Version_Id Per_gen_Hierarchy_Versions.Hierarchy_Version_Id%TYPE;
15: l_Hierarchy_Node_Id Per_gen_Hierarchy_Nodes.Hierarchy_Node_Id%TYPE;
16: l_Parent_Hierarchy_Node_Id Per_gen_Hierarchy_Nodes.Parent_Hierarchy_Node_Id%TYPE;
17: l_Node_type Per_gen_Hierarchy_Nodes.Node_Type%TYPE;
18: l_seq Per_gen_Hierarchy_Nodes.Seq%TYPE;

Line 273: From Per_Gen_Hierarchy_Nodes a, Per_gen_hierarchy_Versions b

269: and WRKPLC_VLDTN_OPR_JOB_TYPE = Type;
270:
271: Cursor Hierarchy_Data(p_Entity_Id In VARCHAR2, P_Node_Type in Varchar2) is
272: Select Hierarchy_Node_Id, a.Hierarchy_Version_Id, Parent_Hierarchy_Node_Id, Node_type
273: From Per_Gen_Hierarchy_Nodes a, Per_gen_hierarchy_Versions b
274: Where Node_Type = P_Node_Type
275: and Entity_Id = p_Entity_Id
276: and b.Hierarchy_Version_Id = a.Hierarchy_Version_Id
277: and trunc(P_effective_Date) between date_From and nvl(Date_To,trunc(P_effective_Date));