DBA Data[Home] [Help]

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