2040: ))
2041: THEN
2042: SELECT distinct mpv.project_id --this query will return multiple rows if the project has tasks
2043: INTO g_dummy
2044: FROM mtl_project_v mpv, pjm_project_parameters_v ppp, mtl_parameters mp
2045: WHERE mpv.project_id = ppp.project_id
2046: AND mpv.project_id = p_eam_wo_rec.project_id
2047: AND ppp.organization_id = p_eam_wo_rec.organization_id
2048: AND ppp.organization_id = mp.organization_id