APPS.GLXRVSUB_PKG dependencies on FND_ID_FLEX_SEGMENTS

Line 49: FROM fnd_segment_attribute_values fsav, fnd_id_flex_segments fifs

45: /* Defined the cursor seg_cursor to fix bug 2981493 */
46: CURSOR seg_cursor (l_coa_id fnd_segment_attribute_values.id_flex_num%type,
47: l_segment fnd_segment_attribute_values.segment_attribute_type%type) IS
48: SELECT segment_num
49: FROM fnd_segment_attribute_values fsav, fnd_id_flex_segments fifs
50: WHERE fsav.application_id = 101
51: AND fsav.id_flex_code = 'GL#'
52: AND fsav.id_flex_num = l_coa_id
53: AND fsav.segment_attribute_type = l_segment

Line 89: FROM fnd_id_flex_segments

85:
86: BEGIN
87: SELECT flex_value_set_id
88: INTO l_flex_value_set_id
89: FROM fnd_id_flex_segments
90: WHERE application_id = 101
91: AND id_flex_code = 'GL#'
92: AND id_flex_num = l_coa_id
93: AND application_column_name = l_segment_name;