APPS.GL_FLATTEN_SEG_VAL_HIERARCHIES dependencies on FND_FLEX_VALUES

Line 210: FROM FND_FLEX_VALUES ffv

206: UPDATE GL_SEG_VAL_HIERARCHIES glsvh
207: SET glsvh.status_code = 'U',
208: glsvh.summary_flag =
209: (SELECT DISTINCT ffv.summary_flag
210: FROM FND_FLEX_VALUES ffv
211: WHERE ffv.flex_value_set_id =
212: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
213: AND ffv.flex_value = glsvh.child_flex_value)
214: WHERE glsvh.flex_value_set_id =

Line 219: FROM FND_FLEX_VALUES ffv2

215: GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
216: AND glsvh.parent_flex_value = 'T'
217: AND glsvh.child_flex_value IN
218: (SELECT ffv2.flex_value
219: FROM FND_FLEX_VALUES ffv2
220: WHERE ffv2.flex_value_set_id =
221: glsvh.flex_value_set_id
222: AND ffv2.flex_value = glsvh.child_flex_value
223: AND ffv2.summary_flag <> glsvh.summary_flag);

Line 247: FROM FND_FLEX_VALUES ffv

243: GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
244: SYSDATE, GL_FLATTEN_SETUP_DATA.GLSTFL_User_Id,
245: GL_FLATTEN_SETUP_DATA.GLSTFL_Login_Id,
246: SYSDATE
247: FROM FND_FLEX_VALUES ffv
248: WHERE ffv.flex_value_set_id = GL_FLATTEN_SETUP_DATA.GLSTFL_VS_ID
249: AND NOT EXISTS
250: (SELECT 1
251: FROM GL_SEG_VAL_HIERARCHIES glsvh

Line 272: -- stored in FND_FLEX_VALUES table. Only the detail values will be

268: v2 =>'GL_SEG_VAL_HIERARCHIES');
269:
270: -- Insert 'T'records for table validated value sets.
271: -- For any table validated value set the parent values will always be
272: -- stored in FND_FLEX_VALUES table. Only the detail values will be
273: -- stored in the user defined table. So the above statement takes
274: -- care of all parent values and the following DYNAMIC SQL statement
275: -- inserts all detail records into GL_SEG_VAL_HIERARCHIES table.
276: