APPS.ICX_QUESTIONS_ADMIN dependencies on FND_APPLICATION_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;

Line 659: FROM FND_APPLICATION_VL FND

655: BEGIN
656:
657: SELECT COUNT(*)
658: INTO l_count
659: FROM FND_APPLICATION_VL FND
660: WHERE FND.APPLICATION_SHORT_NAME = UPPER(P_APPLICATION_SHORT_NAME);
661:
662: if (l_count = 0) THEN
663:

Line 702: FROM FND_APPLICATION_VL FND

698: else
699:
700: SELECT APPLICATION_ID
701: INTO L_APPLICATION_ID
702: FROM FND_APPLICATION_VL FND
703: WHERE FND.APPLICATION_SHORT_NAME = UPPER(P_APPLICATION_SHORT_NAME);
704:
705: ICX_QUESTIONS_PKG.INSERT_ROW (
706: L_ROWID,

Line 753: FROM FND_APPLICATION_VL FND

749: BEGIN
750:
751: SELECT COUNT(*)
752: INTO l_count
753: FROM FND_APPLICATION_VL FND
754: WHERE FND.APPLICATION_SHORT_NAME = UPPER(P_APPLICATION_SHORT_NAME);
755:
756: if (l_count = 0) THEN
757:

Line 937: FROM fnd_application_vl

933: SELECT
934: application_id,
935: application_short_name,
936: application_name
937: FROM fnd_application_vl
938: WHERE application_short_name like UPPER(c_find_criteria)
939: ORDER BY application_short_name;
940:
941: CURSOR c_application_display_value (c_id IN VARCHAR2) IS

Line 944: FROM fnd_application_vl

940:
941: CURSOR c_application_display_value (c_id IN VARCHAR2) IS
942: SELECT
943: application_short_name
944: FROM fnd_application_vl
945: WHERE application_id = c_id;
946:
947: ii NUMBER := 0;
948: nn NUMBER := 0;

Line 966: FROM fnd_application_vl

962: ** how many matches are available.
963: */
964: select count(*)
965: into l_total_rows
966: FROM fnd_application_vl
967: WHERE application_short_name like UPPER(p_display_value||'%');
968:
969: wf_lov.g_define_rec.total_rows := l_total_rows;
970:

Line 1379: FROM fnd_application_vl

1375:
1376: CURSOR c_function_display_value (c_id IN VARCHAR2) IS
1377: SELECT
1378: application_short_name
1379: FROM fnd_application_vl
1380: WHERE application_id = c_id;
1381:
1382: ii NUMBER := 0;
1383: nn NUMBER := 0;