243: IS
244: select fnd.meaning
245: from okc_subclass_roles sur,
246: okc_k_headers_b chr,
247: fnd_lookup_values fnd
248: where fnd.lookup_code = sur.rle_code
249: and sur.rle_code = p_rle_code
250: and fnd.lookup_type = 'OKC_ROLE'
251: and fnd.language = userenv('LANG')
255: and nvl(sur.end_date,sysdate+1) > sysdate;
256:
257:
258:
259: l_rle_code_meaning fnd_lookup_values.meaning%TYPE;
260:
261: BEGIN
262:
263: OPEN l_rle_code_meaning_csr;