APPS.PA_PROJECT_CORE dependencies on PA_JOB_ASSIGNMENT_OVERRIDES

Line 431: -- delete from pa_job_assignment_overrides

427:
428: -- anlee
429: -- Commented out for performance
430: -- Delete job assignment overrides
431: -- delete from pa_job_assignment_overrides
432: -- where (project_id = x_project_id
433: -- or task_id in (select task_id from pa_tasks
434: -- where project_id = x_project_id));
435:

Line 436: DELETE FROM pa_job_assignment_overrides

432: -- where (project_id = x_project_id
433: -- or task_id in (select task_id from pa_tasks
434: -- where project_id = x_project_id));
435:
436: DELETE FROM pa_job_assignment_overrides
437: WHERE PROJECT_ID = x_project_id ;
438:
439: -- commented for bug#3693197 and replaced with bulk delete
440: -- DELETE FROM pa_job_assignment_overrides

Line 440: -- DELETE FROM pa_job_assignment_overrides

436: DELETE FROM pa_job_assignment_overrides
437: WHERE PROJECT_ID = x_project_id ;
438:
439: -- commented for bug#3693197 and replaced with bulk delete
440: -- DELETE FROM pa_job_assignment_overrides
441: -- WHERE ( TASK_ID IN (SELECT TASK_ID
442: -- FROM PA_TASKS
443: -- WHERE PROJECT_ID = x_project_id ));
444:

Line 447: DELETE FROM pa_job_assignment_overrides

443: -- WHERE PROJECT_ID = x_project_id ));
444:
445: if nvl(l_tasks_tbl.last,0) > 0 then
446: forall i in l_tasks_tbl.first..l_tasks_tbl.last
447: DELETE FROM pa_job_assignment_overrides
448: WHERE task_id = l_tasks_tbl(i);
449: end if ;
450:
451: -- anlee

Line 1675: -- delete from pa_job_assignment_overrides

1671: -- START WITH TASK_ID = x_TASK_ID);
1672: --
1673: -- -- Delete job assignment overrides
1674: -- x_err_stage := 'Delete job assignmt overrides for task '|| x_task_id;
1675: -- delete from pa_job_assignment_overrides
1676: -- where task_id in
1677: -- (select task_id
1678: -- from pa_tasks
1679: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID

Line 1831: delete from pa_job_assignment_overrides

1827:
1828: -- Delete job assignment overrides
1829: x_err_stage := 'Delete job assignment overrides for task '|| x_task_id;
1830: forall i in l_task_id_tab.FIRST..l_task_id_tab.LAST
1831: delete from pa_job_assignment_overrides
1832: where task_id =l_task_id_tab(i) ;
1833:
1834: -- Delete emp bill rate overrides
1835: x_err_stage := 'Delete emp bill rate overrides for task '|| x_task_id;