APPS.CSF_TASK_ASSIGNMENTS_PUB dependencies on CAC_SR_OBJECT_CAPACITY

Line 86: , cac_sr_object_capacity cac

82: , cac.object_version_number old_trip_ovn
83: FROM jtf_tasks_b t
84: , jtf_task_assignments ta
85: , jtf_task_statuses_b ts
86: , cac_sr_object_capacity cac
87: WHERE t.task_id = p_task_id
88: AND ta.task_id (+) = t.task_id
89: AND ts.task_status_id (+) = ta.assignment_status_id
90: AND cac.object_capacity_id (+) = ta.object_capacity_id

Line 346: , cac_sr_object_capacity cac

342: , 'N'
343: ) other_ta_exists
344: FROM jtf_tasks_b t
345: , jtf_task_assignments ta
346: , cac_sr_object_capacity cac
347: WHERE ta.task_assignment_id = p_task_assignment_id
348: AND t.task_id = ta.task_id
349: AND cac.object_capacity_id (+) = ta.object_capacity_id;
350:

Line 896: FROM CAC_SR_OBJECT_CAPACITY

892:
893: CURSOR TRIP_SD(L_TRIP_ID NUMBER)
894: IS
895: SELECT START_dATE_TIME
896: FROM CAC_SR_OBJECT_CAPACITY
897: WHERE OBJECT_CAPACITY_ID = L_TRIP_ID;
898: cursor c_Task_number(l_task number)
899: is
900: select task_number

Line 1293: FROM CAC_SR_OBJECT_CAPACITY

1289:
1290: CURSOR TRIP_SD(L_TRIP_ID NUMBER)
1291: IS
1292: SELECT START_dATE_TIME
1293: FROM CAC_SR_OBJECT_CAPACITY
1294: WHERE OBJECT_CAPACITY_ID = L_TRIP_ID;
1295:
1296: cursor c_Task_number(l_task number)
1297: is

Line 1498: cac_sr_object_capacity cac

1494: cac.start_date_time ,
1495: cac.end_date_time
1496: FROM jtf_tasks_b jtb ,
1497: jtf_task_assignments jta,
1498: cac_sr_object_capacity cac
1499: WHERE jta.task_assignment_id = p_task_assignment_id
1500: AND jta.task_id = jtb.task_id
1501: AND cac.object_capacity_id (+) = jta.object_capacity_id;
1502: