APPS.OKL_ACCOUNTING_UTIL dependencies on GL_LEDGERS

Line 363: FROM GL_LEDGERS_PUBLIC_V

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

Line 486: FROM GL_LEDGERS_PUBLIC_V

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

Line 536: FROM GL_LEDGERS_PUBLIC_V

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

Line 669: FROM GL_LEDGERS_PUBLIC_V

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

Line 975: FROM GL_LEDGERS_PUBLIC_V

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

Line 1019: FROM GL_LEDGERS_PUBLIC_V

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

Line 1178: FROM GL_LEDGERS_PUBLIC_V

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

Line 1240: FROM GL_LEDGERS_PUBLIC_V

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

Line 3132: l_val_meth_code GL_LEDGERS.SHORT_NAME%TYPE;

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

Line 3136: FROM gl_ledgers

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