DBA Data[Home] [Help]

APPS.ICX_QUESTIONS_ADMIN dependencies on ICX_QUESTIONS_VL

Line 294: FROM ICX_QUESTIONS_VL ICX, FND_APPLICATION_VL FND

290: SELECT FND.APPLICATION_SHORT_NAME,
291: ICX.APPLICATION_ID,
292: ICX.QUESTION_CODE,
293: ICX.QUESTION
294: FROM ICX_QUESTIONS_VL ICX, FND_APPLICATION_VL FND
295: WHERE ICX.QUESTION_CODE LIKE UPPER(P_QUESTION_CODE) || '%'
296: AND ICX.QUESTION LIKE '%' ||P_QUESTION || '%'
297: AND ICX.TYPE = 'QUESTION'
298: AND (FND.APPLICATION_SHORT_NAME LIKE

Line 469: FROM ICX_QUESTIONS_VL ICX, FND_APPLICATION_VL FND

465: INTO L_APPLICATION_SHORT_NAME,
466: L_APPLICATION_ID,
467: L_QUESTION_CODE,
468: L_QUESTION
469: FROM ICX_QUESTIONS_VL ICX, FND_APPLICATION_VL FND
470: WHERE ICX.QUESTION_CODE = P_QUESTION_CODE
471: AND ICX.TYPE = 'QUESTION'
472: AND ICX.APPLICATION_ID = P_APPLICATION_ID
473: AND FND.APPLICATION_ID = ICX.APPLICATION_ID;