APPS.WSH_DOC_SETS dependencies on FND_DESCR_FLEX_COLUMN_USAGES

Line 38: from fnd_concurrent_programs_vl cp, fnd_descr_flex_column_usages col

34: -- we are trying to phase out OEXSHSKI + OEXSHOBR parameters. Do not use these for new
35: -- reports. instead convert to the new style of parameter/token names
36: /*
37: select cp.concurrent_program_name, col.column_seq_num seq, col.srw_param token, col.required_flag
38: from fnd_concurrent_programs_vl cp, fnd_descr_flex_column_usages col
39: where col.application_id = 300 and cp.application_id = 300
40: and col.descriptive_flexfield_name = '$SRS$.'||cp.Concurrent_program_name
41: and cp.enabled_flag = 'Y'
42: and ( cp.concurrent_program_name ='WSHRDPIK')

Line 191: from fnd_descr_flex_column_usages

187: required_flag,
188: default_value,
189: default_type,
190: flex_value_set_id
191: from fnd_descr_flex_column_usages
192: where application_id = x_application_id
193: and descriptive_flexfield_name = '$SRS$.'||x_concurrent_program_name
194: and enabled_flag = 'Y'
195: order by column_seq_num;