DBA Data[Home] [Help]

APPS.ZPB_BUSAREA_MAINT dependencies on ZPB_ANALYSIS_CYCLE_TASKS

Line 1434: where TASK_ID in (select B.TASK_ID from ZPB_ANALYSIS_CYCLES A, ZPB_ANALYSIS_CYCLE_TASKS B

1430: delete from ZPB_WRITEBACK_TASKS
1431: where BUSINESS_AREA_ID = p_business_area_id;
1432:
1433: delete from ZPB_EXCP_RESULTS
1434: where TASK_ID in (select B.TASK_ID from ZPB_ANALYSIS_CYCLES A, ZPB_ANALYSIS_CYCLE_TASKS B
1435: where A.BUSINESS_AREA_ID = p_business_area_id
1436: AND A.ANALYSIS_CYCLE_ID = B.ANALYSIS_CYCLE_ID);
1437:
1438: for l_cycles in l_cycles_curs loop

Line 1443: delete from ZPB_ANALYSIS_CYCLE_TASKS

1439: delete from ZPB_AC_PARAM_VALUES
1440: where ANALYSIS_CYCLE_ID = l_cycles.ANALYSIS_CYCLE_ID;
1441: delete from ZPB_ANALYSIS_CYCLE_INSTANCES
1442: where ANALYSIS_CYCLE_ID = l_cycles.ANALYSIS_CYCLE_ID;
1443: delete from ZPB_ANALYSIS_CYCLE_TASKS
1444: where ANALYSIS_CYCLE_ID = l_cycles.ANALYSIS_CYCLE_ID;
1445: delete from ZPB_CYCLE_COMMENTS
1446: where ANALYSIS_CYCLE_ID = l_cycles.ANALYSIS_CYCLE_ID;
1447: delete from ZPB_CYCLE_DATASETS