APPS.AMW_AUDIT_ENGAGEMENT_PVT dependencies on PA_TASKS

Line 407: from pa_tasks

403: i NUMBER;
404:
405: cursor c_tasks IS
406: select *
407: from pa_tasks
408: where project_id = p_created_from_project_id
409: start with parent_task_id is null
410: connect by prior task_id = parent_task_id;
411:

Line 426: FROM pa_tasks

422: l_task_in(i).TASK_DESCRIPTION := task_rec.DESCRIPTION;
423:
424: if task_rec.PARENT_TASK_ID is NOT NULL then
425: SELECT task_number into l_pm_parent_task_reference
426: FROM pa_tasks
427: WHERE task_id = task_rec.PARENT_TASK_ID;
428:
429: l_task_in(i).PM_PARENT_TASK_REFERENCE := l_pm_parent_task_reference;
430: end if;

Line 863: from pa_tasks

859: from pa_projects_all
860: where project_id = p_project_id;
861:
862: select task_number into l_task_number
863: from pa_tasks
864: where task_id = p_task_id
865: and project_id = p_project_id;
866:
867: FND_MSG_PUB.initialize;