26:
27: cursor GenProjects is
28: select gp.project_id,
29: gp.project_status_code
30: from pa_projects_all gp
31: where (gp.carrying_out_organization_id = x_organization_id
32: or x_organization_id is null )
33: and (gp.project_type = x_project_type
34: or x_project_type is null )