DBA Data[Home] [Help]

APPS.GL_CONS_SEGMENT_MAP_PKG dependencies on FND_FLEX_VALUE_HIERARCHIES

Line 314: fnd_flex_value_hierarchies fvh_curr,

310: -- This only cathes overlaps with the same target specified.
311: CURSOR DUPS3 IS
312: select 'x'
313: from gl_cons_segment_map csm,
314: fnd_flex_value_hierarchies fvh_curr,
315: fnd_flex_value_hierarchies fvh_new
316: where coa_mapping_id = X_Coa_Mapping_id
317: and csm.to_application_column_name = X_To_Application_Column_Name
318: and csm.to_value_set_id = X_To_Value_Set_Id

Line 315: fnd_flex_value_hierarchies fvh_new

311: CURSOR DUPS3 IS
312: select 'x'
313: from gl_cons_segment_map csm,
314: fnd_flex_value_hierarchies fvh_curr,
315: fnd_flex_value_hierarchies fvh_new
316: where coa_mapping_id = X_Coa_Mapping_id
317: and csm.to_application_column_name = X_To_Application_Column_Name
318: and csm.to_value_set_id = X_To_Value_Set_Id
319: and single_value = X_Single_Value

Line 343: fnd_flex_value_hierarchies fvh

339: UNION
340: select 'x'
341: from gl_cons_flex_hierarchies cfh,
342: gl_cons_segment_map csm,
343: fnd_flex_value_hierarchies fvh
344: where csm.segment_map_id = cfh.segment_map_id
345: and csm.coa_mapping_id = X_Coa_Mapping_id
346: and single_value = X_Single_Value
347: and csm.to_application_column_name = X_To_Application_Column_Name

Line 374: fnd_flex_value_hierarchies fvh_curr,

370: -- This will catch overlaps that go to separate targets.
371: CURSOR DUPS4 IS
372: select 'x'
373: from gl_cons_segment_map csm,
374: fnd_flex_value_hierarchies fvh_curr,
375: fnd_flex_value_hierarchies fvh_new
376: where coa_mapping_id = X_Coa_Mapping_id
377: and csm.to_application_column_name = X_To_Application_Column_Name
378: and csm.to_value_set_id = X_To_Value_Set_Id

Line 375: fnd_flex_value_hierarchies fvh_new

371: CURSOR DUPS4 IS
372: select 'x'
373: from gl_cons_segment_map csm,
374: fnd_flex_value_hierarchies fvh_curr,
375: fnd_flex_value_hierarchies fvh_new
376: where coa_mapping_id = X_Coa_Mapping_id
377: and csm.to_application_column_name = X_To_Application_Column_Name
378: and csm.to_value_set_id = X_To_Value_Set_Id
379: and csm.from_application_column_name = X_from_Application_Column_Name

Line 402: fnd_flex_value_hierarchies fvh

398: UNION
399: select 'x'
400: from gl_cons_flex_hierarchies cfh,
401: gl_cons_segment_map csm,
402: fnd_flex_value_hierarchies fvh
403: where csm.segment_map_id = cfh.segment_map_id
404: and csm.coa_mapping_id = X_Coa_Mapping_id
405: and csm.to_application_column_name = X_To_Application_Column_Name
406: and csm.from_application_column_name = X_From_Application_Column_Name