APPS.PQP_RIW_WEBADI_UTILS dependencies on FND_DESCRIPTIVE_FLEXS

Line 3541: FROM fnd_descriptive_flexs

3537: -- Cursor to get Delimiter and the Context for a given DFF
3538: CURSOR csr_get_delimiter_and_context (c_dff_name IN VARCHAR2
3539: ,c_app_id IN NUMBER) IS
3540: SELECT concatenated_segment_delimiter, context_column_name
3541: FROM fnd_descriptive_flexs
3542: WHERE descriptive_flexfield_name = (SELECT descriptive_flexfield_name
3543: FROM fnd_descriptive_flexs_tl
3544: WHERE title = c_dff_name
3545: AND language = 'US')

Line 3543: FROM fnd_descriptive_flexs_tl

3539: ,c_app_id IN NUMBER) IS
3540: SELECT concatenated_segment_delimiter, context_column_name
3541: FROM fnd_descriptive_flexs
3542: WHERE descriptive_flexfield_name = (SELECT descriptive_flexfield_name
3543: FROM fnd_descriptive_flexs_tl
3544: WHERE title = c_dff_name
3545: AND language = 'US')
3546: AND application_id = c_app_id;
3547:

Line 3557: FROM fnd_descriptive_flexs_tl

3553: fnd_descr_flex_col_usage_tl fdtl
3554: WHERE fd.descriptive_flexfield_name = fdtl.descriptive_flexfield_name
3555: AND fd.descriptive_flex_context_code=fdtl.descriptive_flex_context_code
3556: AND fd.descriptive_flexfield_name = (SELECT descriptive_flexfield_name
3557: FROM fnd_descriptive_flexs_tl
3558: WHERE title = c_dff_name
3559: AND language = 'US')
3560: AND fd.descriptive_flex_context_code in (c_context)
3561: AND fd.application_column_name = fdtl.application_column_name

Line 3573: l_delimiter fnd_descriptive_flexs.concatenated_segment_delimiter%TYPE;

3569: l_func_name CONSTANT VARCHAR2(150) := g_package || 'Get_Concatanated_DFF_Segments';
3570: -- l_segment_list VARCHAR2(1000);
3571: l_concat_segments VARCHAR2(300);
3572:
3573: l_delimiter fnd_descriptive_flexs.concatenated_segment_delimiter%TYPE;
3574: l_dff_ctx_val fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE;
3575:
3576: l_dyn_sql_qry Varchar(4000);
3577: l_effective_date DATE;