DBA Data[Home] [Help]

APPS.GMI_MSCA_PUB dependencies on FND_GLOBAL

Line 256: AND (responsibility_id = FND_GLOBAL.RESP_id OR responsibility_id IS NULL)) ) )

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 ;
259:
260: EXCEPTION