DBA Data[Home] [Help]

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