eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FV_YE_CLOSE dependencies on GL_PERIODS

Line 25: vp_closing_fyr Gl_Periods.period_year%TYPE ;

21: vp_journal_import VARCHAR2(1) ;
22: vp_timeframe Fv_Treasury_Symbols.time_frame%TYPE ;
23: vp_fundgroup Fv_Treasury_Symbols.fund_group_code%TYPE;
24: vp_trsymbol Fv_Treasury_Symbols.treasury_symbol%TYPE;
25: vp_closing_fyr Gl_Periods.period_year%TYPE ;
26:
27: -- ======================================================================
28: -- Other Global Variable Declarations
29: -- ======================================================================

Line 34: vg_start_date Gl_Periods.start_date%TYPE;

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;
38: vg_coy_start_date Gl_Periods.start_date%TYPE;

Line 35: vg_end_date Gl_Periods.end_date%TYPE;

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;
38: vg_coy_start_date Gl_Periods.start_date%TYPE;
39: vg_coy_period Gl_Period_Statuses.period_name%TYPE;

Line 37: vg_coy_fyr Gl_Periods.period_year%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;
38: vg_coy_start_date Gl_Periods.start_date%TYPE;
39: vg_coy_period Gl_Period_Statuses.period_name%TYPE;
40: vg_bal_segment Fnd_Id_Flex_Segments.application_column_name%TYPE;
41: vg_acct_segment Fnd_Id_Flex_Segments.application_column_name%TYPE;

Line 38: vg_coy_start_date Gl_Periods.start_date%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;
38: vg_coy_start_date Gl_Periods.start_date%TYPE;
39: vg_coy_period Gl_Period_Statuses.period_name%TYPE;
40: vg_bal_segment Fnd_Id_Flex_Segments.application_column_name%TYPE;
41: vg_acct_segment Fnd_Id_Flex_Segments.application_column_name%TYPE;
42: vg_acct_segnum NUMBER(4);

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;