DBA Data[Home] [Help]

APPS.OKL_ACCOUNTING_UTIL dependencies on GL_CODE_COMBINATIONS

Line 368: FROM gl_code_combinations

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

Line 1544: FROM gl_code_combinations_kfv

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

Line 1573: FROM gl_code_combinations_kfv

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