DBA Data[Home] [Help]

APPS.JL_CO_GL_NIT_MANAGEMENT dependencies on GL_SETS_OF_BOOKS

Line 9: g_func_currency gl_sets_of_books.currency_code%TYPE;

5: g_account_segment fnd_segment_attribute_values.application_column_name%TYPE;
6: g_chart_of_accounts_id fnd_segment_attribute_values.id_flex_num%TYPE;
7: g_period_num gl_periods.period_num%TYPE;
8: g_period_year gl_periods.period_year%TYPE;
9: g_func_currency gl_sets_of_books.currency_code%TYPE;
10: g_default_nit_id jl_co_gl_nits.nit_id%TYPE;
11: g_login_id jl_co_gl_trx.last_update_login%TYPE;
12:
13: PROCEDURE Create_Balances(

Line 1813: FROM gl_sets_of_books glsob

1809:
1810: SELECT period_set_name,
1811: currency_code
1812: INTO g_period_set_name,g_func_currency
1813: FROM gl_sets_of_books glsob
1814: WHERE glsob.set_of_books_id = trx.sobid;
1815:
1816: BEGIN
1817:

Line 2151: FROM gl_sets_of_books

2147: AND fndsav.segment_attribute_type = 'GL_ACCOUNT'
2148: AND fndsav.attribute_value = 'Y'
2149: AND application_id = 101
2150: AND fndsav.id_flex_num = (SELECT chart_of_accounts_id
2151: FROM gl_sets_of_books
2152: WHERE set_of_books_id = p_sobid);
2153:
2154: -- Generate Process record
2155:

Line 2235: FROM gl_sets_of_books glsob

2231: END;
2232:
2233: SELECT period_set_name
2234: INTO g_period_set_name
2235: FROM gl_sets_of_books glsob
2236: WHERE glsob.set_of_books_id = p_sobid;
2237:
2238: IF p_period is not null THEN
2239: SELECT period_num,