[Home] [Help]
35: jt.task_id,
36: jt.source_object_type_code
37: FROM csm_task_assignments_acc acc,
38: jtf_task_assignments jta,
39: jtf_tasks_b jt,
40: jtf_task_statuses_b jts,
41: jtf_task_statuses_b jts_jta
42: WHERE acc.task_assignment_id = jta.task_assignment_id
43: AND jt.task_id = jta.task_id
60: AND cia.INCIDENT_STATUS_ID = ists.INCIDENT_STATUS_ID
61: AND NVL(ists.CLOSE_FLAG, 'N') <> 'Y');
62:
63: TYPE l_purge_task_tbl_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
64: TYPE l_task_src_type_tbl_type IS TABLE OF jtf_tasks_b.source_object_type_code%TYPE INDEX BY BINARY_INTEGER;
65:
66: l_purge_task_assignment_tbl l_purge_task_tbl_type;
67: l_task_src_type_tbl l_task_src_type_tbl_type;
68: l_purge_task_tbl l_purge_task_tbl_type;
480: csi.org_id
481: FROM JTF_TASK_ASSIGNMENTS jta,
482: asg_user au,
483: asg_user_pub_resps aupr,
484: jtf_tasks_b jt,
485: cs_incidents_all_b csi,
486: hz_party_sites hz_ps
487: WHERE jta.task_assignment_id = p_taskassgid
488: AND jta.assignee_role = 'ASSIGNEE'
513: csi.org_id
514: FROM JTF_TASK_ASSIGNMENTS jta,
515: asg_user au,
516: asg_user_pub_resps aupr,
517: jtf_tasks_b jt,
518: cs_incidents_all_b csi,
519: hz_locations lc
520: WHERE jta.task_assignment_id = p_taskassgid
521: AND jta.assignee_role = 'ASSIGNEE'
546: to_number(NULL)
547: FROM JTF_TASK_ASSIGNMENTS jta,
548: asg_user au,
549: asg_user_pub_resps aupr,
550: jtf_tasks_b jt
551: WHERE jta.task_assignment_id = p_taskassgid
552: AND jta.assignee_role = 'ASSIGNEE'
553: AND au.resource_id = jta.resource_id
554: AND au.user_name = aupr.user_name
792: hz_ps.location_id,
793: jt.source_object_type_code,
794: csi.incident_location_type
795: FROM JTF_TASK_ASSIGNMENTS jta,
796: jtf_tasks_b jt,
797: cs_incidents_all_b csi,
798: hz_party_sites hz_ps
799: WHERE jta.task_assignment_id = p_taskassgid
800: AND jt.task_id = jta.task_id
817: lc.location_id,
818: jt.source_object_type_code,
819: csi.incident_location_type
820: FROM JTF_TASK_ASSIGNMENTS jta,
821: jtf_tasks_b jt,
822: cs_incidents_all_b csi,
823: hz_locations lc
824: WHERE jta.task_assignment_id = p_taskassgid
825: AND jt.task_id = jta.task_id
967: FROM csm_task_assignments_acc acc,
968: jtf_task_assignments jta,
969: asg_user au,
970: asg_user_pub_resps aupr,
971: jtf_tasks_b jt,
972: cs_incidents_all_b csi,
973: hz_party_sites hz_ps
974: WHERE acc.task_assignment_id = p_task_assignment_id
975: AND acc.task_assignment_id = jta.task_assignment_id
1001: FROM csm_task_assignments_acc acc,
1002: jtf_task_assignments jta,
1003: asg_user au,
1004: asg_user_pub_resps aupr,
1005: jtf_tasks_b jt,
1006: cs_incidents_all_b csi,
1007: hz_locations lc
1008: WHERE acc.task_assignment_id = p_task_assignment_id
1009: AND acc.task_assignment_id = jta.task_assignment_id
1035: FROM csm_task_assignments_acc acc,
1036: JTF_TASK_ASSIGNMENTS jta,
1037: asg_user au,
1038: asg_user_pub_resps aupr,
1039: jtf_tasks_b jt
1040: WHERE acc.task_assignment_id = p_task_assignment_id
1041: AND acc.task_assignment_id = jta.task_assignment_id
1042: AND acc.user_id = au.user_id
1043: AND au.user_name = aupr.user_name
1533: hz_ps.location_id,
1534: jt.source_object_type_code,
1535: csi.incident_location_type
1536: FROM JTF_TASK_ASSIGNMENTS jta,
1537: jtf_tasks_b jt,
1538: cs_incidents_all_b csi,
1539: hz_party_sites hz_ps
1540: WHERE jta.task_assignment_id = p_task_assignment_id
1541: AND jt.task_id = jta.task_id
1558: lc.location_id,
1559: jt.source_object_type_code,
1560: csi.incident_location_type
1561: FROM JTF_TASK_ASSIGNMENTS jta,
1562: jtf_tasks_b jt,
1563: cs_incidents_all_b csi,
1564: hz_locations lc
1565: WHERE jta.task_assignment_id = p_task_assignment_id
1566: AND jt.task_id = jta.task_id