APPS.FV_SF133_ONEYEAR dependencies on GL_PERIOD_STATUSES

Line 19: parm_gl_period_name gl_period_statuses.period_name%TYPE;

15: parm_run_mode VARCHAR2(10);
16:
17: -- New Variable declared by Surya on 04/30/98 to receive the value of
18: -- the passed quarter number
19: parm_gl_period_name gl_period_statuses.period_name%TYPE;
20: parm_treasury_symbol_id fv_treasury_symbols.treasury_symbol_id%TYPE;
21:
22: -- ------------------------------------
23: -- All Pre-build Query Variables

Line 640: FROM gl_period_statuses

636: --
637: --
638: SELECT min(period_num)
639: INTO g_period_num
640: FROM gl_period_statuses
641: WHERE ledger_id = parm_set_of_books_id
642: AND adjustment_period_flag = 'N'
643: AND period_year = parm_gl_period_year
644: AND application_id = '101' ;

Line 651: FROM GL_PERIOD_STATUSES

647: -- Added on 5/6/98 by Surya Padmanabhan to get the Period Number For
648: -- the Quarter.
649: SELECT PERIOD_NUM
650: INTO parm_gl_period_num
651: FROM GL_PERIOD_STATUSES
652: WHERE LEDGER_ID = parm_set_of_books_id AND
653: PERIOD_YEAR = parm_gl_period_year AND
654: APPLICATION_ID = '101' AND
655: CLOSING_STATUS in ('O','C') AND

Line 1384: FROM gl_period_statuses

1380: l_module_name := g_module_name || 'GET_BEGIN_ENDING_PERIODS';
1381:
1382: SELECT MIN(PERIOD_NUM)
1383: INTO V_BEGIN_PERIOD
1384: FROM gl_period_statuses
1385: WHERE set_of_books_id = parm_set_of_books_id
1386: AND period_year = V_PROCESS_YEAR
1387: AND adjustment_period_flag = 'N'
1388: AND application_id = '101' ;

Line 1392: FROM gl_period_statuses

1388: AND application_id = '101' ;
1389:
1390: SELECT MAX(PERIOD_NUM)
1391: INTO V_END_PERIOD
1392: FROM gl_period_statuses
1393: WHERE set_of_books_id = parm_set_of_books_id
1394: AND period_year = V_PROCESS_YEAR
1395: AND closing_status in ('C','O')
1396: AND application_id = '101' ;