DBA Data[Home] [Help]

APPS.HR_DESCR_FLEX_CONTEXT_INFO dependencies on FND_DESCR_FLEX_COL_USAGE_VL

Line 183: FROM fnd_descr_flex_col_usage_vl fcu

179: ,fcu.form_above_prompt
180: ,fcu.form_left_prompt
181: ,fcu.maximum_description_len
182: ,fcu.required_flag
183: FROM fnd_descr_flex_col_usage_vl fcu
184: ,fnd_descr_flex_contexts_vl ctx
185: WHERE fcu.application_id = ctx.application_id
186: AND fcu.descriptive_flexfield_name = ctx.descriptive_flexfield_name
187: AND fcu.descriptive_flex_context_code = ctx.descriptive_flex_context_code

Line 207: FROM fnd_descr_flex_col_usage_vl fcu

203: ,fcu.form_above_prompt
204: ,fcu.form_left_prompt
205: ,fcu.maximum_description_len
206: ,fcu.required_flag
207: FROM fnd_descr_flex_col_usage_vl fcu
208: ,fnd_descr_flex_contexts_vl ctx
209: WHERE fcu.application_id = ctx.application_id
210: AND fcu.descriptive_flexfield_name = ctx.descriptive_flexfield_name
211: AND fcu.descriptive_flex_context_code = ctx.descriptive_flex_context_code

Line 217: FROM fnd_descr_flex_col_usage_vl cu1

213: AND ctx.descriptive_flexfield_name = p_descriptive_flexfield_name
214: AND ctx.global_flag = 'Y'
215: AND ctx.enabled_flag = 'Y'
216: AND NOT EXISTS (SELECT NULL
217: FROM fnd_descr_flex_col_usage_vl cu1
218: ,fnd_descr_flex_contexts_vl cx1
219: WHERE cu1.application_id = cx1.application_id
220: AND cu1.descriptive_flexfield_name = cx1.descriptive_flexfield_name
221: AND cu1.descriptive_flex_context_code = cx1.descriptive_flex_context_code