APPS.OE_VERSION_COMP dependencies on FND_DESCR_FLEX_COL_USAGE_VL

Line 22049: CURSOR c1 Is select form_left_prompt from fnd_descr_flex_col_usage_vl

22045: IS
22046: l_prompt varchar2(2000);
22047: x_prompt varchar2(2000);
22048: slash varchar2(20);
22049: CURSOR c1 Is select form_left_prompt from fnd_descr_flex_col_usage_vl
22050: where application_id=660
22051: and descriptive_flexfield_name= p_descriptive_flexfield_name
22052: and application_column_name =p_application_column_name
22053: 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 22071: select form_left_prompt into l_prompt from fnd_descr_flex_col_usage_vl where application_id=660

22067:
22068: IF p_descriptive_flex_context_cod IS NULL
22069: AND p_desc_flex_context_cod_prior IS NULL
22070: AND p_desc_flex_context_cod_next IS NULL THEN
22071: select form_left_prompt into l_prompt from fnd_descr_flex_col_usage_vl where application_id=660
22072: and descriptive_flexfield_name= p_descriptive_flexfield_name
22073: and application_column_name =p_application_column_name;
22074:
22075: oe_debug_pub.add('Prompt='||l_prompt);