DBA Data[Home] [Help]

APPS.PA_MU_DETAILS_V_PKG dependencies on PA_TASKS

Line 220: FROM pa_tasks

216: -- Cursor for selecting all the tasks for the given project
217: --
218: CURSOR l_ProjTasks_csr (p_project_id NUMBER) IS
219: SELECT task_id, carrying_out_organization_id organization_id
220: FROM pa_tasks
221: WHERE project_id = p_project_id;
222:
223: --
224: -- Cursor for selecting all the tasks that belongs to the organization

Line 229: FROM pa_tasks t, pa_projects p

225: -- of the given project
226: --
227: CURSOR l_OrgTasks_csr (x_project_id NUMBER) IS
228: SELECT t.task_id, t.carrying_out_organization_id organization_id
229: FROM pa_tasks t, pa_projects p
230: WHERE t.carrying_out_organization_id = p.carrying_out_organization_id
231: AND t.project_id = p.project_id
232: AND p.project_id = x_project_id;
233: