[Home] [Help]
10498: select 'x'
10499: from pa_project_role_types_v roles,
10500: pa_role_controls controls,
10501: pa_projects_all proj,
10502: pa_role_list_members prlm
10503: where proj.project_id=p_project_id
10504: and proj.ROLE_LIST_ID =prlm.role_list_id
10505: and prlm.project_role_id = roles.project_role_id
10506: and roles.project_role_id=controls.project_role_id