DBA Data[Home] [Help]

APPS.JL_JLCOPWHR_XMLP_PKG dependencies on GL_PERIODS

Line 205: GL_PERIODS A,

201: SELECT
202: START_DATE
203: INTO X_START_DATE
204: FROM
205: GL_PERIODS A,
206: GL_SETS_OF_BOOKS B
207: WHERE B.SET_OF_BOOKS_ID = P_SOB_ID
208: AND A.PERIOD_SET_NAME = B.PERIOD_SET_NAME
209: AND UPPER(A.PERIOD_NAME) = UPPER(P_PERIOD_FROM);

Line 221: GL_PERIODS A,

217: SELECT
218: END_DATE
219: INTO X_END_DATE
220: FROM
221: GL_PERIODS A,
222: GL_SETS_OF_BOOKS B
223: WHERE B.SET_OF_BOOKS_ID = P_SOB_ID
224: AND A.PERIOD_SET_NAME = B.PERIOD_SET_NAME
225: AND UPPER(A.PERIOD_NAME) = UPPER(P_PERIOD_TO);