APPS.FV_PURGED_TREASURY_SYMBOLS dependencies on GL_PERIOD_STATUSES

Line 705: s_date gl_period_statuses.start_date%type;

701: l_module_name VARCHAR2(200) := g_module_name || 'CALCULATE_GL_BALANCES';
702: v_query varchar2(3000);
703: prv_year number;
704: curr_year number;
705: s_date gl_period_statuses.start_date%type;
706: e_date gl_period_statuses.end_date%type;
707: ---v_flex_value varchar2(150);
708: BEGIN
709: p_balance := 0;

Line 706: e_date gl_period_statuses.end_date%type;

702: v_query varchar2(3000);
703: prv_year number;
704: curr_year number;
705: s_date gl_period_statuses.start_date%type;
706: e_date gl_period_statuses.end_date%type;
707: ---v_flex_value varchar2(150);
708: BEGIN
709: p_balance := 0;
710: p_cnt := 0;

Line 723: FROM gl_period_statuses

719: FROM gl_code_combinations gcc,gl_balances gb
720: WHERE gb.code_combination_id = gcc.code_combination_id
721: AND gcc.chart_of_accounts_id =' || gbl_account_id ||
722: 'AND (GB.PERIOD_NUM,GB.PERIOD_YEAR) IN (SELECT MAX(PERIOD_NUM),PERIOD_YEAR
723: FROM gl_period_statuses
724: WHERE period_year IN(' || prv_year ||','|| curr_year ||')
725: AND application_id ='|| 101||'
726: AND closing_status <>'||'''F'''||
727: 'AND closing_status <>'||'''N'''||

Line 758: FROM gl_period_statuses

754: BEGIN
755:
756: SELECT min(start_date), max(end_date)
757: INTO s_date,e_date
758: FROM gl_period_statuses
759: WHERE period_year = curr_year
760: AND application_id = 101
761: AND closing_status <> 'F'
762: AND closing_status <> 'N'