APPS.CE_CEFPURGE_XMLP_PKG dependencies on GL_PERIODS

Line 23: C_PURGE_OPTION := 'Purge Forecasts by GL Periods';

19: END IF;
20: IF (P_FORECAST_BY = 'D') THEN
21: C_PURGE_OPTION := 'Purge Forecasts by Days';
22: ELSIF (P_FORECAST_BY = 'A') THEN
23: C_PURGE_OPTION := 'Purge Forecasts by GL Periods';
24: ELSE
25: C_PURGE_OPTION := 'Purge All';
26: END IF;
27: P_FORECAST_START_DATE_1 := to_char(TO_DATE(P_FORECAST_START_DATE

Line 60: GL_PERIODS GLP

56: AND START_PERIOD in (
57: SELECT
58: GLP.PERIOD_NAME
59: FROM
60: GL_PERIODS GLP
61: WHERE GLP.PERIOD_SET_NAME = CF.PERIOD_SET_NAME
62: AND TRUNC(GLP.START_DATE) >= NVL(P_FORECAST_START_DATE_1
63: ,TRUNC(GLP.START_DATE))
64: AND TRUNC(GLP.START_DATE) <= NVL(P_FORECAST_END_DATE_1

Line 152: GL_PERIODS GLP

148: AND START_PERIOD in (
149: SELECT
150: GLP.PERIOD_NAME
151: FROM
152: GL_PERIODS GLP
153: WHERE GLP.PERIOD_SET_NAME = CF.PERIOD_SET_NAME
154: AND TRUNC(GLP.START_DATE) >= NVL(P_FORECAST_START_DATE_1
155: ,TRUNC(GLP.START_DATE))
156: AND TRUNC(GLP.START_DATE) <= NVL(P_FORECAST_END_DATE_1

Line 170: GL_PERIODS GLP

166: AND START_PERIOD in (
167: SELECT
168: GLP.PERIOD_NAME
169: FROM
170: GL_PERIODS GLP
171: WHERE GLP.PERIOD_SET_NAME = CF.PERIOD_SET_NAME
172: AND TRUNC(GLP.START_DATE) >= NVL(P_FORECAST_START_DATE_1
173: ,TRUNC(GLP.START_DATE))
174: AND TRUNC(GLP.START_DATE) <= NVL(P_FORECAST_END_DATE_1

Line 188: GL_PERIODS GLP

184: AND START_PERIOD in (
185: SELECT
186: GLP.PERIOD_NAME
187: FROM
188: GL_PERIODS GLP
189: WHERE GLP.PERIOD_SET_NAME = CF.PERIOD_SET_NAME
190: AND TRUNC(GLP.START_DATE) >= NVL(P_FORECAST_START_DATE_1
191: ,TRUNC(GLP.START_DATE))
192: AND TRUNC(GLP.START_DATE) <= NVL(P_FORECAST_END_DATE_1

Line 206: GL_PERIODS GLP

202: AND START_PERIOD in (
203: SELECT
204: GLP.PERIOD_NAME
205: FROM
206: GL_PERIODS GLP
207: WHERE GLP.PERIOD_SET_NAME = CF.PERIOD_SET_NAME
208: AND TRUNC(GLP.START_DATE) >= NVL(P_FORECAST_START_DATE_1
209: ,TRUNC(GLP.START_DATE))
210: AND TRUNC(GLP.START_DATE) <= NVL(P_FORECAST_END_DATE_1

Line 219: GL_PERIODS GLP

215: AND START_PERIOD in (
216: SELECT
217: GLP.PERIOD_NAME
218: FROM
219: GL_PERIODS GLP
220: WHERE GLP.PERIOD_SET_NAME = CF.PERIOD_SET_NAME
221: AND TRUNC(GLP.START_DATE) >= NVL(P_FORECAST_START_DATE_1
222: ,TRUNC(GLP.START_DATE))
223: AND TRUNC(GLP.START_DATE) <= NVL(P_FORECAST_END_DATE_1