APPS.FV_PURGED_TREASURY_SYMBOLS dependencies on GL_PERIOD_STATUSES

Line 678: s_date gl_period_statuses.start_date%type;

674: l_module_name VARCHAR2(200) := g_module_name || 'CALCULATE_GL_BALANCES';
675: v_query varchar2(3000);
676: prv_year number;
677: curr_year number;
678: s_date gl_period_statuses.start_date%type;
679: e_date gl_period_statuses.end_date%type;
680: ---v_flex_value varchar2(150);
681: BEGIN
682: get_period_year(curr_year);

Line 679: e_date gl_period_statuses.end_date%type;

675: v_query varchar2(3000);
676: prv_year number;
677: curr_year number;
678: s_date gl_period_statuses.start_date%type;
679: e_date gl_period_statuses.end_date%type;
680: ---v_flex_value varchar2(150);
681: BEGIN
682: get_period_year(curr_year);
683:

Line 694: FROM gl_period_statuses

690: FROM gl_code_combinations gcc,gl_balances gb
691: WHERE gb.code_combination_id = gcc.code_combination_id
692: AND gcc.chart_of_accounts_id =' || gbl_account_id ||
693: 'AND (GB.PERIOD_NUM,GB.PERIOD_YEAR) IN (SELECT MAX(PERIOD_NUM),PERIOD_YEAR
694: FROM gl_period_statuses
695: WHERE period_year IN(' || prv_year ||','|| curr_year ||')
696: AND application_id ='|| 101||'
697: AND closing_status <>'||'''F'''||
698: 'AND closing_status <>'||'''N'''||

Line 729: FROM gl_period_statuses

725: BEGIN
726:
727: SELECT min(start_date), max(end_date)
728: INTO s_date,e_date
729: FROM gl_period_statuses
730: WHERE period_year = curr_year
731: AND application_id = 101
732: AND closing_status <> 'F'
733: AND closing_status <> 'N'