APPS.GMI_MSCA_PUB dependencies on GMA_REASON_CODE_SECURITY

Line 253: AND ((NVL(FND_PROFILE.VALUE('GMA_REASON_CODE_SECURITY'), 'N') = 'N'

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)
256: AND (responsibility_id = FND_GLOBAL.RESP_id OR responsibility_id IS NULL)) ) )
257: AND reason_code LIKE UPPER(p_reason)

Line 254: OR reason_code IN (SELECT reason_code FROM gma_reason_code_security

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)
256: AND (responsibility_id = FND_GLOBAL.RESP_id OR responsibility_id IS NULL)) ) )
257: AND reason_code LIKE UPPER(p_reason)
258: ORDER BY 1 ;