APPS.CSF_TASKS_PUB dependencies on CAC_SR_OBJECT_CAPACITY

Line 1921: , cac_sr_object_capacity cac

1917: , cac.status trip_status
1918: FROM jtf_tasks_b t
1919: , jtf_task_assignments ta
1920: , jtf_task_statuses_b ts
1921: , cac_sr_object_capacity cac
1922: WHERE t.task_id = p_task_id
1923: AND ta.task_id = t.task_id
1924: AND ts.task_status_id = ta.assignment_status_id
1925: AND NVL (ts.assigned_flag, 'N') <> 'Y'

Line 1950: , cac_sr_object_capacity cac

1946: , cac.status trip_status
1947: FROM jtf_tasks_b t
1948: , jtf_task_assignments ta
1949: , jtf_task_statuses_b ts
1950: , cac_sr_object_capacity cac
1951: WHERE t.task_id = p_task_id
1952: AND ta.task_id = t.task_id
1953: AND ts.task_status_id = ta.assignment_status_id
1954: AND NVL (ts.assigned_flag, 'N') <> 'Y'

Line 2135: , cac_sr_object_capacity cac

2131: , cac.status trip_status
2132: FROM jtf_tasks_b t
2133: , jtf_task_assignments ta
2134: , jtf_task_statuses_b ts
2135: , cac_sr_object_capacity cac
2136: WHERE t.parent_task_id = p_parent_task_id
2137: AND ta.task_id = t.task_id
2138: AND ts.task_status_id = ta.assignment_status_id
2139: AND cac.object_capacity_id(+) = ta.object_capacity_id -- made this outer join for bug 6940526

Line 2259: FROM cac_sr_object_capacity cac

2255: OPEN c_task_list FOR l_query USING p_task_id;
2256: ELSIF p_trip_id IS NOT NULL THEN
2257: l_query := 'SELECT NVL(t.parent_task_id, t.task_id) task_id
2258: , task_split_flag
2259: FROM cac_sr_object_capacity cac
2260: , jtf_task_assignments ta
2261: , jtf_tasks_b t
2262: , jtf_task_statuses_b ts
2263: WHERE cac.object_capacity_id = :1