APPS.FV_YE_CLOSE dependencies on GL_SETS_OF_BOOKS

Line 34: vg_sob_id Gl_Sets_Of_Books.set_of_books_id%TYPE;

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

Line 35: vg_coa_id Gl_Sets_Of_Books.chart_of_accounts_id%TYPE;

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

Line 36: vg_currency Gl_Sets_Of_Books.currency_code%TYPE;

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

Line 318: FROM gl_sets_of_books

314: -- Get the Currency code
315: BEGIN
316: SELECT currency_code
317: INTO vg_currency
318: FROM gl_sets_of_books
319: WHERE set_of_books_id = vg_sob_id;
320:
321: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
322: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,' CURRENCY CODE = '||VG_CURRENCY);

Line 459: FROM gl_periods glp, gl_sets_of_books gsob

455: -- Get the Start Date and the End Date of the Closing fiscal year for the chosen closing period
456: BEGIN
457: SELECT MIN(start_date), MAX(end_date)
458: INTO vg_start_date, vg_end_date
459: FROM gl_periods glp, gl_sets_of_books gsob
460: WHERE glp.period_year = vp_closing_fyr
461: AND glp.period_set_name = gsob.period_set_name
462: AND gsob.chart_of_accounts_id = vg_coa_id
463: AND gsob.set_of_books_id = vg_sob_id