[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;
475: csi.incident_location_type
476: FROM JTF_TASK_ASSIGNMENTS jta,
477: asg_user au,
478: asg_user_pub_resps aupr,
479: jtf_tasks_b jt,
480: cs_incidents_all_b csi,
481: hz_party_sites hz_ps
482: WHERE jta.task_assignment_id = p_taskassgid
483: AND jta.assignee_role = 'ASSIGNEE'
506: csi.incident_location_type
507: FROM JTF_TASK_ASSIGNMENTS jta,
508: asg_user au,
509: asg_user_pub_resps aupr,
510: jtf_tasks_b jt,
511: cs_incidents_all_b csi,
512: hz_locations lc
513: WHERE jta.task_assignment_id = p_taskassgid
514: AND jta.assignee_role = 'ASSIGNEE'
537: to_char(NULL)
538: FROM JTF_TASK_ASSIGNMENTS jta,
539: asg_user au,
540: asg_user_pub_resps aupr,
541: jtf_tasks_b jt
542: WHERE jta.task_assignment_id = p_taskassgid
543: AND jta.assignee_role = 'ASSIGNEE'
544: AND au.resource_id = jta.resource_id
545: AND au.user_name = aupr.user_name
750: hz_ps.location_id,
751: jt.source_object_type_code,
752: csi.incident_location_type
753: FROM JTF_TASK_ASSIGNMENTS jta,
754: jtf_tasks_b jt,
755: cs_incidents_all_b csi,
756: hz_party_sites hz_ps
757: WHERE jta.task_assignment_id = p_taskassgid
758: AND jt.task_id = jta.task_id
775: lc.location_id,
776: jt.source_object_type_code,
777: csi.incident_location_type
778: FROM JTF_TASK_ASSIGNMENTS jta,
779: jtf_tasks_b jt,
780: cs_incidents_all_b csi,
781: hz_locations lc
782: WHERE jta.task_assignment_id = p_taskassgid
783: AND jt.task_id = jta.task_id
923: FROM csm_task_assignments_acc acc,
924: jtf_task_assignments jta,
925: asg_user au,
926: asg_user_pub_resps aupr,
927: jtf_tasks_b jt,
928: cs_incidents_all_b csi,
929: hz_party_sites hz_ps
930: WHERE acc.task_assignment_id = p_task_assignment_id
931: AND acc.task_assignment_id = jta.task_assignment_id
955: FROM csm_task_assignments_acc acc,
956: jtf_task_assignments jta,
957: asg_user au,
958: asg_user_pub_resps aupr,
959: jtf_tasks_b jt,
960: cs_incidents_all_b csi,
961: hz_locations lc
962: WHERE acc.task_assignment_id = p_task_assignment_id
963: AND acc.task_assignment_id = jta.task_assignment_id
987: FROM csm_task_assignments_acc acc,
988: JTF_TASK_ASSIGNMENTS jta,
989: asg_user au,
990: asg_user_pub_resps aupr,
991: jtf_tasks_b jt
992: WHERE acc.task_assignment_id = p_task_assignment_id
993: AND acc.task_assignment_id = jta.task_assignment_id
994: AND acc.user_id = au.user_id
995: AND au.user_name = aupr.user_name
1461: hz_ps.location_id,
1462: jt.source_object_type_code,
1463: csi.incident_location_type
1464: FROM JTF_TASK_ASSIGNMENTS jta,
1465: jtf_tasks_b jt,
1466: cs_incidents_all_b csi,
1467: hz_party_sites hz_ps
1468: WHERE jta.task_assignment_id = p_task_assignment_id
1469: AND jt.task_id = jta.task_id
1486: lc.location_id,
1487: jt.source_object_type_code,
1488: csi.incident_location_type
1489: FROM JTF_TASK_ASSIGNMENTS jta,
1490: jtf_tasks_b jt,
1491: cs_incidents_all_b csi,
1492: hz_locations lc
1493: WHERE jta.task_assignment_id = p_task_assignment_id
1494: AND jt.task_id = jta.task_id