702: , t.source_object_id
703: , t.planned_start_date
704: , t.planned_end_date
705: FROM ( SELECT sched_request_id
706: FROM csf_r_sched_requests
707: WHERE parent_request_id = p_request_id
708: UNION ALL
709: SELECT sched_request_id
710: FROM csf_r_sched_requests
706: FROM csf_r_sched_requests
707: WHERE parent_request_id = p_request_id
708: UNION ALL
709: SELECT sched_request_id
710: FROM csf_r_sched_requests
711: WHERE sched_request_id = p_request_id
712: AND NOT EXISTS (SELECT 1
713: FROM csf_r_sched_requests
714: WHERE parent_request_id = p_request_id)
709: SELECT sched_request_id
710: FROM csf_r_sched_requests
711: WHERE sched_request_id = p_request_id
712: AND NOT EXISTS (SELECT 1
713: FROM csf_r_sched_requests
714: WHERE parent_request_id = p_request_id)
715: ) r
716: , csf_r_request_tasks rt
717: , jtf_tasks_b t