APPS.PA_PROJECT_CORE dependencies on PA_JOB_BILL_RATE_OVERRIDES

Line 385: -- delete from pa_job_bill_rate_overrides

381:
382: -- anlee
383: -- Commented out for performance bug 2800074
384: -- Delete job bill rate overrides
385: -- delete from pa_job_bill_rate_overrides
386: -- where (project_id = x_project_id
387: -- or task_id in (select task_id from pa_tasks
388: -- where project_id = x_project_id));
389:

Line 390: DELETE FROM PA_JOB_BILL_RATE_OVERRIDES

386: -- where (project_id = x_project_id
387: -- or task_id in (select task_id from pa_tasks
388: -- where project_id = x_project_id));
389:
390: DELETE FROM PA_JOB_BILL_RATE_OVERRIDES
391: WHERE PROJECT_ID = x_project_id ;
392:
393: -- commented for bug#3693197 and replaced with bulk delete
394: -- DELETE FROM PA_JOB_BILL_RATE_OVERRIDES

Line 394: -- DELETE FROM PA_JOB_BILL_RATE_OVERRIDES

390: DELETE FROM PA_JOB_BILL_RATE_OVERRIDES
391: WHERE PROJECT_ID = x_project_id ;
392:
393: -- commented for bug#3693197 and replaced with bulk delete
394: -- DELETE FROM PA_JOB_BILL_RATE_OVERRIDES
395: -- WHERE ( TASK_ID IN (SELECT TASK_ID
396: -- FROM PA_TASKS
397: -- WHERE PROJECT_ID = x_project_id ));
398:

Line 401: DELETE FROM PA_JOB_BILL_RATE_OVERRIDES

397: -- WHERE PROJECT_ID = x_project_id ));
398:
399: if nvl(l_tasks_tbl.last,0) > 0 then
400: forall i in l_tasks_tbl.first..l_tasks_tbl.last
401: DELETE FROM PA_JOB_BILL_RATE_OVERRIDES
402: WHERE task_id = l_tasks_tbl(i);
403: end if ;
404:
405: -- anlee

Line 1657: -- delete from pa_job_bill_rate_overrides

1653: -- START WITH TASK_ID = x_TASK_ID);
1654: --
1655: -- -- Delete job bill rate overrides
1656: -- x_err_stage := 'Delete job bill rate overrides for task '|| x_task_id;
1657: -- delete from pa_job_bill_rate_overrides
1658: -- where task_id in
1659: -- (select task_id
1660: -- from pa_tasks
1661: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID

Line 1666: -- delete from pa_job_bill_rate_overrides

1662: -- START WITH TASK_ID = x_TASK_ID);
1663: --
1664: -- -- Delete job bill title overrides
1665: -- x_err_stage := 'Delete job bill title overrides for task '|| x_task_id;
1666: -- delete from pa_job_bill_rate_overrides
1667: -- where task_id in
1668: -- (select task_id
1669: -- from pa_tasks
1670: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID

Line 1825: delete from pa_job_bill_rate_overrides

1821:
1822: -- Delete job bill rate overrides
1823: x_err_stage := 'Delete job bill rate overrides for task '|| x_task_id;
1824: forall i in l_task_id_tab.FIRST..l_task_id_tab.LAST
1825: delete from pa_job_bill_rate_overrides
1826: where task_id =l_task_id_tab(i) ;
1827:
1828: -- Delete job assignment overrides
1829: x_err_stage := 'Delete job assignment overrides for task '|| x_task_id;