DBA Data[Home] [Help]

APPS.GMI_MSCA_PUB dependencies on SY_REAS_CDS

Line 251: FROM sy_reas_cds

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)