DBA Data[Home] [Help]

APPS.WIP_EAM_UTILS dependencies on PJM_PROJECT_PARAMETERS

Line 111: pjm_project_parameters ppp

107: -- 4. Project Id
108: if p_project_number is not null then
109: select ppv.project_id into l_project_id
110: from pjm_projects_v ppv,
111: pjm_project_parameters ppp
112: where ppv.project_id = ppp.project_id
113: and ppp.organization_id = p_org_id
114: and ppv.project_number = p_project_number;
115: end if;

Line 121: pjm_project_parameters ppp,

117: if p_project_number is not null and p_task_number is not null then
118: select /*+ leading( ppv ) */ ppv.project_id, mtv.task_id into
119: l_project_id, l_task_id
120: from pjm_projects_v ppv,
121: pjm_project_parameters ppp,
122: mtl_task_v mtv
123: where ppv.project_id = ppp.project_id
124: and mtv.project_id(+) = ppp.project_id
125: and ppp.organization_id = p_org_id