DBA Data[Home] [Help]

APPS.IGIPREC dependencies on GL_JE_CATEGORIES

Line 30: FROM gl_je_categories

26: --To fetch the Category (Manual adjustments)
27: --------------------------------------------------------------------
28: CURSOR C_category_name IS
29: SELECT je_category_name , user_je_category_name
30: FROM gl_je_categories
31: WHERE je_category_name = '41'
32: AND LANGUAGE = USERENV('LANG');
33: --------------------------------------------------------------------
34: --To set the start_date and the end_date sources from parameters From Period and To Period.

Line 137: l_je_category_name gl_je_categories.je_category_name%type;

133: l_secondary_set_of_books_id NUMBER;
134: l_chart_of_accounts_id NUMBER;
135: l_je_source_name gl_je_sources.je_source_name%type;
136: l_user_je_source_name gl_je_sources.user_je_source_name%type;
137: l_je_category_name gl_je_categories.je_category_name%type;
138: l_user_je_category_name gl_je_categories.user_je_category_name%type;
139: l_start_date DATE;
140: l_end_date DATE;
141: l_processed Boolean;

Line 138: l_user_je_category_name gl_je_categories.user_je_category_name%type;

134: l_chart_of_accounts_id NUMBER;
135: l_je_source_name gl_je_sources.je_source_name%type;
136: l_user_je_source_name gl_je_sources.user_je_source_name%type;
137: l_je_category_name gl_je_categories.je_category_name%type;
138: l_user_je_category_name gl_je_categories.user_je_category_name%type;
139: l_start_date DATE;
140: l_end_date DATE;
141: l_processed Boolean;
142: l_int_control glcontrol;