DBA Data[Home] [Help]

APPS.GL_GLRGNJ_XMLP_PKG dependencies on GL_PERIODS

Line 6: FROM GL_PERIODS

2: /* $Header: GLRGNJB.pls 120.0 2007/12/27 14:36:50 vijranga noship $ */
3: function BeforeReport return boolean is
4: cursor get_to_period(T_END_DATE DATE, T_PERIOD_SET_NAME VARCHAR) is
5: SELECT PERIOD_NAME
6: FROM GL_PERIODS
7: WHERE PERIOD_SET_NAME = T_PERIOD_SET_NAME
8: AND END_DATE = T_END_DATE
9: ORDER BY PERIOD_NUM DESC;
10: cursor get_from_period(T_START_DATE DATE, T_PERIOD_SET_NAME VARCHAR) is

Line 12: FROM GL_PERIODS

8: AND END_DATE = T_END_DATE
9: ORDER BY PERIOD_NUM DESC;
10: cursor get_from_period(T_START_DATE DATE, T_PERIOD_SET_NAME VARCHAR) is
11: SELECT PERIOD_NAME
12: FROM GL_PERIODS
13: WHERE PERIOD_SET_NAME = T_PERIOD_SET_NAME
14: AND START_DATE = T_START_DATE
15: ORDER BY PERIOD_NUM DESC;
16: t_p_start_date DATE;