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 430: FROM GL_PERIOD_STATUSES

426: L_LOOP_YEAR := g_established_year ;
427:
428: SELECT PERIOD_NUM
429: INTO parm_gl_period_num
430: FROM GL_PERIOD_STATUSES
431: WHERE LEDGER_ID = parm_set_of_books_id AND
432: PERIOD_YEAR = parm_gl_period_year AND
433: APPLICATION_ID = '101' AND
434: CLOSING_STATUS in ('O','C') AND

Line 811: FROM gl_period_statuses

807: --
808: --
809: SELECT min(period_num)
810: INTO g_period_num
811: FROM gl_period_statuses
812: WHERE ledger_id = parm_set_of_books_id
813: AND adjustment_period_flag = 'N'
814: AND period_year = parm_gl_period_year
815: AND application_id = '101' ;

Line 822: FROM GL_PERIOD_STATUSES

818: -- Added on 5/6/98 by Surya Padmanabhan to get the Period Number For
819: -- the Quarter.
820: SELECT PERIOD_NUM
821: INTO parm_gl_period_num
822: FROM GL_PERIOD_STATUSES
823: WHERE LEDGER_ID = parm_set_of_books_id AND
824: PERIOD_YEAR = parm_gl_period_year AND
825: APPLICATION_ID = '101' AND
826: CLOSING_STATUS in ('O','C') AND

Line 1161: FROM gl_period_statuses

1157: SELECT start_date,
1158: end_date
1159: INTO beg_date,
1160: close_date
1161: FROM gl_period_statuses
1162: WHERE period_year = parm_gl_period_year
1163: AND period_num = parm_gl_period_num
1164: AND application_id = 101
1165: AND set_of_books_id = parm_set_of_books_id;

Line 1882: FROM gl_period_statuses

1878: l_module_name := g_module_name || 'GET_BEGIN_ENDING_PERIODS';
1879:
1880: SELECT MIN(PERIOD_NUM)
1881: INTO V_BEGIN_PERIOD
1882: FROM gl_period_statuses
1883: WHERE set_of_books_id = parm_set_of_books_id
1884: AND period_year = V_PROCESS_YEAR
1885: AND adjustment_period_flag = 'N'
1886: AND application_id = '101' ;

Line 1890: FROM gl_period_statuses

1886: AND application_id = '101' ;
1887:
1888: SELECT MAX(PERIOD_NUM)
1889: INTO V_END_PERIOD
1890: FROM gl_period_statuses
1891: WHERE set_of_books_id = parm_set_of_books_id
1892: AND period_year = V_PROCESS_YEAR
1893: AND closing_status in ('C','O')
1894: AND application_id = '101' ;