APPS.PA_TASK_WORKFLOW_PKG dependencies on PA_PROJECTS_ALL

Line 27: FROM PA_PROJECTS_ALL

23: ,completion_date end_date
24: ,project_type project_type
25: ,carrying_out_organization_id organization_id
26: ,project_status_code project_status
27: FROM PA_PROJECTS_ALL
28: WHERE project_id = p_project_id;
29:
30: -- Cursor to fetch the task information.
31: CURSOR c_task_info(p_project_id NUMBER, p_task_id NUMBER) IS

Line 57: PA_PROJECTS_ALL ppa

53: PA_PROJ_ELEM_VER_SCHEDULE ppevs,
54: PA_PROJ_ELEMENTS PPE1,
55: PA_PROJ_ELEMENT_VERSIONS ppev1,
56: PA_OBJECT_RELATIONSHIPS por,
57: PA_PROJECTS_ALL ppa
58: WHERE ppa.project_id = p_project_id
59: AND ppe.project_id = p_project_id
60: AND ppe.link_task_flag = 'Y'
61: AND ppe.type_id = 1