(select
             df.id,df.file_name,df.record_count,dfsi.num_slis,dfsi.num_ilis
             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);--spsid is the input