DBA Data[Home] [Help]

APPS.PJM_PROJTASK_DELETION dependencies on PA_TASKS

Line 186: FROM pa_tasks tsk

182: IF (p_task_id IS NOT NULL) OR (p_project_id IS NOT NULL) THEN
183: IF p_project_id IS NULL THEN
184: SELECT tsk.project_id
185: INTO l_project_id
186: FROM pa_tasks tsk
187: WHERE task_id = p_task_id;
188: ELSE
189: l_project_id := p_project_id;
190: END IF;