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 2093: From per_gen_hierarchy_versions

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

Line 2155: l_Hierarchy_Version_id Per_Gen_Hierarchy_Versions.Hierarchy_version_Id%TYPE;

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

Line 2172: From Per_Gen_hierarchy_Versions pgv, Per_gen_hierarchy pgh

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

Line 2186: From Per_Gen_Hierarchy_Versions pgv, Per_Gen_Hierarchy pgh

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

Line 2188: From Per_Gen_Hierarchy_Versions

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