APPS.PA_PWP_SUMM_PKG dependencies on AR_PAYMENT_SCHEDULES

Line 154: FROM AR_PAYMENT_SCHEDULES ARP

150: , SUM(ARP.amount_due_remaining)
151: , SUM(ARP.amount_applied)
152: , SUM(nvl(ARP.amount_credited,0)) + SUM(nvl(ARP.amount_adjusted,0)) -- Bug 7785173 Added NVL
153: , SUM(ARP.TAX_ORIGINAL) Tax
154: FROM AR_PAYMENT_SCHEDULES ARP
155: WHERE PWP.SYSTEM_REFERENCE = ARP.CUSTOMER_TRX_ID
156: )
157: WHERE project_id = P_Project_Id
158: AND TRANSFER_STATUS_CODE = 'A';

Line 192: FROM AR_PAYMENT_SCHEDULES ARP

188: )
189: =
190: (SELECT SUM(ARP.amount_due_original )
191: , SUM(ARP.amount_applied)
192: FROM AR_PAYMENT_SCHEDULES ARP
193: WHERE PWP.SYSTEM_REFERENCE = ARP.CUSTOMER_TRX_ID
194: AND GL_DATE BETWEEN l_start_date AND l_end_date
195: )
196: WHERE project_id = P_Project_Id; */ -- bug 8208525 commented the code .

Line 225: FROM AR_PAYMENT_SCHEDULES ARP,

221:
222: UPDATE PA_PWP_CUSTOMER_SUMM pwp
223: SET INV_CP_BILL_AMOUNT = (SELECT SUM(ARP.amount_due_original )
224:
225: FROM AR_PAYMENT_SCHEDULES ARP,
226: PA_DRAFT_INVOICES PDA
227: WHERE PWP.SYSTEM_REFERENCE = ARP.CUSTOMER_TRX_ID
228: AND ARP.CUSTOMER_TRX_ID = PDA.SYSTEM_REFERENCE
229: AND PDA.GL_DATE BETWEEN l_start_date AND l_end_date