SELECT *
	INTO :outcomePlanFavouriteID, 
		:username,
		:relatedID, 
		:recordStatus,
		:relatedType,
		:activityType,
		:relatedNameTextID,
		:versionNo
	FROM outcomePlanFavourite opf 
		WHERE opf.relatedType = :relatedType
			AND OPF. recordStatus = :recordStatus
			AND opf.username = :username
			AND (
					 EXISTS( SELECT * FROM outcomePlanExpectedOutcome opeo
										WHERE opeo.outcomePlanID = :outcomePlanID
											AND opeo.expectedOutcomeID = opf.relatedID
											AND opf.relatedType = 'OPIT31002'
					)
					OR
					EXISTS( SELECT * FROM OutcomePlanAction opa
									WHERE opa.outcomePlanID = :outcomePlanID
											AND opa.outcomeplanActionAdminID = opf.relatedID
											AND opf.relatedType = 'OPIT31001'
														
					)
			)