APPS.GL_CONS_FLEX_HIER_PKG dependencies on GL_CONS_SEGMENT_MAP

Line 23: FROM gl_cons_flex_hierarchies cfh, gl_cons_segment_map csm

19: ) RETURN NUMBER IS
20:
21: -- The first cursor catches overlaps to the same target
22: CURSOR C1 IS SELECT 'Overlaps'
23: FROM gl_cons_flex_hierarchies cfh, gl_cons_segment_map csm
24: WHERE csm.coa_mapping_id = X_Coa_Mapping_Id
25: AND csm.single_value = X_Parent_Flex_Value
26: AND csm.to_value_set_id = X_To_Value_Set_Id
27: AND csm.from_value_set_id = X_From_Value_Set_Id

Line 46: FROM fnd_flex_value_hierarchies fvh, gl_cons_segment_map csm

42: cfh.child_flex_value_low and cfh.child_flex_value_high))
43: AND ROWIDTOCHAR(cfh.rowid) <> nvl(X_Rowid,'x')
44: UNION
45: SELECT 'Overlaps'
46: FROM fnd_flex_value_hierarchies fvh, gl_cons_segment_map csm
47: WHERE csm.coa_mapping_id = X_Coa_Mapping_Id
48: AND csm.single_value = X_Parent_Flex_Value
49: AND csm.to_value_set_id = X_To_Value_Set_Id
50: AND csm.from_value_set_id = X_From_Value_Set_Id

Line 71: FROM gl_cons_flex_hierarchies cfh, gl_cons_segment_map csm

67: ;
68:
69: -- The second cursor catches overlaps to different targets
70: CURSOR C2 IS SELECT 'Overlaps'
71: FROM gl_cons_flex_hierarchies cfh, gl_cons_segment_map csm
72: WHERE csm.coa_mapping_id = X_Coa_Mapping_Id
73: AND csm.to_value_set_id = X_To_Value_Set_Id
74: AND csm.from_value_set_id = X_From_Value_Set_Id
75: AND csm.to_application_column_name = X_to_application_column_name

Line 93: FROM fnd_flex_value_hierarchies fvh, gl_cons_segment_map csm

89: cfh.child_flex_value_low and cfh.child_flex_value_high))
90: AND ROWIDTOCHAR(cfh.rowid) <> nvl(X_Rowid,'x')
91: UNION
92: SELECT 'Overlaps'
93: FROM fnd_flex_value_hierarchies fvh, gl_cons_segment_map csm
94: WHERE csm.coa_mapping_id = X_Coa_Mapping_Id
95: AND csm.to_value_set_id = X_To_Value_Set_Id
96: AND csm.from_value_set_id = X_From_Value_Set_Id
97: AND csm.to_application_column_name = X_To_Application_Column_Name

Line 176: CURSOR C2 IS SELECT gl_cons_segment_map_s.nextval FROM dual;

172: ) IS
173: CURSOR C IS SELECT rowid FROM gl_cons_flex_hierarchies
174:
175: WHERE segment_map_id = X_Segment_Map_Id;
176: CURSOR C2 IS SELECT gl_cons_segment_map_s.nextval FROM dual;
177: BEGIN
178:
179: if (X_Segment_Map_Id is NULL) then
180: OPEN C2;