APPS.PQH_CORPS_COPY dependencies on PER_GEN_HIERARCHY_VERSIONS
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