[Home] [Help]
46: gcc.segment28,
47: gcc.segment29,
48: gcc.segment30
49: FROM fnd_id_flex_structures fifs,
50: gl_code_combinations gcc
51: WHERE fifs.application_id=101
52: AND fifs.id_flex_code = 'GL#'
53: AND fifs.id_flex_num = gcc.chart_of_accounts_id
54: AND gcc.code_combination_id = p_ccid;
69: CLOSE c_details;
70:
71: SELECT count(1) into l_nseg
72: FROM fnd_id_flex_segments fifs,
73: gl_code_combinations glcc
74: WHERE fifs.application_id = 101 and
75: fifs.id_flex_code = 'GL#' and
76: fifs.id_flex_num = glcc.chart_of_accounts_id and
77: glcc.code_combination_id =p_ccid;
258: where fgl.chart_of_accounts_id = tgl.chart_of_accounts_id
259: and fgl.ledger_id = p_from_ledger_id
260: and tgl.ledger_id = p_to_ledger_id;
261:
262: l_query := 'select SEGMENT'||l_bal_seg_num ||', DECODE('||l_ic_seg_num||', NULL, NULL, SEGMENT' || l_ic_seg_num ||') FROM GL_CODE_COMBINATIONS WHERE CODE_COMBINATION_ID = :ccid';
263:
264: OPEN c_seg_values FOR l_query USING p_ccid;
265: FETCH c_seg_values INTO bal_seg_val, intercompany_seg_val;
266:
292: p_ccid in NUMBER
293: ) RETURN VARCHAR2
294: IS
295:
296: l_coa gl_code_combinations.CHART_OF_ACCOUNTS_ID%TYPE;
297:
298: BEGIN
299:
300: select CHART_OF_ACCOUNTS_ID
298: BEGIN
299:
300: select CHART_OF_ACCOUNTS_ID
301: INTO l_coa
302: from gl_code_combinations
303: where code_combination_id = p_ccid;
304:
305: RETURN GL_FLEXFIELDS_PKG.get_concat_description( l_coa, p_ccid);
306: