How to get Projected End Date?

Summary:

How to get Projected End Date?

Content (required):

Hello,

we wrote the follow piece of SQL

select pc.*

--to_char(PC.CONTRACT_END_DATE,'MM-DD-YYYY')

from

PER_ALL_ASSIGNMENTS_F PAAF, PER_PERIODS_OF_SERVICE PPOS, PER_CONTRACTS_F PC

where

PAAF.assignment_number='C8000045178'

--PAAF.person_id=300001123353062

--PAAF.person_id = :{PARAMETER.P_PERSON_ID}

AND PAAF.period_of_Service_id = PPOS.period_of_Service_id

AND PAAF.primary_flag ='Y'

AND PAAF.ASSIGNMENT_type ='C'

AND PAAF.ASSIGNMENT_STATUS_TYPE <> 'INACTIVE'

AND PC.Person_id = PAAF.person_id

AND PC.period_of_Service_id = PPOS.period_of_Service_id