APPS.PQP_RIW_WEBADI_UTILS dependencies on FND_DESCRIPTIVE_FLEXS

Line 3130: FROM fnd_descriptive_flexs

3126: -- Cursor to get Delimiter and the Context for a given DFF
3127: CURSOR csr_get_delimiter_and_context (c_dff_name IN VARCHAR2
3128: ,c_app_id IN NUMBER) IS
3129: SELECT concatenated_segment_delimiter, context_column_name
3130: FROM fnd_descriptive_flexs
3131: WHERE descriptive_flexfield_name = (SELECT descriptive_flexfield_name
3132: FROM fnd_descriptive_flexs_tl
3133: WHERE title = c_dff_name
3134: AND language = userenv('LANG'))

Line 3132: FROM fnd_descriptive_flexs_tl

3128: ,c_app_id IN NUMBER) IS
3129: SELECT concatenated_segment_delimiter, context_column_name
3130: FROM fnd_descriptive_flexs
3131: WHERE descriptive_flexfield_name = (SELECT descriptive_flexfield_name
3132: FROM fnd_descriptive_flexs_tl
3133: WHERE title = c_dff_name
3134: AND language = userenv('LANG'))
3135: AND application_id = c_app_id;
3136:

Line 3146: FROM fnd_descriptive_flexs_tl

3142: fnd_descr_flex_col_usage_tl fdtl
3143: WHERE fd.descriptive_flexfield_name = fdtl.descriptive_flexfield_name
3144: AND fd.descriptive_flex_context_code=fdtl.descriptive_flex_context_code
3145: AND fd.descriptive_flexfield_name = (SELECT descriptive_flexfield_name
3146: FROM fnd_descriptive_flexs_tl
3147: WHERE title = c_dff_name
3148: AND language = userenv('LANG'))
3149: AND fd.descriptive_flex_context_code in (c_context)
3150: AND fd.application_column_name = fdtl.application_column_name

Line 3162: l_delimiter fnd_descriptive_flexs.concatenated_segment_delimiter%TYPE;

3158: l_func_name CONSTANT VARCHAR2(150) := g_package || 'Get_Concatanated_DFF_Segments';
3159: -- l_segment_list VARCHAR2(1000);
3160: l_concat_segments VARCHAR2(300);
3161:
3162: l_delimiter fnd_descriptive_flexs.concatenated_segment_delimiter%TYPE;
3163: l_dff_ctx_val fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE;
3164:
3165: l_dyn_sql_qry Varchar(1000);
3166: l_effective_date DATE;