1670: l_org_project_exists := 'N';
1671: SELECT 'Y'
1672: INTO l_org_project_exists
1673: FROM pa_projects_all pp,
1674: pa_project_types_all pt
1675: WHERE pp.project_id = p_project_id
1676: AND pt.project_type = pp.project_type
1677: AND pp.org_id = pt.org_id
1678: AND pt.org_project_flag = 'Y';