APPS.PA_PWP_SUMM_PKG dependencies on AR_RECEIVABLE_APPLICATIONS_ALL
Line 286: (SELECT SUM(AMOUNT_APPLIED) FROM AR_RECEIVABLE_APPLICATIONS_ALL ARA
282: --FOR RECEIPT AMOUNTS
283:
284: UPDATE PA_PWP_CUSTOMER_SUMM PWP
285: SET INV_CP_RECIEPT_AMOUNT = 286: (SELECT SUM(AMOUNT_APPLIED) FROM AR_RECEIVABLE_APPLICATIONS_ALL ARA 287: WHERE
288: PWP.SYSTEM_REFERENCE = ARA.APPLIED_CUSTOMER_TRX_ID
289: AND ARA.GL_DATE BETWEEN l_start_date AND l_end_date
290: )