APPS.PSP_AUTO_DYN dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 469: FROM fnd_descr_flex_column_usages WHERE descriptive_flexfield_name= p_table_name

465: ELSIF p_type = 'D' then
466:
467: SELECT application_column_name
468: INTO p_appl_column_name
469: FROM fnd_descr_flex_column_usages WHERE descriptive_flexfield_name= p_table_name
470: AND enabled_flag = 'Y'
471: -- AND end_user_column_name = p_parameter ;
472: And application_column_name = p_parameter;
473:

Line 480: fnd_descr_flex_column_usages fdfcu

476:
477: SELECT fdfcu.application_column_name, fifs1.application_column_name, fifs1.flex_value_set_id
478: INTO p_appl_column_name,p_dff_col_name, p_flex_val_set_id
479: FROM fnd_id_flex_structures fifs, fnd_id_flex_segments fifs1, fnd_flex_value_sets ffvs,
480: fnd_descr_flex_column_usages fdfcu
481: WHERE fifs.id_flex_code = p_flex_code
482: and fifs.id_flex_num = (SELECT org_information8 FROM hr_organization_information
483: WHERE organization_id = p_business_group_id and org_information_context = 'Business Group Information')
484: and fifs.application_id = fifs1.application_id and fifs.id_flex_code = fifs1.id_flex_code