APPS.PQH_GENERIC_HIERARCHY_PACKAGE dependencies on PER_GEN_HIERARCHY_VERSIONS

Line 305: per_gen_hierarchy_versions gvr,

301: Is
302: Select ghr.type
303: from
304: per_gen_hierarchy ghr,
305: per_gen_hierarchy_versions gvr,
306: per_gen_hierarchy_nodes gnd
307: where
308: gnd.hierarchy_node_id = p_hierarchy_node_id
309: and gnd.hierarchy_version_id = gvr.hierarchy_version_id

Line 504: per_gen_hierarchy_versions

500: Cursor csr_version_exists
501: is
502: select '1'
503: from
504: per_gen_hierarchy_versions
505: Where
506: hierarchy_id = p_hierarchy_id
507: and p_effective_date between date_from and nvl(date_to,p_effective_date);
508:

Line 1586: From Per_Gen_Hierarchy_Versions

1582: ATTRIBUTE29 , ATTRIBUTE30 , INFORMATION1 , INFORMATION2 , INFORMATION3 , INFORMATION4 , INFORMATION5 , INFORMATION6 , INFORMATION7 , INFORMATION8 ,
1583: INFORMATION9 , INFORMATION10, INFORMATION11, INFORMATION12, INFORMATION13, INFORMATION14, INFORMATION15, INFORMATION16, INFORMATION17, INFORMATION18,
1584: INFORMATION19 , INFORMATION20, INFORMATION21, INFORMATION22, INFORMATION23, INFORMATION24, INFORMATION25, INFORMATION26, INFORMATION27, INFORMATION28,
1585: INFORMATION29 , INFORMATION30, INFORMATION_CATEGORY
1586: From Per_Gen_Hierarchy_Versions
1587: Where ((P_Hierarchy_Version_Id is not NULL and Hierarchy_Version_Id = p_Hierarchy_Version_Id)
1588: or (Hierarchy_Id = P_Hierarchy_Id and P_Effective_Date between Date_From and Nvl(Date_To,p_Effective_Date)));
1589:
1590: Cursor Nodes(C_Hierarchy_Version_id In NUMBER) is

Line 1597: l_Hierarchy_version_id Per_Gen_Hierarchy_Versions.Hierarchy_Version_Id%TYPE;

1593: Where Hierarchy_Version_id = C_Hierarchy_version_id
1594: and Parent_Hierarchy_Node_Id is NULL;
1595:
1596: l_hierarchy_id Per_Gen_Hierarchy.Hierarchy_id%TYPE;
1597: l_Hierarchy_version_id Per_Gen_Hierarchy_Versions.Hierarchy_Version_Id%TYPE;
1598: l_Object_version_Number Per_Gen_hierarchy.Object_Version_Number%TYPE;
1599:
1600: Begin
1601: --

Line 2092: From per_gen_hierarchy_versions

2088: --
2089: Cursor csr_hier_versions
2090: Is
2091: Select 'Y'
2092: From per_gen_hierarchy_versions
2093: Where hierarchy_id = p_hierarchy_id
2094: And rownum < 3;
2095: --
2096: l_proc varchar2(72);

Line 2154: l_Hierarchy_Version_id Per_Gen_Hierarchy_Versions.Hierarchy_version_Id%TYPE;

2150: p_Business_group_Id IN Number ,
2151: p_Effective_Date IN Date) Is
2152:
2153: l_Hierarchy_id Per_Gen_Hierarchy.Hierarchy_Id%TYPE;
2154: l_Hierarchy_Version_id Per_Gen_Hierarchy_Versions.Hierarchy_version_Id%TYPE;
2155: l_HObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
2156: l_Object_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
2157: l_VObject_version_Number Per_Gen_Hierarchy.Object_version_Number%TYPE;
2158: l_Hierarchy_Node_id Per_Gen_Hierarchy_Nodes.Hierarchy_Node_Id%TYPE;

Line 2171: From Per_Gen_hierarchy_Versions pgv, Per_gen_hierarchy pgh

2167:
2168: Cursor C2 is
2169: Select Pgh.Hierarchy_id, pgh.Object_version_number hovn,
2170: pgv.Hierarchy_version_id, pgv.Object_Version_number vovn
2171: From Per_Gen_hierarchy_Versions pgv, Per_gen_hierarchy pgh
2172: Where Hierarchy_Version_id = P_Hierarchy_version_id
2173: and pgv.Hierarchy_id = pgh.Hierarchy_id;
2174:
2175: Cursor C3 is

Line 2185: From Per_Gen_Hierarchy_Versions pgv, Per_Gen_Hierarchy pgh

2181: Order By Nvl(Parent_Hierarchy_Node_id,0) Desc;
2182:
2183: Cursor C4 is
2184: Select count(*)
2185: From Per_Gen_Hierarchy_Versions pgv, Per_Gen_Hierarchy pgh
2186: Where pgh.Hierarchy_id = (Select Hierarchy_id
2187: From Per_Gen_Hierarchy_Versions
2188: Where Hierarchy_Version_Id = P_Hierarchy_Version_Id)
2189: and pgv.hierarchy_id = pgh.hierarchy_id;

Line 2187: From Per_Gen_Hierarchy_Versions

2183: Cursor C4 is
2184: Select count(*)
2185: From Per_Gen_Hierarchy_Versions pgv, Per_Gen_Hierarchy pgh
2186: Where pgh.Hierarchy_id = (Select Hierarchy_id
2187: From Per_Gen_Hierarchy_Versions
2188: Where Hierarchy_Version_Id = P_Hierarchy_Version_Id)
2189: and pgv.hierarchy_id = pgh.hierarchy_id;
2190:
2191: