DBA Data[Home] [Help]

APPS.WIP_JSI_VALIDATOR dependencies on PJM_PROJECTS_V

Line 1325: from pjm_projects_v mpv, pjm_project_parameters ppp, mtl_parameters mp

1321: -- Bug 4890215. Performance Fix
1322: -- sugupta 26th-May-2006
1323: select mpv.project_id --this query will return multiple rows if the project has tasks
1324: into g_dummy
1325: from pjm_projects_v mpv, pjm_project_parameters ppp, mtl_parameters mp
1326: where mpv.project_id = ppp.project_id
1327: and mpv.project_id = wjsi_row.project_id
1328: and ppp.organization_id = wjsi_row.organization_id
1329: and ppp.organization_id = mp.organization_id