DBA Data[Home] [Help]

APPS.EAM_WO_VALIDATE_PVT dependencies on PJM_PROJECT_PARAMETERS_V

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

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