APPS.PQH_DE_OPR_GRP dependencies on PER_GEN_HIERARCHY_VERSIONS

Line 245: l_Hierarchy_Version_id Per_Gen_Hierarchy_Versions.Hierarchy_version_Id%TYPE;

241: p_Business_group_Id IN Number ,
242: p_Effective_Date IN Date) Is
243:
244: l_Hierarchy_id Per_Gen_Hierarchy.Hierarchy_Id%TYPE;
245: l_Hierarchy_Version_id Per_Gen_Hierarchy_Versions.Hierarchy_version_Id%TYPE;
246: l_HObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
247: l_Object_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
248: l_VObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
249: l_Hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Hierarchy_Node_Id%TYPE;

Line 263: From Per_Gen_hierarchy_Versions pgv, Per_gen_hierarchy pgh

259:
260: Cursor C2 is
261: Select Pgh.Hierarchy_id, pgh.Object_version_number hovn,
262: pgv.Hierarchy_version_id, pgv.Object_Version_number vovn
263: From Per_Gen_hierarchy_Versions pgv, Per_gen_hierarchy pgh
264: Where Hierarchy_Version_id = P_Hierarchy_version_id
265: and pgv.Hierarchy_id = pgh.Hierarchy_id;
266:
267: Cursor C3 is

Line 277: From Per_Gen_Hierarchy_Versions pgv, Per_Gen_Hierarchy pgh

273: Order By Nvl(Parent_Hierarchy_Node_id,0) Desc;
274:
275: Cursor C4 is
276: Select count(*)
277: From Per_Gen_Hierarchy_Versions pgv, Per_Gen_Hierarchy pgh
278: Where pgh.Hierarchy_id = (Select Hierarchy_id
279: From Per_Gen_Hierarchy_Versions
280: Where Hierarchy_Version_Id = P_Hierarchy_Version_Id)
281: and pgv.hierarchy_id = pgh.hierarchy_id;

Line 279: From Per_Gen_Hierarchy_Versions

275: Cursor C4 is
276: Select count(*)
277: From Per_Gen_Hierarchy_Versions pgv, Per_Gen_Hierarchy pgh
278: Where pgh.Hierarchy_id = (Select Hierarchy_id
279: From Per_Gen_Hierarchy_Versions
280: Where Hierarchy_Version_Id = P_Hierarchy_Version_Id)
281: and pgv.hierarchy_id = pgh.hierarchy_id;
282:
283:

Line 505: From Per_Gen_Hierarchy_Versions

501: ATTRIBUTE29 , ATTRIBUTE30 , INFORMATION1 , INFORMATION2 , INFORMATION3 , INFORMATION4 , INFORMATION5 , INFORMATION6 , INFORMATION7 , INFORMATION8 ,
502: INFORMATION9 , INFORMATION10, INFORMATION11, INFORMATION12, INFORMATION13, INFORMATION14, INFORMATION15, INFORMATION16, INFORMATION17, INFORMATION18,
503: INFORMATION19 , INFORMATION20, INFORMATION21, INFORMATION22, INFORMATION23, INFORMATION24, INFORMATION25, INFORMATION26, INFORMATION27, INFORMATION28,
504: INFORMATION29 , INFORMATION30, INFORMATION_CATEGORY
505: From Per_Gen_Hierarchy_Versions
506: Where ((P_Hierarchy_Version_Id is not NULL and Hierarchy_Version_Id = p_Hierarchy_Version_Id)
507: or (Hierarchy_Id = P_Hierarchy_Id and P_Effective_Date between Date_From and Nvl(Date_To,p_Effective_Date)));
508:
509: Cursor Nodes(C_Hierarchy_Version_id In NUMBER) is

Line 516: l_Hierarchy_version_id Per_Gen_Hierarchy_Versions.Hierarchy_Version_Id%TYPE;

512: Where Hierarchy_Version_id = C_Hierarchy_version_id
513: and Parent_Hierarchy_Node_Id is NULL;
514:
515: l_hierarchy_id Per_Gen_Hierarchy.Hierarchy_id%TYPE;
516: l_Hierarchy_version_id Per_Gen_Hierarchy_Versions.Hierarchy_Version_Id%TYPE;
517: l_Object_version_Number Per_Gen_hierarchy.Object_Version_Number%TYPE;
518:
519: Begin
520: