APPS.FV_SF133_NOYEAR dependencies on GL_PERIOD_STATUSES

Line 18: parm_gl_period_name gl_period_statuses.period_name%TYPE;

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

Line 589: FROM gl_period_statuses

585: --
586: --
587: SELECT min(period_num)
588: INTO g_period_num
589: FROM gl_period_statuses
590: WHERE ledger_id = parm_set_of_books_id
591: AND period_year = parm_gl_period_year
592: AND adjustment_period_flag = 'N'
593: AND application_id = '101' ;

Line 600: FROM GL_PERIOD_STATUSES

596: -- Added on 4/28/98 by Surya Padmanabhan
597: -- Get the Period Number For the Quarter
598: SELECT PERIOD_NUM
599: INTO parm_gl_period_num
600: FROM GL_PERIOD_STATUSES
601: WHERE LEDGER_ID = parm_set_of_books_id AND
602: PERIOD_YEAR = parm_gl_period_year AND
603: APPLICATION_ID = '101' AND
604: CLOSING_STATUS in ('O','C') AND