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.52.12020000.10 2013/03/26 09:42:53 mbarrett 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.52.12020000.10 2013/03/26 09:42:53 mbarrett 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 3017: FROM fnd_segment_attribute_values fndsav

3013: SELECT application_column_name,
3014: id_flex_num
3015: INTO g_account_segment,
3016: g_chart_of_accounts_id
3017: FROM fnd_segment_attribute_values fndsav
3018: WHERE fndsav.id_flex_code = 'GL#'
3019: AND fndsav.segment_attribute_type = 'GL_ACCOUNT'
3020: AND fndsav.attribute_value = 'Y'
3021: AND application_id = 101