163: ,0) / ((PRIOR_END_DATE) - (PRIOR_START_DATE))
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
223: ,1)
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,