109: , ffvt.description
110: FROM
111: ja_cn_journal_lines jcjl
112: , gl_ledgers gl, gl_periods gp
113: , fnd_flex_values_tl ffvt
114: , fnd_flex_values ffv
115: , fnd_id_flex_segments fifs
116: , ja_cn_voucher_number jcvn
117: WHERE fifs.id_flex_num = pn_coa_id
110: FROM
111: ja_cn_journal_lines jcjl
112: , gl_ledgers gl, gl_periods gp
113: , fnd_flex_values_tl ffvt
114: , fnd_flex_values ffv
115: , fnd_id_flex_segments fifs
116: , ja_cn_voucher_number jcvn
117: WHERE fifs.id_flex_num = pn_coa_id
118: AND fifs.id_flex_code = 'GL#'