DBA Data[Home] [Help]

APPS.EAM_WO_VALIDATE_PVT dependencies on MTL_PROJECT_V

Line 2124: FROM mtl_project_v mpv, pjm_project_parameters_v ppp, mtl_parameters mp

2120: ))
2121: THEN
2122: SELECT distinct mpv.project_id --this query will return multiple rows if the project has tasks
2123: INTO g_dummy
2124: FROM mtl_project_v mpv, pjm_project_parameters_v ppp, mtl_parameters mp
2125: WHERE mpv.project_id = ppp.project_id
2126: AND mpv.project_id = p_eam_wo_rec.project_id
2127: AND ppp.organization_id = p_eam_wo_rec.organization_id
2128: AND ppp.organization_id = mp.organization_id