Help Needed With This Query (sproc)

When i try to run this sproc no rows are are returned but if i give PlanId = 898 and PortfolioId = 1913  i should get one row.. This is my sproc

 ALTER PROCEDURE [dbo].[rpt_Custom_AllocationsSub]
(
@PlanId int,
@PortfolioId int
)
AS
SELECT
c.PlanId,
c.PlanName,
pp.PortfolioId,
pp.PortfolioName,
pp.PortfolioDescription,
f.FundId,
p.displayOrder,
case When pf.PlanFundDisplayName IS NULL THEN f.ShortName ELSE pf.PlanFundDisplayName END FundNames,
CAST(p.AllocationPercent AS integer) AS PPF_Percent
FROM
Fund f
INNER JOIN PlanPortfolioFund p
ON f.FundId = p.FundId

INNER JOIN PlanFund pf
on f.FundId = pf.FundId
RIGHT OUTER JOIN [ClientPlan] c
INNER JOIN PlanPortfolio pp ON c.PlanId = pp.PlanId
ON p.PortfolioId = pp.PortfolioId
WHERE
c.PlanId = @PlanId
ANDp.PortfolioId = @PortfolioId
AND pf.PlanId = pp.PlanId
order by p.DisplayOrder

 This is my table structure

ClientPlanId

  PlanId int indentity

PlanFund -- PlanId int, FundId int

PlanPortfolio -- PortfolioId int, PlanId int, PortfolioName varchar , PortfolioDescription varchar

PlanPortfolioFund PortfolioId int, FundId int, AllocationPercent int.

 

any help will be appreciated...

Thanks

Karen