APPS.PQH_CPD_HR_TO_STAGE dependencies on PER_GEN_HIERARCHY_NODES

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