APPS.PQH_CPD_HR_TO_STAGE dependencies on PER_GEN_HIERARCHY

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

Line 7: ,per_gen_hierarchy gh

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
11: AND gvr.version_number = 1;

Line 342: from per_gen_hierarchy_nodes

338: l_hierarchy_version_id number;
339: l_step_cer_id number;
340: cursor csr_pth_rec is
341: select *
342: from per_gen_hierarchy_nodes
343: where information4 = p_corps_definition_id
344: and hierarchy_version_id = l_hierarchy_version_id;
345: begin
346: hr_utility.set_location('inside pth create',10);

Line 739: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PER_GEN_HIERARCHY_NODES',

735: and l_pth_ovn is not null
736: and l_entity_id is not null
737: and l_cpd_id is not null then
738: hr_utility.set_location(' dt mode is '||p_datetrack_mode,30);
739: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PER_GEN_HIERARCHY_NODES',
740: p_key_column_name => 'HIERARCHY_NODE_ID',
741: p_key_column_value => l_pth_id);
742: hr_utility.set_location(' ovn is '||l_db_ovn,30);
743: if l_db_ovn <> l_pth_ovn then