SELECT PRT.PROJECT_ROLE_ID , PRT.PROJECT_ROLE_TYPE , PRT.MEANING , PRT.DESCRIPTION , PRT.START_DATE_ACTIVE , PRT.END_DATE_ACTIVE FROM PA_PROJECT_ROLE_TYPES PRT , PA_ROLE_CONTROLS RC WHERE RC.PROJECT_ROLE_ID = PRT.PROJECT_ROLE_ID AND RC.ROLE_CONTROL_CODE = 'ALLOW_AS_CONTRACT_MEMBER'
SELECT PRT.PROJECT_ROLE_ID
, PRT.PROJECT_ROLE_TYPE
, PRT.MEANING
, PRT.DESCRIPTION
, PRT.START_DATE_ACTIVE
, PRT.END_DATE_ACTIVE
FROM PA_PROJECT_ROLE_TYPES PRT
, PA_ROLE_CONTROLS RC
WHERE RC.PROJECT_ROLE_ID = PRT.PROJECT_ROLE_ID
AND RC.ROLE_CONTROL_CODE = 'ALLOW_AS_CONTRACT_MEMBER'
|
|
|