APPS.EDR_STANDARD dependencies on FND_DESCR_FLEX_COL_USAGE_VL

Line 973: FROM FND_DESCR_FLEX_COL_USAGE_VL

969: P_PROMPT_TYPE IN VARCHAR2,
970: P_COLUMN_PROMPT OUT NOCOPY VARCHAR2) AS
971: CURSOR GET_DESC_FLEX_PROMPT IS
972: SELECT FORM_LEFT_PROMPT, FORM_ABOVE_PROMPT
973: FROM FND_DESCR_FLEX_COL_USAGE_VL
974: WHERE APPLICATION_ID = P_APPLICATION_ID
975: and DESCRIPTIVE_FLEXFIELD_NAME = P_DESC_FLEX_DEF_NAME
976: and DESCRIPTIVE_FLEX_CONTEXT_CODE = P_DESC_FLEX_CONTEXT
977: and APPLICATION_COLUMN_NAME = P_COLUMN_NAME;

Line 1077: FROM FND_DESCR_FLEX_COL_USAGE_VL col_vl,fnd_descr_flex_contexts ctx

1073: CURSOR GET_DESC_FLEX_PROMPTS IS
1074: SELECT col_vl.APPLICATION_COLUMN_NAME,
1075: col_vl.FORM_LEFT_PROMPT,
1076: col_vl.FORM_ABOVE_PROMPT
1077: FROM FND_DESCR_FLEX_COL_USAGE_VL col_vl,fnd_descr_flex_contexts ctx
1078: WHERE col_vl.APPLICATION_ID = P_APPLICATION_ID
1079: and col_vl.DESCRIPTIVE_FLEXFIELD_NAME = P_DESC_FLEX_DEF_NAME
1080: and col_vl.APPLICATION_ID = ctx.APPLICATION_ID
1081: and col_vl.DESCRIPTIVE_FLEXFIELD_NAME = ctx.DESCRIPTIVE_FLEXFIELD_NAME

Line 1089: FROM FND_DESCR_FLEX_COL_USAGE_VL

1085: UNION ALL
1086: SELECT APPLICATION_COLUMN_NAME,
1087: FORM_LEFT_PROMPT,
1088: FORM_ABOVE_PROMPT
1089: FROM FND_DESCR_FLEX_COL_USAGE_VL
1090: WHERE APPLICATION_ID = P_APPLICATION_ID
1091: and DESCRIPTIVE_FLEXFIELD_NAME = P_DESC_FLEX_DEF_NAME
1092: and DESCRIPTIVE_FLEX_CONTEXT_CODE = NVL(P_DESC_FLEX_CONTEXT,' ');
1093:

Line 1354: FROM FND_DESCR_FLEX_COL_USAGE_VL col_vl,fnd_descr_flex_contexts ctx

1350: l_segcount :=0;
1351:
1352: select count(*) INTO l_attrrcount from (
1353: SELECT col_vl.APPLICATION_COLUMN_NAME
1354: FROM FND_DESCR_FLEX_COL_USAGE_VL col_vl,fnd_descr_flex_contexts ctx
1355: WHERE col_vl.APPLICATION_ID = P_APPLICATION_ID
1356: and col_vl.DESCRIPTIVE_FLEXFIELD_NAME = P_DESC_FLEX_DEF_NAME
1357: and col_vl.APPLICATION_ID = ctx.APPLICATION_ID
1358: and col_vl.DESCRIPTIVE_FLEXFIELD_NAME = ctx.DESCRIPTIVE_FLEXFIELD_NAME

Line 1364: FROM FND_DESCR_FLEX_COL_USAGE_VL

1360: and col_vl.DESCRIPTIVE_FLEX_CONTEXT_CODE = ctx.DESCRIPTIVE_FLEX_CONTEXT_CODE
1361: and ctx.GLOBAL_FLAG = 'Y'
1362: UNION ALL
1363: SELECT APPLICATION_COLUMN_NAME
1364: FROM FND_DESCR_FLEX_COL_USAGE_VL
1365: WHERE APPLICATION_ID = P_APPLICATION_ID
1366: and DESCRIPTIVE_FLEXFIELD_NAME = P_DESC_FLEX_DEF_NAME
1367: and DESCRIPTIVE_FLEX_CONTEXT_CODE = NVL(P_DESC_FLEX_CONTEXT,' '));
1368: