APPS.PA_CI_IMPACTS_PUB dependencies on PA_TASKS

Line 35: select pt.task_id from pa_tasks pt,

31: l_task_id NUMBER;
32:
33: CURSOR get_task_id
34: IS
35: select pt.task_id from pa_tasks pt,
36: pa_control_items pc
37: where pt.project_id = pc.project_id
38: and pt.task_name = p_impacted_task_name
39: AND pc.ci_id = p_ci_id;

Line 241: select pt.task_id from pa_tasks pt,

237:
238:
239: CURSOR get_task_id
240: IS
241: select pt.task_id from pa_tasks pt,
242: pa_control_items pc
243: where pt.project_id = pc.project_id
244: and pt.task_name = p_impacted_task_name
245: AND pc.ci_id = p_ci_id;