APPS.PA_PWP_INVOICE_REL dependencies on AR_RECEIVABLE_APPLICATIONS_ALL

Line 87: FROM AR_RECEIVABLE_APPLICATIONS_ALL ARA

83: AND ei.system_linkage_function = 'VI'
84: AND ei.transaction_source ='AP INVOICE' --AND prj.project_id = 1027;
85: AND EXISTS -- atleast one reciept applied between rec start and end date params
86: (SELECT 1
87: FROM AR_RECEIVABLE_APPLICATIONS_ALL ARA
88: WHERE ARA.STATUS = 'APP'
89: AND ara.APPLICATION_TYPE = 'CASH'
90: AND ARA.applied_customer_trx_id = RAC.customer_trx_id
91: and trunc(ARA.APPLY_DATE) between trunc(nvl(rec_date_from,ARA.APPLY_DATE-1)) and trunc(nvl(rec_date_to,ARA.APPLY_DATE + 1))

Line 126: FROM AR_RECEIVABLE_APPLICATIONS_ALL ARA

122: PI.INVOICE_BATCH_SOURCE_ID = BATCH_SOURCE_ID
123: ) --Bug 8204634
124: AND EXISTS -- atleast one reciept applied between rec start and end date params
125: (SELECT 1
126: FROM AR_RECEIVABLE_APPLICATIONS_ALL ARA
127: WHERE ARA.STATUS = 'APP'
128: AND ara.APPLICATION_TYPE = 'CASH'
129: AND ARA.applied_customer_trx_id = RAC.customer_trx_id
130: and trunc(ARA.APPLY_DATE) between trunc(nvl(rec_date_from,ARA.APPLY_DATE-1)) and trunc(nvl(rec_date_to,ARA.APPLY_DATE + 1))

Line 193: FROM AR_RECEIVABLE_APPLICATIONS_ALL ARA

189: PI.INVOICE_BATCH_SOURCE_ID = BATCH_SOURCE_ID
190: ) --Bug 8204634
191: AND EXISTS -- atleast one reciept applied between rec start and end date params
192: (SELECT 1
193: FROM AR_RECEIVABLE_APPLICATIONS_ALL ARA
194: WHERE ARA.STATUS = 'APP'
195: AND ara.APPLICATION_TYPE = 'CASH'
196: AND ARA.applied_customer_trx_id = RAC.customer_trx_id
197: and trunc(ARA.APPLY_DATE) between trunc(nvl(rec_date_from,ARA.APPLY_DATE-1)) and trunc(nvl(rec_date_to,ARA.APPLY_DATE + 1))