APPS.FV_YE_CLOSE dependencies on GL_SETS_OF_BOOKS

Line 31: vg_sob_id Gl_Sets_Of_Books.set_of_books_id%TYPE;

27: -- ======================================================================
28: -- Other Global Variable Declarations
29: -- ======================================================================
30:
31: vg_sob_id Gl_Sets_Of_Books.set_of_books_id%TYPE;
32: vg_coa_id Gl_Sets_Of_Books.chart_of_accounts_id%TYPE;
33: vg_currency Gl_Sets_Of_Books.currency_code%TYPE;
34: vg_start_date Gl_Periods.start_date%TYPE;
35: vg_end_date Gl_Periods.end_date%TYPE;

Line 32: vg_coa_id Gl_Sets_Of_Books.chart_of_accounts_id%TYPE;

28: -- Other Global Variable Declarations
29: -- ======================================================================
30:
31: vg_sob_id Gl_Sets_Of_Books.set_of_books_id%TYPE;
32: vg_coa_id Gl_Sets_Of_Books.chart_of_accounts_id%TYPE;
33: vg_currency Gl_Sets_Of_Books.currency_code%TYPE;
34: vg_start_date Gl_Periods.start_date%TYPE;
35: vg_end_date Gl_Periods.end_date%TYPE;
36: vg_closing_period Gl_Period_Statuses.period_name%TYPE;

Line 33: vg_currency Gl_Sets_Of_Books.currency_code%TYPE;

29: -- ======================================================================
30:
31: vg_sob_id Gl_Sets_Of_Books.set_of_books_id%TYPE;
32: vg_coa_id Gl_Sets_Of_Books.chart_of_accounts_id%TYPE;
33: vg_currency Gl_Sets_Of_Books.currency_code%TYPE;
34: vg_start_date Gl_Periods.start_date%TYPE;
35: vg_end_date Gl_Periods.end_date%TYPE;
36: vg_closing_period Gl_Period_Statuses.period_name%TYPE;
37: vg_coy_fyr Gl_Periods.period_year%TYPE;

Line 294: FROM gl_sets_of_books

290: -- Get the Currency code
291: BEGIN
292: SELECT currency_code
293: INTO vg_currency
294: FROM gl_sets_of_books
295: WHERE set_of_books_id = vg_sob_id;
296:
297: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
298: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' CURRENCY CODE = '||VG_CURRENCY);

Line 434: FROM gl_periods glp, gl_sets_of_books gsob

430: -- Get the Start Date and the End Date of the Closing Fyr
431: BEGIN
432: SELECT MIN(start_date), MAX(end_date)
433: INTO vg_start_date, vg_end_date
434: FROM gl_periods glp, gl_sets_of_books gsob
435: WHERE glp.period_year = vp_closing_fyr
436: AND glp.period_set_name = gsob.period_set_name
437: AND gsob.chart_of_accounts_id = vg_coa_id
438: AND gsob.set_of_books_id = vg_sob_id;