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 2674: FROM gl_sets_of_books glsob

2670:
2671: SELECT period_set_name,
2672: currency_code
2673: INTO g_period_set_name,g_func_currency
2674: FROM gl_sets_of_books glsob
2675: WHERE glsob.set_of_books_id = trx.sobid;
2676:
2677: BEGIN
2678:

Line 3023: FROM gl_sets_of_books

3019: AND fndsav.segment_attribute_type = 'GL_ACCOUNT'
3020: AND fndsav.attribute_value = 'Y'
3021: AND application_id = 101
3022: AND fndsav.id_flex_num = (SELECT chart_of_accounts_id
3023: FROM gl_sets_of_books
3024: WHERE set_of_books_id = p_sobid);
3025:
3026: -- Generate Process record
3027:

Line 3106: FROM gl_sets_of_books glsob

3102: END;
3103:
3104: SELECT period_set_name
3105: INTO g_period_set_name
3106: FROM gl_sets_of_books glsob
3107: WHERE glsob.set_of_books_id = p_sobid;
3108:
3109: IF p_period is not null THEN
3110: SELECT period_num,