APPS.PA_PWP_SUMM_PKG dependencies on AR_PAYMENT_SCHEDULES

Line 174: FROM AR_PAYMENT_SCHEDULES ARP

170: , SUM(ARP.amount_due_remaining)
171: , SUM(ARP.amount_applied)
172: , SUM(nvl(ARP.amount_credited,0)) + SUM(nvl(ARP.amount_adjusted,0)) -- Bug 7785173 Added NVL
173: , SUM(ARP.TAX_ORIGINAL) Tax
174: FROM AR_PAYMENT_SCHEDULES ARP
175: WHERE PWP.SYSTEM_REFERENCE = ARP.CUSTOMER_TRX_ID
176: )
177: WHERE project_id = P_Project_Id
178: AND TRANSFER_STATUS_CODE = 'A';

Line 241: FROM AR_PAYMENT_SCHEDULES ARP

237: )
238: =
239: (SELECT SUM(ARP.amount_due_original )
240: , SUM(ARP.amount_applied)
241: FROM AR_PAYMENT_SCHEDULES ARP
242: WHERE PWP.SYSTEM_REFERENCE = ARP.CUSTOMER_TRX_ID
243: AND GL_DATE BETWEEN l_start_date AND l_end_date
244: )
245: WHERE project_id = P_Project_Id; */ -- bug 8208525 commented the code .

Line 274: FROM AR_PAYMENT_SCHEDULES ARP,

270:
271: UPDATE PA_PWP_CUSTOMER_SUMM pwp
272: SET INV_CP_BILL_AMOUNT = (SELECT SUM(ARP.amount_due_original )
273:
274: FROM AR_PAYMENT_SCHEDULES ARP,
275: PA_DRAFT_INVOICES PDA
276: WHERE PWP.SYSTEM_REFERENCE = ARP.CUSTOMER_TRX_ID
277: AND ARP.CUSTOMER_TRX_ID = PDA.SYSTEM_REFERENCE
278: AND PDA.GL_DATE BETWEEN l_start_date AND l_end_date