DBA Data[Home] [Help]

APPS.WIP_VALIDATEMLHEADER_PVT dependencies on PJM_PROJECT_PARAMETERS

Line 3459: pjm_project_parameters ppp

3455: -- saugupta 25th-May-2006
3456: select mpv.project_id --if the project has tasks, this query returns multiple rows
3457: into wjsi_row.project_id
3458: from pjm_projects_v mpv,
3459: pjm_project_parameters ppp
3460: where mpv.project_number = wjsi_row.project_number
3461: and mpv.project_id = ppp.project_id
3462: and ppp.organization_id = wjsi_row.organization_id;
3463: end if;

Line 3482: pjm_project_parameters ppp,

3478: -- saugupta 25th-May-2006
3479: select mpv.project_id --this query will return multiple rows if the project has tasks
3480: into l_dummy
3481: from pjm_projects_v mpv,
3482: pjm_project_parameters ppp,
3483: mtl_parameters mp
3484: where mpv.project_id = ppp.project_id
3485: and mpv.project_id = wjsi_row.project_id
3486: and ppp.organization_id = wjsi_row.organization_id