Summary Table

Categories Total Count
PII 0
URL 0
DNS 1
EKL 0
IP 0
PORT 0
VsID 0
CF 0
AI 0
VPD 0
PL 0
Other 0

File Content

package gov.va.med.ars.dao.fpps;

import java.math.BigInteger;

import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.query.Param;
import org.springframework.stereotype.Repository;

import gov.va.med.domain.fee.Claim;

/**
* @author
DNS
*
*/
@Repository
public interface IRfaiFppsClaimRepository extends JpaRepository<Claim, Long> {

@Query("select c from fClaim c JOIN FETCH c.providerInfos p JOIN FETCH c.personInfos pe JOIN FETCH c.claimProcedures cp where c.claimIndex = :claimIndex")
Claim getClaimInformation(@Param("claimIndex") BigInteger id);


@Query("select cl from fClaim cl JOIN FETCH cl.personInfos pe JOIN FETCH cl.vaFacility vaf where cl.claimIndex = :claimIndex")
Claim getClaimWithVaFacilityAndPersonInfo(@Param("claimIndex") BigInteger claimIndex);

}