(select count(df.id) as number_of_files from SUBMISSION_SCHEDULE ss1 left join DATA_FILE_SUMMARY_INFO dfsi on dfsi.SUBMISSION_PERIOD_SID = :spsid AND dfsi.CUSTOMER_SID = :spcustomerSid left join DATA_TYPE dt1 on ss1.DATA_TYPE_SID = dt1.SID left join DATA_FILE df on dfsi.CUSTOMER_SID = df.CUSTOMER_SID AND dfsi.DATA_FILE_SID = df.SID AND df.DELETED = 0 AND df.DATA_TYPE = dt1.TYPE where ss1.SID = :spsssid AND ss1.CUSTOMER_SID= :spcustomersid);