247: -- 11.5.10
248:
249: OPEN x_reason_cursor FOR
250: SELECT reason_code, reason_desc1, reason_type 251: FROM sy_reas_cds 252: WHERE delete_mark = 0
253: AND ((NVL(FND_PROFILE.VALUE('GMA_REASON_CODE_SECURITY'), 'N') = 'N'
254: OR reason_code IN (SELECT reason_code FROM gma_reason_code_security
255: WHERE (doc_type = p_doc_type or doc_type IS NULL)