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 340: from gl_period_statuses

336: END IF;
337:
338: select period_num
339: into report_period_num
340: from gl_period_statuses
341: where application_id = parm_application_id
342: and set_of_books_id = parm_set_of_books_id
343: and period_name = parm_gl_period_name
344: and period_year = parm_gl_period_year;

Line 706: FROM gl_period_statuses

702: --
703: --
704: SELECT min(period_num)
705: INTO g_period_num
706: FROM gl_period_statuses
707: WHERE ledger_id = parm_set_of_books_id
708: AND period_year = parm_gl_period_year
709: AND adjustment_period_flag = 'N'
710: AND application_id = '101' ;

Line 717: FROM GL_PERIOD_STATUSES

713: -- Added on 4/28/98 by Surya Padmanabhan
714: -- Get the Period Number For the Quarter
715: SELECT PERIOD_NUM
716: INTO parm_gl_period_num
717: FROM GL_PERIOD_STATUSES
718: WHERE LEDGER_ID = parm_set_of_books_id AND
719: PERIOD_YEAR = parm_gl_period_year AND
720: APPLICATION_ID = '101' AND
721: CLOSING_STATUS in ('O','C') AND

Line 880: FROM gl_period_statuses

876: SELECT start_date,
877: end_date
878: INTO beg_date,
879: close_date
880: FROM gl_period_statuses
881: WHERE period_year = parm_gl_period_year
882: AND period_num = report_period_num
883: AND application_id = 101
884: AND set_of_books_id = parm_set_of_books_id;