APPS.PQP_RIW_WEBADI_UTILS dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 3552: FROM fnd_descr_flex_column_usages fd,

3548: -- Cursor to get the global segments and the context specific segments for the DFF
3549: CURSOR csr_get_dff_segments (c_dff_name IN VARCHAR2
3550: ,c_context IN VARCHAR2) IS
3551: SELECT fd.application_column_name
3552: FROM fnd_descr_flex_column_usages fd,
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

Line 3574: l_dff_ctx_val fnd_descr_flex_column_usages.descriptive_flex_context_code%TYPE;

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;
3578: