72: Select 1 into dummy
73: from pa_project_types ppt,
74: pa_tasks pt,
75: pa_tasks pt2,
76: pa_projects_all ppr -- Changed to _ALL as part of MOAC changes
77: where p_task_id = pt.task_id and
78: p_project_id = pt.project_id and
79: pt.project_id = ppr.project_id and
80: ppr.template_flag <> 'Y' and