164: ,1) PRIOR_PAY_PER_DAY
165: INTO CURRENT_PAY_PER_DAY,PRIOR_PAY_PER_DAY
166: FROM
167: AR_CASH_RECEIPTS CR,
168: AR_RECEIPT_METHODS RM,
169: AR_RECEIPT_CLASSES RC,
170: AR_CASH_RECEIPT_HISTORY CRH,
171: GL_PERIOD_STATUSES GPS
172: WHERE CR.RECEIPT_METHOD_ID = RM.RECEIPT_METHOD_ID
224: ,0) PRIOR_PAY_PER_BATCH
225: INTO CURRENT_PAY_PER_BATCH,PRIOR_PAY_PER_BATCH
226: FROM
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