257: -- See bug 402125 for details
258: -- Bug 5034402: If the start/end date of the source task is NULL then copied
259: -- start/end date of the target project to start/end date of target task.Added by sunkalya for porting fix from Bug#5014950 to R12
260: SELECT 261: pa_tasks_s.nextval 262: , x_new_project_id
263: , t.task_number
264: , t.task_name
265: , nvl(t.long_task_name, t.task_name) /* Bug#2638968 */