left join panattrs ca on ((ca.objectid = c.cardid)
                             and (ca.attrcode = 'PAN')
                             and (ca.startdate <= :BeginDate))

select c.panid,
       c.Pan as NUM,
       c.clientid
from docum c
  inner join contracts ct on ((ct.contractid = c.contractid))
  inner join contractkindsref ck on ((ck.contractkind = ct.contractkind)
                                        and (ck.id = 75434))
  inner join loyaltysystemsref ls on ((ls.id = 75434)
                                         and (ls.loyaltysyscode = 'MOCNAYA'))
  inner join contractkindattrs cka on ((cka.contractkind = ck.contractkind)
                                          and (cka.attrcode = 'LOYALTYSYSTEMS')
                                          and ((select api_string.InIntervals(ls.loyaltysysid, cka.attrasvarchar) from dual) = 1))
  inner join docproducts cp on ((cp.cardproductid = c.cardproductid)
                                 and (cp.id = 75434))
  inner join docproductattrs cpa on ((cpa.objectid = cp.cardproductid)
                                      and (cpa.attrcode = 'LOYALTYSYSTEMS')
                                      and ((select api_string.InIntervals(ls.loyaltysysid, cpa.attrasvarchar) from dual) = 1)
                                      and cpa.startdate <= :BeginDate
                                      and cpa.enddate > :BeginDate)
  inner join panattrs cas on ((cas.objectid = c.cardid)
                               and (cas.attrcode = 'STATEID')
                               and (cas.startdate <= :BeginDate)
                               and (nvl(cas.enddate, to_date('31/12/9999', 'dd/mm/yyyy')) >= :BeginDate))
  inner join statesref s on ((s.stateid = cas.attrasfloat)
                               and (s.id = 75434)
                               and (s.statesign in ('BETRAY') ))
  left join panattrs ca on ((ca.objectid = c.cardid)
                             and (ca.attrcode = 'PAN')
                             and (ca.startdate <= :BeginDate))
where (cas.startdate = :BeginDate)