APPS.PA_PROJECT_CORE dependencies on PA_NL_BILL_RATE_OVERRIDES

Line 477: -- delete from pa_nl_bill_rate_overrides

473:
474: -- anlee
475: -- Commented out for performance bug 2800083
476: -- Delete non-labor bill rate overrides
477: -- delete from pa_nl_bill_rate_overrides
478: -- where (project_id = x_project_id
479: -- or task_id in (select task_id from pa_tasks
480: -- where project_id = x_project_id));
481:

Line 482: DELETE FROM PA_NL_BILL_RATE_OVERRIDES

478: -- where (project_id = x_project_id
479: -- or task_id in (select task_id from pa_tasks
480: -- where project_id = x_project_id));
481:
482: DELETE FROM PA_NL_BILL_RATE_OVERRIDES
483: WHERE PROJECT_ID = x_project_id ;
484:
485: -- commented for bug#3693197 and replaced with bulk delete
486: -- DELETE FROM PA_NL_BILL_RATE_OVERRIDES

Line 486: -- DELETE FROM PA_NL_BILL_RATE_OVERRIDES

482: DELETE FROM PA_NL_BILL_RATE_OVERRIDES
483: WHERE PROJECT_ID = x_project_id ;
484:
485: -- commented for bug#3693197 and replaced with bulk delete
486: -- DELETE FROM PA_NL_BILL_RATE_OVERRIDES
487: -- WHERE ( TASK_ID IN (SELECT TASK_ID
488: -- FROM PA_TASKS
489: -- WHERE PROJECT_ID = x_project_id ));
490:

Line 493: DELETE FROM PA_NL_BILL_RATE_OVERRIDES

489: -- WHERE PROJECT_ID = x_project_id ));
490:
491: if nvl(l_tasks_tbl.last,0) > 0 then
492: forall i in l_tasks_tbl.first..l_tasks_tbl.last
493: DELETE FROM PA_NL_BILL_RATE_OVERRIDES
494: WHERE task_id = l_tasks_tbl(i);
495: end if ;
496:
497:

Line 1693: -- delete from pa_nl_bill_rate_overrides

1689: -- START WITH TASK_ID = x_TASK_ID);
1690: --
1691: -- -- Delete non-labor bill rate overrides
1692: -- x_err_stage := 'Delete nl bill rate overrides for task '|| x_task_id;
1693: -- delete from pa_nl_bill_rate_overrides
1694: -- where task_id in
1695: -- (select task_id
1696: -- from pa_tasks
1697: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID

Line 1843: delete from pa_nl_bill_rate_overrides

1839:
1840: -- Delete nl bill rate overrides
1841: x_err_stage := 'Delete nl bill rate overrides for task '|| x_task_id;
1842: forall i in l_task_id_tab.FIRST..l_task_id_tab.LAST
1843: delete from pa_nl_bill_rate_overrides
1844: where task_id =l_task_id_tab(i) ;
1845:
1846: -- Delete project asset assignments
1847: x_err_stage := 'Delete project asset assignments for task '|| x_task_id;