APPS.ZPB_SOLVE dependencies on ZPB_ANALYSIS_CYCLE_TASKS

Line 1527: FROM zpb_analysis_cycle_tasks

1523: FND_FILE.put_line(FND_FILE.LOG,'p_instance_id=' ||p_instance_id);
1524:
1525: -- Get the task id to pass on to the solve program
1526: SELECT task_id INTO l_taskid
1527: FROM zpb_analysis_cycle_tasks
1528: WHERE sequence =
1529: ( SELECT max(sequence)
1530: FROM zpb_analysis_cycle_tasks
1531: WHERE analysis_cycle_id = p_instance_id

Line 1530: FROM zpb_analysis_cycle_tasks

1526: SELECT task_id INTO l_taskid
1527: FROM zpb_analysis_cycle_tasks
1528: WHERE sequence =
1529: ( SELECT max(sequence)
1530: FROM zpb_analysis_cycle_tasks
1531: WHERE analysis_cycle_id = p_instance_id
1532: AND status_code IN ('COMPLETE')
1533: ) + 1
1534: AND analysis_cycle_id = p_instance_id;