APPS.JL_CO_GL_NIT_MANAGEMENT dependencies on FND_SEGMENT_ATTRIBUTE_VALUES

Line 5: g_account_segment fnd_segment_attribute_values.application_column_name%TYPE;

1: PACKAGE BODY jl_co_gl_nit_management AS
2: /* $Header: jlcoglbb.pls 120.23.12010000.7 2008/08/29 06:02:43 vspuli ship $ */
3:
4: g_period_set_name gl_periods.period_set_name%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;

Line 6: g_chart_of_accounts_id fnd_segment_attribute_values.id_flex_num%TYPE;

2: /* $Header: jlcoglbb.pls 120.23.12010000.7 2008/08/29 06:02:43 vspuli ship $ */
3:
4: g_period_set_name gl_periods.period_set_name%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;

Line 2145: FROM fnd_segment_attribute_values fndsav

2141: SELECT application_column_name,
2142: id_flex_num
2143: INTO g_account_segment,
2144: g_chart_of_accounts_id
2145: FROM fnd_segment_attribute_values fndsav
2146: WHERE fndsav.id_flex_code = 'GL#'
2147: AND fndsav.segment_attribute_type = 'GL_ACCOUNT'
2148: AND fndsav.attribute_value = 'Y'
2149: AND application_id = 101