APPS.OE_VERSION_PRICE_ADJUST_COMP dependencies on FND_DESCR_FLEX_COL_USAGE_VL

Line 6285: CURSOR c1 IS select form_left_prompt from fnd_descr_flex_col_usage_vl

6281: IS
6282: l_prompt varchar2(2000);
6283: x_prompt varchar2(2000);
6284: slash varchar2(20);
6285: CURSOR c1 IS select form_left_prompt from fnd_descr_flex_col_usage_vl
6286: where application_id=660
6287: and descriptive_flexfield_name= p_descriptive_flexfield_name
6288: and application_column_name =p_application_column_name
6289: 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 6305: select form_left_prompt into l_prompt from fnd_descr_flex_col_usage_vl where application_id=660

6301: ELSE --Attribute Prompt
6302: IF p_descriptive_flex_context_cod IS NULL
6303: AND p_desc_flex_context_cod_prior IS NULL
6304: AND p_desc_flex_context_cod_next IS NULL THEN
6305: select form_left_prompt into l_prompt from fnd_descr_flex_col_usage_vl where application_id=660
6306: and descriptive_flexfield_name= p_descriptive_flexfield_name
6307: and application_column_name =p_application_column_name;
6308:
6309: oe_debug_pub.add('Prompt='||l_prompt);