APPS.PA_PROJECT_CORE dependencies on PA_JOB_BILL_TITLE_OVERRIDES

Line 408: -- delete from pa_job_bill_title_overrides

404:
405: -- anlee
406: -- Commented out for performance
407: -- Delete job bill title overrides
408: -- delete from pa_job_bill_title_overrides
409: -- where (project_id = x_project_id
410: -- or task_id in (select task_id from pa_tasks
411: -- where project_id = x_project_id));
412:

Line 413: DELETE FROM pa_job_bill_title_overrides

409: -- where (project_id = x_project_id
410: -- or task_id in (select task_id from pa_tasks
411: -- where project_id = x_project_id));
412:
413: DELETE FROM pa_job_bill_title_overrides
414: WHERE PROJECT_ID = x_project_id ;
415:
416: -- commented for bug#3693197 and replaced with bulk delete
417: -- DELETE FROM pa_job_bill_title_overrides

Line 417: -- DELETE FROM pa_job_bill_title_overrides

413: DELETE FROM pa_job_bill_title_overrides
414: WHERE PROJECT_ID = x_project_id ;
415:
416: -- commented for bug#3693197 and replaced with bulk delete
417: -- DELETE FROM pa_job_bill_title_overrides
418: -- WHERE ( TASK_ID IN (SELECT TASK_ID
419: -- FROM PA_TASKS
420: -- WHERE PROJECT_ID = x_project_id ));
421:

Line 424: DELETE FROM pa_job_bill_title_overrides

420: -- WHERE PROJECT_ID = x_project_id ));
421:
422: if nvl(l_tasks_tbl.last,0) > 0 then
423: forall i in l_tasks_tbl.first..l_tasks_tbl.last
424: DELETE FROM pa_job_bill_title_overrides
425: WHERE task_id = l_tasks_tbl(i);
426: end if ;
427:
428: -- anlee