APPS.EDW_GL_CONSOLIDATION SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 27

SELECT 	cfh.parent_flex_value 	parent,
	csm.segment_map_type 	segment_map_type
FROM	gl_cons_segment_map 	csm,
        gl_cons_flex_hierarchies cfh
WHERE 	cfh.segment_map_id 	= csm.segment_map_id
AND	csm.segment_map_type 	= 'R'
AND	csm.from_value_set_id 	= p_from_value_set_id
AND	csm.to_value_set_id	= p_to_value_set_id
AND	csm.coa_mapping_id	= p_coa_mapping_id
AND	p_from_value between cfh.child_flex_value_low
		         and cfh.child_flex_value_high
UNION ALL
SELECT	csm.single_value 	parent,
	csm.segment_map_type 	segment_map_type
FROM	gl_cons_segment_map 	csm
WHERE	csm.segment_map_type 	= 'P'
AND	csm.from_value_set_id 	= p_from_value_set_id
AND	csm.to_value_set_id	= p_to_value_set_id
AND	csm.coa_mapping_id	= p_coa_mapping_id
AND	p_from_value		= csm.parent_rollup_value
UNION ALL
SELECT	csm.single_value 	parent,
	csm.segment_map_type 	segment_map_type
FROM	gl_cons_segment_map 	csm
WHERE	csm.segment_map_type	= 'C'
AND	csm.from_value_set_id 	= p_from_value_set_id
AND	csm.to_value_set_id	= p_to_value_set_id
AND	csm.coa_mapping_id	= p_coa_mapping_id
UNION ALL
SELECT	csm.single_value 	parent,
	csm.segment_map_type 	segment_map_type
FROM	gl_cons_segment_map 	csm
WHERE	csm.segment_map_type	= 'S'
AND	csm.to_value_set_id	= p_to_value_set_id
AND	csm.coa_mapping_id	= p_coa_mapping_id;