Hi everyone - Could you please help with this query. I know the error but is there any alternativefor this?
Select * FROM #TempAutoclosure TmpAc
INNER JOIN (
SELECT pa.applicationid
,pa.PaymentRequestID
,pa.CreateDateTime RequestedDate
,pa.FEInvoiceNumber
,TPr.PaymentRequestStatus
FROM hydradb.dbo.PaymentRequest pa
INNER JOIN (
SELECT DISTINCT prh.PaymentRequestID
,PRS.title PaymentRequestStatus
FROM HYDRADB.dbo.PaymentRequestStatusHistory PRH
INNER JOIN #TempPaymentHistory t ON t.PaymentRequestID = prH.PaymentRequestID
AND t.Max_Createdatetime = PRH.Createdatetime
LEFT JOIN HYDRADB.dbo.PaymentRequestStatus prs ON prs.PaymentRequestStatusId = prh.PaymentRequestStatusId
WHERE prs.code IN (
'Pending'
,'invalid'
,'Approved'
)
AND datediff(dd, t.Max_Createdatetime, Getdate()) <= TmpAc.AssistanceInactivityAutoCloseDays --Check for Above filtered paymnets in last 120 days.
) TPr ON pa.PaymentRequestID = Tpr.PaymentRequestID
) pe ON pe.applicationid = TmpAc.applicationid