DBA Data[Home] [Help]

APPS.WMS_RULES_WORKBENCH_PVT dependencies on PJM_PROJECTS_MTLL_V

Line 400: from pjm_projects_mtll_v ppov

396:
397: Begin
398:
399: select distinct ppov.project_name into l_project_name
400: from pjm_projects_mtll_v ppov
401: where ppov.project_id = p_project_id;
402:
403: Return l_project_name;
404: Exception

Line 423: FROM pjm_tasks_mtll_v ptev, pjm_projects_mtll_v p

419: Begin
420:
421: -------------------
422: SELECT nvl(p.project_number, '') || ' / ' || nvl(ptev.TASK_NUMBER, '') into l_task_name
423: FROM pjm_tasks_mtll_v ptev, pjm_projects_mtll_v p
424: where p.project_id = ptev.project_id
425: and ptev.project_id = p_project_id
426: and ptev.task_id = p_task_id;
427: -------------