APPS.PA_PWP_SUMM_PKG dependencies on AR_RECEIVABLE_APPLICATIONS_ALL
Line 237: (SELECT SUM(AMOUNT_APPLIED) FROM AR_RECEIVABLE_APPLICATIONS_ALL ARA
233: --FOR RECEIPT AMOUNTS
234:
235: UPDATE PA_PWP_CUSTOMER_SUMM PWP
236: SET INV_CP_RECIEPT_AMOUNT = 237: (SELECT SUM(AMOUNT_APPLIED) FROM AR_RECEIVABLE_APPLICATIONS_ALL ARA 238: WHERE
239: PWP.SYSTEM_REFERENCE = ARA.APPLIED_CUSTOMER_TRX_ID
240: AND ARA.GL_DATE BETWEEN l_start_date AND l_end_date
241: )