APPS.PQH_CORPS_COPY dependencies on PER_GEN_HIERARCHY

Line 76: from per_gen_hierarchy ghr, per_gen_hierarchy_versions ghv

72: l_hier_ver_id number;
73: l_nodes number;
74: cursor c1 is
75: select ghv.hierarchy_version_id hier_ver
76: from per_gen_hierarchy ghr, per_gen_hierarchy_versions ghv
77: where ghr.hierarchy_id = ghv.hierarchy_id
78: and ghr.type ='CAREER_PATH'
79: order by ghv.hierarchy_version_id;
80: begin

Line 86: from per_gen_hierarchy_nodes

82: if l_hier_ver_id is null then
83: l_hier_ver_id := i.hier_ver;
84: end if;
85: select count(*) into l_nodes
86: from per_gen_hierarchy_nodes
87: where hierarchy_version_id = i.hier_ver;
88: if l_nodes >0 then
89: l_hier_ver_id := i.hier_ver;
90: exit;

Line 110: cursor csr_career_path is select 'X' from per_gen_hierarchy_nodes

106: p_node_id out nocopy number,
107: p_object_version_number out nocopy number) is
108: l_node_type varchar2(30) := 'CAREER_NODE';
109: l_path varchar2(30);
110: cursor csr_career_path is select 'X' from per_gen_hierarchy_nodes
111: where entity_id = to_char(p_starting_grade_step_id)
112: and information3 = p_ending_grade_step_id
113: and information4 = p_from_corps_definition_id
114: and information9 = p_to_corps_definition_id

Line 175: cursor csr_check is select 'X' from per_gen_hierarchy_nodes

171: ) is
172: l_node_type varchar2(30) := 'CAREER_NODE';
173: l_path varchar2(30);
174: l_object_version_number number := p_object_version_number;
175: cursor csr_check is select 'X' from per_gen_hierarchy_nodes
176: where hierarchy_node_id = p_node_id
177: and object_version_number = p_object_version_number;
178: cursor csr_career_path is select 'X' from per_gen_hierarchy_nodes
179: where entity_id = to_char(p_starting_grade_step_id)

Line 178: cursor csr_career_path is select 'X' from per_gen_hierarchy_nodes

174: l_object_version_number number := p_object_version_number;
175: cursor csr_check is select 'X' from per_gen_hierarchy_nodes
176: where hierarchy_node_id = p_node_id
177: and object_version_number = p_object_version_number;
178: cursor csr_career_path is select 'X' from per_gen_hierarchy_nodes
179: where entity_id = to_char(p_starting_grade_step_id)
180: and information3 = p_ending_grade_step_id
181: and information4 = p_from_corps_definition_id
182: and information9 = p_to_corps_definition_id

Line 235: cursor csr_career_path is select 'X' from per_gen_hierarchy_nodes

231: raise;
232: end update_career_path;
233: procedure delete_career_path(p_node_id in number,
234: p_object_version_number in number) is
235: cursor csr_career_path is select 'X' from per_gen_hierarchy_nodes
236: where hierarchy_node_id = p_node_id
237: and object_version_number = p_object_version_number;
238: l_check varchar2(30);
239: begin