DBA Data[Home] [Help]

APPS.GLXRVSUB_PKG dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 46: CURSOR seg_cursor (l_coa_id fnd_segment_attribute_values.id_flex_num%type,

42: l_application_column_name VARCHAR2(30);
43: l_seg_num NUMBER;
44:
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

Line 47: l_segment fnd_segment_attribute_values.segment_attribute_type%type) IS

43: l_seg_num NUMBER;
44:
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#'

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