DBA Data[Home] [Help]

APPS.CSR_SCHEDULER_PVT dependencies on CSF_R_SCHED_REQUESTS

Line 732: FROM csf_r_sched_requests

728: , t.source_object_id
729: , t.planned_start_date
730: , t.planned_end_date
731: FROM ( SELECT sched_request_id
732: FROM csf_r_sched_requests
733: WHERE parent_request_id = p_request_id
734: UNION ALL
735: SELECT sched_request_id
736: FROM csf_r_sched_requests

Line 736: FROM csf_r_sched_requests

732: FROM csf_r_sched_requests
733: WHERE parent_request_id = p_request_id
734: UNION ALL
735: SELECT sched_request_id
736: FROM csf_r_sched_requests
737: WHERE sched_request_id = p_request_id
738: AND NOT EXISTS (SELECT 1
739: FROM csf_r_sched_requests
740: WHERE parent_request_id = p_request_id)

Line 739: FROM csf_r_sched_requests

735: SELECT sched_request_id
736: FROM csf_r_sched_requests
737: WHERE sched_request_id = p_request_id
738: AND NOT EXISTS (SELECT 1
739: FROM csf_r_sched_requests
740: WHERE parent_request_id = p_request_id)
741: ) r
742: , csf_r_request_tasks rt
743: , jtf_tasks_b t