eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PA_PROJECT_CORE dependencies on PA_EMP_BILL_RATE_OVERRIDES

Line 454: -- delete from pa_emp_bill_rate_overrides

450:
451: -- anlee
452: -- Commented out for performance
453: -- Delete emp bill rate overrides
454: -- delete from pa_emp_bill_rate_overrides
455: -- where (project_id = x_project_id
456: -- or task_id in (select task_id from pa_tasks
457: -- where project_id = x_project_id));
458:

Line 459: DELETE FROM pa_emp_bill_rate_overrides

455: -- where (project_id = x_project_id
456: -- or task_id in (select task_id from pa_tasks
457: -- where project_id = x_project_id));
458:
459: DELETE FROM pa_emp_bill_rate_overrides
460: WHERE PROJECT_ID = x_project_id ;
461:
462: -- commented for bug#3693197 and replaced with bulk delete
463: -- DELETE FROM pa_emp_bill_rate_overrides

Line 463: -- DELETE FROM pa_emp_bill_rate_overrides

459: DELETE FROM pa_emp_bill_rate_overrides
460: WHERE PROJECT_ID = x_project_id ;
461:
462: -- commented for bug#3693197 and replaced with bulk delete
463: -- DELETE FROM pa_emp_bill_rate_overrides
464: -- WHERE ( TASK_ID IN (SELECT TASK_ID
465: -- FROM PA_TASKS
466: -- WHERE PROJECT_ID = x_project_id ));
467:

Line 470: DELETE FROM pa_emp_bill_rate_overrides

466: -- WHERE PROJECT_ID = x_project_id ));
467:
468: if nvl(l_tasks_tbl.last,0) > 0 then
469: forall i in l_tasks_tbl.first..l_tasks_tbl.last
470: DELETE FROM pa_emp_bill_rate_overrides
471: WHERE task_id = l_tasks_tbl(i);
472: end if ;
473:
474: -- anlee

Line 1668: -- delete from pa_emp_bill_rate_overrides

1664: -- START WITH TASK_ID = x_TASK_ID);
1665: --
1666: -- -- Delete emp bill rate overrides
1667: -- x_err_stage := 'Delete emp bill rate overrides for task '|| x_task_id;
1668: -- delete from pa_emp_bill_rate_overrides
1669: -- where task_id in
1670: -- (select task_id
1671: -- from pa_tasks
1672: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID

Line 1821: delete from pa_emp_bill_rate_overrides

1817:
1818: -- Delete emp bill rate overrides
1819: x_err_stage := 'Delete emp bill rate overrides for task '|| x_task_id;
1820: forall i in l_task_id_tab.FIRST..l_task_id_tab.LAST
1821: delete from pa_emp_bill_rate_overrides
1822: where task_id =l_task_id_tab(i) ;
1823:
1824: -- Delete nl bill rate overrides
1825: x_err_stage := 'Delete nl bill rate overrides for task '|| x_task_id;