DBA Data[Home] [Help]

APPS.AR_ARXKIR_XMLP_PKG dependencies on AR_BATCHES

Line 201: AR_BATCHES B,

197: ,1)
198: ,0) PRIOR_BATCH_PER_DAY
199: INTO CURRENT_BATCH_PER_DAY,PRIOR_BATCH_PER_DAY
200: FROM
201: AR_BATCHES B,
202: GL_PERIOD_STATUSES GPS
203: WHERE GPS.SET_OF_BOOKS_ID = SET_OF_BOOKS_ID_LP
204: AND GPS.APPLICATION_ID = 222
205: AND ( GPS.PERIOD_NAME = CURRENT_PERIOD

Line 231: AR_BATCHES B,

227: AR_CASH_RECEIPTS CR,
228: AR_RECEIPT_METHODS RM,
229: AR_RECEIPT_CLASSES RC,
230: AR_CASH_RECEIPT_HISTORY CRH,
231: AR_BATCHES B,
232: GL_PERIOD_STATUSES GPS
233: WHERE CR.RECEIPT_METHOD_ID = RM.RECEIPT_METHOD_ID
234: AND RM.RECEIPT_CLASS_ID = RC.RECEIPT_CLASS_ID
235: AND CR.CASH_RECEIPT_ID = CRH.CASH_RECEIPT_ID