APPS.OE_VERSION_COMP dependencies on FND_DESCR_FLEX_COL_USAGE_VL

Line 21432: CURSOR c1 Is select form_left_prompt from fnd_descr_flex_col_usage_vl

21428: IS
21429: l_prompt varchar2(2000);
21430: x_prompt varchar2(2000);
21431: slash varchar2(20);
21432: CURSOR c1 Is select form_left_prompt from fnd_descr_flex_col_usage_vl
21433: where application_id=660
21434: and descriptive_flexfield_name= p_descriptive_flexfield_name
21435: and application_column_name =p_application_column_name
21436: and DESCRIPTIVE_FLEX_CONTEXT_CODE in (p_descriptive_flex_context_cod, p_desc_flex_context_cod_prior, p_desc_flex_context_cod_next, 'Global Data Elements');

Line 21454: select form_left_prompt into l_prompt from fnd_descr_flex_col_usage_vl where application_id=660

21450:
21451: IF p_descriptive_flex_context_cod IS NULL
21452: AND p_desc_flex_context_cod_prior IS NULL
21453: AND p_desc_flex_context_cod_next IS NULL THEN
21454: select form_left_prompt into l_prompt from fnd_descr_flex_col_usage_vl where application_id=660
21455: and descriptive_flexfield_name= p_descriptive_flexfield_name
21456: and application_column_name =p_application_column_name;
21457:
21458: oe_debug_pub.add('Prompt='||l_prompt);