APPS.PSP_AUTO_DYN dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 486: FROM fnd_descr_flex_column_usages WHERE descriptive_flexfield_name= p_table_name

482: ELSIF p_type = 'D' then
483:
484: SELECT application_column_name
485: INTO p_appl_column_name
486: FROM fnd_descr_flex_column_usages WHERE descriptive_flexfield_name= p_table_name
487: AND enabled_flag = 'Y'
488: -- AND end_user_column_name = p_parameter ;
489: And application_column_name = p_parameter;
490:

Line 497: fnd_descr_flex_column_usages fdfcu

493:
494: SELECT fdfcu.application_column_name, fifs1.application_column_name, fifs1.flex_value_set_id
495: INTO p_appl_column_name,p_dff_col_name, p_flex_val_set_id
496: FROM fnd_id_flex_structures fifs, fnd_id_flex_segments fifs1, fnd_flex_value_sets ffvs,
497: fnd_descr_flex_column_usages fdfcu
498: WHERE fifs.id_flex_code = p_flex_code
499: and fifs.id_flex_num = (SELECT org_information8 FROM hr_organization_information
500: WHERE organization_id = p_business_group_id and org_information_context = 'Business Group Information')
501: and fifs.application_id = fifs1.application_id and fifs.id_flex_code = fifs1.id_flex_code