GET Code Combination ID

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