APPS.OKL_ACCOUNTING_UTIL dependencies on GL_LEDGERS

Line 362: FROM GL_LEDGERS_PUBLIC_V

358: l_sysdate DATE := G_SYSDATE;
359:
360: CURSOR coa_csr(p_ledger_id IN NUMBER) IS
361: SELECT chart_of_accounts_id
362: FROM GL_LEDGERS_PUBLIC_V
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'

Line 485: FROM GL_LEDGERS_PUBLIC_V

481: l_ledger_id NUMBER;
482:
483: CURSOR prd_set_csr (l_ledger_id NUMBER) IS
484: SELECT period_set_name, accounted_period_type
485: FROM GL_LEDGERS_PUBLIC_V
486: WHERE ledger_id = l_ledger_id;
487:
488: CURSOR prd_name_csr (l_period_set_name VARCHAR2, l_user_period_type VARCHAR2) IS
489: SELECT period_name, start_date, end_date

Line 535: FROM GL_LEDGERS_PUBLIC_V

531: l_ledger_id NUMBER;
532:
533: CURSOR perd_set_csr(l_ledger_id NUMBER) IS
534: SELECT period_set_name, accounted_period_type
535: FROM GL_LEDGERS_PUBLIC_V
536: WHERE ledger_id = l_ledger_id;
537:
538: CURSOR perd_dt_csr (l_period_set_name VARCHAR2, l_user_period_type VARCHAR2) IS
539: SELECT start_date, end_date

Line 668: FROM GL_LEDGERS_PUBLIC_V

664: l_set_of_books_name VARCHAR2(30);
665:
666: CURSOR set_of_book_name IS
667: SELECT name
668: FROM GL_LEDGERS_PUBLIC_V
669: WHERE ledger_id = p_set_of_books_id;
670:
671: BEGIN
672:

Line 974: FROM GL_LEDGERS_PUBLIC_V

970: l_chart_of_accounts_id NUMBER;
971:
972: CURSOR coa_csr(p_ledger_id IN NUMBER) IS
973: SELECT chart_of_accounts_id
974: FROM GL_LEDGERS_PUBLIC_V
975: WHERE ledger_id = NVL(p_ledger_id,get_set_of_books_id);
976:
977: CURSOR seg_csr (l_chart_of_accounts_id NUMBER) IS
978: SELECT segment_num,

Line 1018: FROM GL_LEDGERS_PUBLIC_V

1014: l_segment_desc FND_ID_FLEX_SEGMENTS_VL.FORM_LEFT_PROMPT%TYPE;
1015:
1016: CURSOR coa_csr(p_ledger_id IN NUMBER) IS
1017: SELECT chart_of_accounts_id
1018: FROM GL_LEDGERS_PUBLIC_V
1019: WHERE ledger_id = NVL(p_ledger_id,get_set_of_books_id);
1020:
1021: CURSOR seg_csr (l_chart_of_accounts_id NUMBER) IS
1022: SELECT form_left_prompt

Line 1177: FROM GL_LEDGERS_PUBLIC_V

1173: l_ledger_id NUMBER;
1174:
1175: CURSOR curr_csr (l_ledger_id NUMBER) IS
1176: SELECT currency_code
1177: FROM GL_LEDGERS_PUBLIC_V
1178: WHERE ledger_id = l_ledger_id;
1179:
1180: BEGIN
1181: l_ledger_id := p_ledger_id;

Line 1239: FROM GL_LEDGERS_PUBLIC_V

1235: l_ledger_id NUMBER;
1236:
1237: CURSOR coa_csr (l_ledger_id NUMBER) IS
1238: SELECT chart_of_accounts_id
1239: FROM GL_LEDGERS_PUBLIC_V
1240: WHERE ledger_id = l_ledger_id;
1241:
1242: BEGIN
1243: l_ledger_id := p_ledger_id;

Line 3130: l_val_meth_code GL_LEDGERS.SHORT_NAME%TYPE;

3126: FUNCTION get_valuation_method_code( p_ledger_id NUMBER DEFAULT NULL)
3127: RETURN VARCHAR2
3128: AS
3129: l_ledger_id NUMBER;
3130: l_val_meth_code GL_LEDGERS.SHORT_NAME%TYPE;
3131:
3132: CURSOR get_gl_short_name_csr(l_ledger_id NUMBER) IS
3133: SELECT short_name
3134: FROM gl_ledgers

Line 3134: FROM gl_ledgers

3130: l_val_meth_code GL_LEDGERS.SHORT_NAME%TYPE;
3131:
3132: CURSOR get_gl_short_name_csr(l_ledger_id NUMBER) IS
3133: SELECT short_name
3134: FROM gl_ledgers
3135: WHERE ledger_id = l_ledger_id;
3136:
3137: BEGIN
3138: l_ledger_id := p_ledger_id;