APPS.XTR_XTRREVGL_XMLP_PKG dependencies on XTR_BATCH_EVENTS

Line 201: XTR_BATCH_EVENTS E

197: ,'YYYY/MM/DD HH24:MI:SS')
198: INTO P_DATE_FROM
199: FROM
200: XTR_BATCHES B,
201: XTR_BATCH_EVENTS E
202: WHERE B.BATCH_ID = E.BATCH_ID
203: AND E.EVENT_CODE = 'REVAL'
204: AND B.BATCH_ID >= P_BATCH_ID_FROM;
205: P_USER_DATE_FROM := TO_DATE(P_DATE_FROM

Line 215: XTR_BATCH_EVENTS E

211: ,'YYYY/MM/DD HH24:MI:SS')
212: INTO P_DATE_TO
213: FROM
214: XTR_BATCHES B,
215: XTR_BATCH_EVENTS E
216: WHERE B.BATCH_ID = E.BATCH_ID
217: AND E.EVENT_CODE = 'REVAL'
218: AND B.BATCH_ID <= P_BATCH_ID_TO;
219: P_USER_DATE_TO := TO_DATE(P_DATE_TO