213: -- p_concat_segments has not been entered as a parameter
214: --
215: cursor c_name is
216: select name
217: from per_competences_vl
218: where competence_definition_id = l_competence_definition_id;
219: --
220: begin
221: --
962: -- p_concat_segments has not entered as a param
963: --
964: cursor c_name is
965: select name
966: from per_competences_vl
967: where competence_definition_id = l_competence_definition_id;
968: --
969: begin
970: --
1692:
1693: cursor csr_cpn(p_competence_name in varchar2)
1694: is
1695: select competence_id , object_version_number
1696: from per_competences_v
1697: where business_group_id is null
1698: and name = p_competence_name;
1699:
1700: cursor csr_rsc