APPS.OKL_ACCOUNT_DIST_PVT dependencies on GL_LEDGERS

Line 40: gl_ledgers g

36: select o.set_of_books_id ledger_id,
37: g.short_name rep_code,
38: 'PRIMARY' rep_type
39: FROM okl_sys_acct_opts o,
40: gl_ledgers g
41: WHERE o.set_of_books_id = g.ledger_id
42: UNION ALL
43: select o.set_of_books_id ledger_id,
44: g.short_name rep_code,

Line 49: gl_ledgers g

45: 'SECONDARY' rep_type
46: FROM okl_sys_acct_opts o,
47: okl_system_params_all s,
48: fa_book_controls f,
49: gl_ledgers g
50: WHERE o.org_id = s.org_id
51: AND s.RPT_PROD_BOOK_TYPE_CODE = f.book_type_code
52: AND f.set_of_books_id = g.ledger_id
53: AND o.secondary_rep_method = 'AUTOMATED';

Line 931: FROM GL_LEDGERS_PUBLIC_V

927: FROM OKL_SYS_ACCT_OPTS;
928:
929: CURSOR sob_csr (v_set_of_books_id NUMBER) IS
930: SELECT ROUNDING_CCID rounding_code_combination_id
931: FROM GL_LEDGERS_PUBLIC_V
932: WHERE ledger_id = v_set_of_books_id;
933:
934: l_tabv_tbl tabv_tbl_type ;
935: l_tabv_tbl_out tabv_tbl_type ;

Line 1481: FROM GL_LEDGERS_PUBLIC_V

1477: FROM OKL_SYS_ACCT_OPTS;
1478:
1479: CURSOR sob_csr (v_set_of_books_id NUMBER) IS
1480: SELECT ROUNDING_CCID rounding_code_combination_id
1481: FROM GL_LEDGERS_PUBLIC_V
1482: WHERE ledger_id = v_set_of_books_id;
1483:
1484: l_tabv_tbl tabv_tbl_type ;
1485: l_tabv_tbl_out tabv_tbl_type ;

Line 1843: --FROM GL_LEDGERS_PUBLIC_V

1839:
1840: -- redundant code .. not used.
1841: --CURSOR sobv_csr IS
1842: --SELECT currency_code
1843: --FROM GL_LEDGERS_PUBLIC_V
1844: --WHERE LEDGER_ID = Okl_Accounting_Util.get_set_of_books_id;
1845:
1846: l_validate_holder VARCHAR2(1) := OKL_API.G_MISS_CHAR;
1847: l_functional_curr OKL_TRNS_ACC_DSTRS.CURRENCY_CODE%TYPE;

Line 2471: l_gl_short_name GL_LEDGERS.SHORT_NAME%TYPE;

2467: l_msg_count NUMBER := 0;
2468: l_msg_data VARCHAR2(2000);
2469: l_event_id NUMBER;
2470: l_event_date DATE;
2471: l_gl_short_name GL_LEDGERS.SHORT_NAME%TYPE;
2472: l_tabv_tbl tabv_tbl_type ;
2473: l_tabv_tbl_out tabv_tbl_type ;
2474: x_tabv_tbl tabv_tbl_type ;
2475: l_try_name OKL_TRX_TYPES_TL.NAME%TYPE;

Line 2583: GL_LEDGERS GL

2579: CURSOR get_gl_short_name_csr
2580: IS
2581: SELECT GL.SHORT_NAME
2582: FROM OKL_SYS_ACCT_OPTS SAO,
2583: GL_LEDGERS GL
2584: WHERE SAO.SET_OF_BOOKS_ID = GL.LEDGER_ID;
2585:
2586: CURSOR get_trx_type(p_try_id NUMBER)
2587: IS

Line 3973: l_gl_short_name GL_LEDGERS.SHORT_NAME%TYPE;

3969: l_msg_count NUMBER := 0;
3970: l_msg_data VARCHAR2(2000);
3971: l_event_id NUMBER;
3972: l_event_date DATE;
3973: l_gl_short_name GL_LEDGERS.SHORT_NAME%TYPE;
3974: l_tabv_tbl_out tabv_tbl_type ;
3975: l_tabv_tbl_final tabv_tbl_type;
3976: x_tabv_tbl tabv_tbl_type ;
3977: k NUMBER := 0;

Line 4000: GL_LEDGERS GL

3996: CURSOR get_gl_short_name_csr
3997: IS
3998: SELECT GL.SHORT_NAME
3999: FROM OKL_SYS_ACCT_OPTS SAO,
4000: GL_LEDGERS GL
4001: WHERE SAO.SET_OF_BOOKS_ID = GL.LEDGER_ID;
4002: --Bug 5707866 - End of Changes
4003:
4004: BEGIN

Line 4611: l_gl_short_name GL_LEDGERS.SHORT_NAME%TYPE;

4607: l_msg_count NUMBER := 0;
4608: l_msg_data VARCHAR2(2000);
4609: l_event_id NUMBER;
4610: l_event_date DATE;
4611: l_gl_short_name GL_LEDGERS.SHORT_NAME%TYPE;
4612: l_tabv_tbl_out tabv_tbl_type ;
4613: l_tabv_tbl_final tabv_tbl_type;
4614: --x_tabv_tbl tabv_tbl_type ;
4615: k NUMBER := 0;

Line 5087: l_gl_short_name GL_LEDGERS.SHORT_NAME%TYPE;

5083: l_msg_count NUMBER := 0;
5084: l_msg_data VARCHAR2(2000);
5085: l_event_id NUMBER;
5086: l_event_date DATE;
5087: l_gl_short_name GL_LEDGERS.SHORT_NAME%TYPE;
5088: l_tabv_tbl tabv_tbl_type ;
5089: l_tabv_tbl_out tabv_tbl_type ;
5090: x_tabv_tbl tabv_tbl_type ;
5091: l_dist_info_tbl dist_info_tbl_type := p_dist_info_tbl;

Line 5144: GL_LEDGERS GL

5140: CURSOR get_gl_short_name_csr
5141: IS
5142: SELECT GL.SHORT_NAME
5143: FROM OKL_SYS_ACCT_OPTS SAO,
5144: GL_LEDGERS GL
5145: WHERE SAO.SET_OF_BOOKS_ID = GL.LEDGER_ID;
5146:
5147: CURSOR get_trx_type(p_try_id NUMBER)
5148: IS