DBA Data[Home] [Help]

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: )