392: AND rownum = 1;
393:
394:
395: vcheck_rec invoice_cursor%ROWTYPE;
396: l_acct_dist_tbl Fnd_Flex_Ext.segmentarray ;
397: l_get_segments_flag BOOLEAN;
398: l_period_num gl_balances.period_num%TYPE;
399: l_currency_code gl_balances.currency_code%TYPE;
400: l_period_year gl_balances.period_year%TYPE ;
427: FETCH invoice_cursor INTO vcheck_rec;
428: EXIT WHEN invoice_cursor%NOTFOUND;
429:
430: l_get_segments_flag :=
431: fnd_flex_ext.get_segments
432: (application_short_name => 'SQLGL',
433: key_flex_code => g_flex_code,
434: structure_number => g_flex_num,
435: combination_id => vcheck_rec.dist_code_combination_id,