APPS.OKL_ACCOUNTING_UTIL dependencies on GL_CODE_COMBINATIONS

Line 51: l_concate_desc gl_code_combinations_kfv.concatenated_segments%TYPE;

47: i INTEGER := 1;
48: l_delimiter VARCHAR2(1);
49: l_seg_array OKL_ACCOUNTING_UTIL.seg_array_type;
50: l_seg_desc VARCHAR2(2000);
51: l_concate_desc gl_code_combinations_kfv.concatenated_segments%TYPE;
52: l_parent_id fnd_flex_value_sets.parent_flex_value_set_id%TYPE;
53: l_parent_value_low FND_FLEX_VALUES.PARENT_FLEX_VALUE_LOW%TYPE;
54:
55: -- Changed by Santonyr on 13-May-2004

Line 367: FROM gl_code_combinations

363: WHERE ledger_id = NVL(p_ledger_id,get_set_of_books_id);
364:
365: CURSOR ccid_csr (l_chart_of_accounts_id NUMBER) IS
366: SELECT '1'
367: FROM gl_code_combinations
368: WHERE code_combination_id = p_ccid
369: AND chart_of_accounts_id = l_chart_of_accounts_id
370: AND ENABLED_FLAG = 'Y'
371: AND TRUNC(NVL(start_date_active, l_sysdate)) <= TRUNC(l_sysdate)

Line 1543: FROM gl_code_combinations_kfv

1539: l_concatenated_segments VARCHAR2(1000);
1540:
1541: CURSOR ccid_csr IS
1542: SELECT concatenated_segments
1543: FROM gl_code_combinations_kfv
1544: WHERE code_combination_id = p_ccid;
1545:
1546: BEGIN
1547:

Line 1571: FROM gl_code_combinations_kfv

1567: l_concate_desc VARCHAR2(1000);
1568:
1569: CURSOR ccid_csr IS
1570: SELECT concatenated_segments, chart_of_accounts_id
1571: FROM gl_code_combinations_kfv
1572: WHERE code_combination_id = p_code_combination_id;
1573:
1574: BEGIN
1575: OPEN ccid_csr;