DBA Data[Home] [Help]

APPS.HR_DESCR_FLEX_CONTEXT_INFO dependencies on FND_DESCR_FLEX_CONTEXTS_VL

Line 184: ,fnd_descr_flex_contexts_vl ctx

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
188: AND ctx.application_id = p_application_id

Line 208: ,fnd_descr_flex_contexts_vl ctx

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
212: AND ctx.application_id = p_application_id

Line 218: ,fnd_descr_flex_contexts_vl cx1

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
222: AND cu1.application_column_name = fcu.application_column_name