DBA Data[Home] [Help]

APPS.INV_UI_TASK_LOVS dependencies on PJM_TASKS_V

Line 25: --Bug 12385456 Changing the view from pjm_tasks_mtll_v to pjm_tasks_v as the previous one will

21: p_project_id IN VARCHAR
22: )
23: IS
24: BEGIN
25: --Bug 12385456 Changing the view from pjm_tasks_mtll_v to pjm_tasks_v as the previous one will
26: --show all the tasks including some invalid ones.
27: OPEN x_tasks FOR
28: SELECT t.task_id,
29: NVL ( t.task_number, ' ' ),

Line 31: FROM pjm_tasks_v t

27: OPEN x_tasks FOR
28: SELECT t.task_id,
29: NVL ( t.task_number, ' ' ),
30: NVL ( t.task_name, ' ' )
31: FROM pjm_tasks_v t
32: WHERE t.task_number LIKE ( p_restrict_tasks )
33: AND t.project_id = p_project_id
34: ORDER BY 2;
35: END GET_TASKS;