DBA Data[Home] [Help]

APPS.WIP_VALIDATEMLHEADER_PVT dependencies on PJM_PROJECT_PARAMETERS

Line 3540: pjm_project_parameters ppp

3536: -- saugupta 25th-May-2006
3537: select mpv.project_id --if the project has tasks, this query returns multiple rows
3538: into wjsi_row.project_id
3539: from pjm_projects_v mpv,
3540: pjm_project_parameters ppp
3541: where mpv.project_number = wjsi_row.project_number
3542: and mpv.project_id = ppp.project_id
3543: and ppp.organization_id = wjsi_row.organization_id;
3544: end if;

Line 3563: pjm_project_parameters ppp,

3559: -- saugupta 25th-May-2006
3560: select mpv.project_id --this query will return multiple rows if the project has tasks
3561: into l_dummy
3562: from pjm_projects_v mpv,
3563: pjm_project_parameters ppp,
3564: mtl_parameters mp
3565: where mpv.project_id = ppp.project_id
3566: and mpv.project_id = wjsi_row.project_id
3567: and ppp.organization_id = wjsi_row.organization_id