GET Code Combination Segments

CREATE OR REPLACE FUNCTION APPS.get_account_seg (p_ccid number)
RETURN VARCHAR2 AS
l_segments gl_code_combinations_kfv.concatenated_segments%TYPE;
BEGIN
SELECT kfv.concatenated_segments
into l_segments
FROM gl_code_combinations_kfv kfv
WHERE code_combination_id = p_ccid;
return l_segments;
exception
when others then
return null;

END;
/