SELECT
InvestigationConfig.investigationConfigID,
InvestigationConfig.type,
InvestigationConfig.homePageIdentifier,
InvCAssessmentConfig.startDate,
InvCAssessmentConfig.endDate,
InvestigationConfig.recordStatus
INTO
:investigationConfigID,
:investigationConfigType,
:homePageName,
:startDate,
:endDate,
:statusCode
FROM
InvestigationConfig,
InvCAssessmentConfig
WHERE InvCAssessmentConfig.assessmentConfigurationID = :assessmentConfigurationID
AND InvestigationConfig.investigationConfigID = InvCAssessmentConfig.investigationConfigID
|