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 244: select pt.task_id from pa_tasks pt,

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