APPS.CSF_TASK_ASSIGNMENTS_PUB dependencies on JTF_TASK_STATUSES_B

Line 85: , jtf_task_statuses_b ts

81: , cac.object_capacity_id old_trip_id
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

Line 332: FROM jtf_task_assignments ta2, jtf_task_statuses_b ts2

328: , cac.object_capacity_id trip_id
329: , cac.object_version_number trip_ovn
330: , NVL(
331: ( SELECT 'Y'
332: FROM jtf_task_assignments ta2, jtf_task_statuses_b ts2
333: WHERE ta2.task_id = t.task_id
334: AND ta2.task_assignment_id <> ta.task_assignment_id
335: AND ts2.task_status_id = ta2.assignment_status_id
336: AND NVL(ts2.cancelled_flag, 'N') <> 'Y'

Line 353: from jtf_Task_assignments jta , jtf_task_statuses_b jtb

349: AND cac.object_capacity_id (+) = ta.object_capacity_id;
350:
351: cursor c_tasks is
352: select jta.assignment_status_id,jtb.validation_start_date,jtb.validation_end_date,jta.task_id,JTA.OBJECT_CAPACITY_ID
353: from jtf_Task_assignments jta , jtf_task_statuses_b jtb
354: where jta.assignment_status_id= jtb.task_status_id
355: and jta.task_assignment_id=p_task_assignment_id
356: and jtb.enforce_validation_flag = 'Y'
357: and nvl(jtb.validation_start_date,sysdate) <= sysdate

Line 565: FROM jtf_task_assignments ta, jtf_task_statuses_b ts

561:
562: CURSOR c_cancelled_assignments IS
563: SELECT ta.task_assignment_id
564: , ta.object_version_number
565: FROM jtf_task_assignments ta, jtf_task_statuses_b ts
566: WHERE ta.task_id = p_task_id
567: AND ta.resource_id = p_resource_id
568: AND ta.resource_type_code = p_resource_type_code
569: AND ta.assignment_status_id = ts.task_status_id

Line 871: FROM jtf_task_statuses_b ts

867:
868: -- cursor to fetch the Cancelled Flag corresponding to the new Task Status.
869: CURSOR c_task_status_info IS
870: SELECT NVL (ts.cancelled_flag, 'N') cancelled_flag
871: FROM jtf_task_statuses_b ts
872: WHERE ts.task_status_id = p_assignment_status_id;
873:
874: -- cursor to fetch Information about the Task Assignment.
875: CURSOR c_task_assignment_info IS

Line 888: from jtf_task_statuses_b jtb

884:
885: CURSOR c_cross_task(p_sched_start_date date, p_sched_end_date date)
886: IS
887: select jtB.TASK_status_id,jtb.validation_start_date,jtb.validation_end_date
888: from jtf_task_statuses_b jtb
889: where jtb.enforce_validation_flag = 'Y'
890: and nvl(jtb.validation_start_date,nvl(trunc(p_sched_start_date),sysdate)) <= nvl(trunc(p_sched_start_date),sysdate)
891: and nvl(jtb.validation_end_date,nvl(trunc(p_sched_end_date),sysdate)) >= nvl(trunc(p_sched_end_date),sysdate);
892:

Line 1263: FROM jtf_task_statuses_b ts

1259:
1260: -- Fetch the Cancelled Flag corresponding to the new Task Status.
1261: CURSOR c_task_status_info IS
1262: SELECT NVL (ts.cancelled_flag, 'N') cancelled_flag
1263: FROM jtf_task_statuses_b ts
1264: WHERE ts.task_status_id = p_assignment_status_id;
1265:
1266: cursor c_tasks is
1267: select jta.assignment_status_id,jta.task_id,JTA.OBJECT_CAPACITY_ID

Line 1274: from jtf_task_statuses_b jtb

1270:
1271: CURSOR c_cross_task(p_sched_start_date date, p_sched_end_date date)
1272: IS
1273: select jtB.TASK_status_id,jtb.validation_start_date,jtb.validation_end_date
1274: from jtf_task_statuses_b jtb
1275: where jtb.enforce_validation_flag = 'Y'
1276: and nvl(jtb.validation_start_date,nvl(trunc(p_sched_start_date),sysdate)) <= nvl(trunc(p_sched_start_date),sysdate)
1277: and nvl(jtb.validation_end_date,nvl(trunc(p_sched_end_date),sysdate)) >= nvl(trunc(p_sched_end_date),sysdate);
1278:

Line 1523: select task_status_id from jtf_task_statuses_b

1519: where task_id = p_task;
1520:
1521: CURSOR c_working
1522: IS
1523: select task_status_id from jtf_task_statuses_b
1524: where assigned_flag = 'Y'
1525: and working_flag = 'Y'
1526: and seeded_flag = 'Y'
1527: and nvl(approved_flag,'N') = 'N'

Line 1533: select task_status_id from jtf_task_statuses_b

1529: and assignment_status_flag = 'Y';
1530:
1531: CURSOR c_travel
1532: IS
1533: select task_status_id from jtf_task_statuses_b
1534: where travel_flag = 'Y'
1535: and seeded_flag= 'Y';
1536:
1537: CURSOR c_task_geometry(p_task_id number) IS

Line 1813: from jtf_task_statuses_b jtb

1809: l_api_name constant varchar2(30) := 'CROSS_TASK_VALIDATION';
1810: CURSOR c_cross_task(p_sched_start_date date, p_sched_end_date date)
1811: IS
1812: select jtB.TASK_status_id,jtb.validation_start_date,jtb.validation_end_date
1813: from jtf_task_statuses_b jtb
1814: where jtb.enforce_validation_flag = 'Y'
1815: and nvl(jtb.validation_start_date,nvl(trunc(p_sched_start_date),sysdate)) <= nvl(trunc(p_sched_start_date),sysdate)
1816: and nvl(jtb.validation_end_date,nvl(trunc(p_sched_end_date),sysdate)) >= nvl(trunc(p_sched_end_date),sysdate);
1817: