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 1677: -- delete from pa_nl_bill_rate_overrides

1673: -- START WITH TASK_ID = x_TASK_ID);
1674: --
1675: -- -- Delete non-labor bill rate overrides
1676: -- x_err_stage := 'Delete nl bill rate overrides for task '|| x_task_id;
1677: -- delete from pa_nl_bill_rate_overrides
1678: -- where task_id in
1679: -- (select task_id
1680: -- from pa_tasks
1681: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID

Line 1827: delete from pa_nl_bill_rate_overrides

1823:
1824: -- Delete nl bill rate overrides
1825: x_err_stage := 'Delete nl bill rate overrides for task '|| x_task_id;
1826: forall i in l_task_id_tab.FIRST..l_task_id_tab.LAST
1827: delete from pa_nl_bill_rate_overrides
1828: where task_id =l_task_id_tab(i) ;
1829:
1830: -- Delete project asset assignments
1831: x_err_stage := 'Delete project asset assignments for task '|| x_task_id;