APPS.PQH_CPD_HR_TO_STAGE dependencies on PER_GEN_HIERARCHY_VERSIONS

Line 6: FROM per_gen_hierarchy_versions gvr

2: /* $Header: pqcpdhrs.pkb 120.2 2010/03/04 06:42:35 sidsaxen ship $ */
3: function get_crpth_hier_ver return number is
4: cursor c1 is
5: SELECT gvr.hierarchy_version_id
6: FROM per_gen_hierarchy_versions gvr
7: ,per_gen_hierarchy gh
8: WHERE gh.type = 'CAREER_PATH'
9: AND gh.name = 'Corps Carrer Path ' --the seeded hierarchy name has a space in it.
10: AND gh.hierarchy_id = gvr.hierarchy_id