APPS.PA_MU_DETAILS_V_PKG dependencies on PA_PROJECTS

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:

Line 241: FROM pa_projects p

237: --
238: CURSOR l_proj_csr IS
239: SELECT p.project_id, p.carrying_out_organization_id organization_id,
240: pa_security.allow_update(p.project_id) allow_update
241: FROM pa_projects p
242: WHERE
243: -- p.project_status_code <> 'CLOSED'. **** Archive Purge changes ****
244: pa_project_stus_utils.is_project_status_closed(p.project_status_code) <> 'Y'
245: AND p.carrying_out_organization_id = X_Search_Organization_ID

Line 310: FROM pa_projects

306: -- Get the organization_id of the given project
307: SELECT carrying_out_organization_id,
308: pa_security.allow_update(project_id)
309: INTO l_proj_organization_id, l_allow_update
310: FROM pa_projects
311: WHERE project_id = X_Search_Project_ID;
312:
313: --Bug 4629597.
314: --IF (NOT (line_exists(X_Batch_ID, X_Search_Project_ID, NULL))) THEN