APPS.OE_VERSION_BLANKET_COMP dependencies on FND_DESCR_FLEX_COL_USAGE_VL

Line 7863: CURSOR c1 IS select form_left_prompt from fnd_descr_flex_col_usage_vl

7859: IS
7860: l_prompt varchar2(2000);
7861: x_prompt varchar2(2000);
7862: slash varchar2(20);
7863: CURSOR c1 IS select form_left_prompt from fnd_descr_flex_col_usage_vl
7864: where application_id=660
7865: and descriptive_flexfield_name= p_descriptive_flexfield_name
7866: and application_column_name =p_application_column_name
7867: 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 7883: select form_left_prompt into l_prompt from fnd_descr_flex_col_usage_vl where application_id=660

7879: ELSE --Attribute Prompt
7880: IF p_descriptive_flex_context_cod IS NULL
7881: AND p_desc_flex_context_cod_prior IS NULL
7882: AND p_desc_flex_context_cod_next IS NULL THEN
7883: select form_left_prompt into l_prompt from fnd_descr_flex_col_usage_vl where application_id=660
7884: and descriptive_flexfield_name= p_descriptive_flexfield_name
7885: and application_column_name =p_application_column_name;
7886:
7887: oe_debug_pub.add('Prompt='||l_prompt);