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 1849: delete from pa_project_asset_assignments

1845:
1846: -- Delete project asset assignments
1847: x_err_stage := 'Delete project asset assignments for task '|| x_task_id;
1848: forall i in l_task_id_tab.FIRST..l_task_id_tab.LAST
1849: delete from pa_project_asset_assignments
1850: where task_id =l_task_id_tab(i) ;
1851:
1852: end if ;
1853:

Line 1933: -- delete from pa_project_asset_assignments

1929: -- Delete project asset assigments
1930: -- 3693197 : Commented and moved above in the anonymous block
1931:
1932: --x_err_stage := 'Delete proj asset assignmt for task '|| x_task_id;
1933: -- delete from pa_project_asset_assignments
1934: -- where task_id in
1935: -- (select task_id
1936: -- from pa_tasks
1937: -- CONNECT BY PRIOR TASK_ID = PARENT_TASK_ID