DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE dependencies on PA_PROJECT_ASSET_ASSIGNMENTS

Line 539: delete from pa_project_asset_assignments

535: delete from pa_ind_rate_schedules
536: where project_id = x_project_id;
537:
538: -- Delete project asset assigments
539: delete from pa_project_asset_assignments
540: where project_id = x_project_id;
541:
542: -- Delete project asset
543: delete from pa_project_assets

Line 1833: delete from pa_project_asset_assignments

1829:
1830: -- Delete project asset assignments
1831: x_err_stage := 'Delete project asset assignments for task '|| x_task_id;
1832: forall i in l_task_id_tab.FIRST..l_task_id_tab.LAST
1833: delete from pa_project_asset_assignments
1834: where task_id =l_task_id_tab(i) ;
1835:
1836: end if ;
1837:

Line 1917: -- delete from pa_project_asset_assignments

1913: -- Delete project asset assigments
1914: -- 3693197 : Commented and moved above in the anonymous block
1915:
1916: --x_err_stage := 'Delete proj asset assignmt for task '|| x_task_id;
1917: -- delete from pa_project_asset_assignments
1918: -- where task_id in
1919: -- (select task_id
1920: -- from pa_tasks
1921: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID