DBA Data[Home] [Help]

APPS.GL_AFF_AWC_API_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 87: FROM fnd_id_flex_segments t1,

83: l_structure := fnd_flex_key_api.find_structure(l_flexfield, coa_id);
84:
85: SELECT t1.segment_name, ffvs.validation_type, t1.flex_value_Set_id
86: INTO l_segment_name, l_flex_value_type, l_tab_val_vs
87: FROM fnd_id_flex_segments t1,
88: fnd_segment_attribute_values t2,
89: fnd_flex_value_sets ffvs
90: WHERE t1.application_id = t2.application_id
91: AND t1.id_flex_code = t2.id_flex_code

Line 248: FROM fnd_id_flex_segments t1,

244: l_structure := fnd_flex_key_api.find_structure(l_flexfield, coa_id);
245:
246: SELECT t1.segment_name
247: INTO l_segment_name
248: FROM fnd_id_flex_segments t1,
249: fnd_segment_attribute_values t2,
250: fnd_flex_value_sets ffvs
251: WHERE t1.application_id = t2.application_id
252: AND t1.id_flex_code = t2.id_flex_code