APPS.CSM_TASK_ASSIGNMENT_EVENT_PKG dependencies on CSM_TASK_ASSIGNMENTS_ACC

Line 5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_TASK_ASSIGNMENTS_ACC';

1: PACKAGE BODY CSM_TASK_ASSIGNMENT_EVENT_PKG AS
2: /* $Header: csmetab.pls 120.8.12020000.2 2013/04/09 11:00:02 saradhak ship $ */
3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_TASK_ASSIGNMENTS_ACC';
6: g_table_name CONSTANT VARCHAR2(30) := 'JTF_TASK_ASSIGNMENTS';
7: g_acc_seq_name CONSTANT VARCHAR2(30) := 'CSM_TASK_ASSIGNMENTS_ACC_S' ;
8: g_pk1_name CONSTANT VARCHAR2(30) := 'TASK_ASSIGNMENT_ID';
9: g_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=

Line 7: g_acc_seq_name CONSTANT VARCHAR2(30) := 'CSM_TASK_ASSIGNMENTS_ACC_S' ;

3:
4: /*** Globals ***/
5: g_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_TASK_ASSIGNMENTS_ACC';
6: g_table_name CONSTANT VARCHAR2(30) := 'JTF_TASK_ASSIGNMENTS';
7: g_acc_seq_name CONSTANT VARCHAR2(30) := 'CSM_TASK_ASSIGNMENTS_ACC_S' ;
8: g_pk1_name CONSTANT VARCHAR2(30) := 'TASK_ASSIGNMENT_ID';
9: g_pubi_name CONSTANT CSM_ACC_PKG.t_publication_item_list :=
10: CSM_ACC_PKG.t_publication_item_list('CSM_TASK_ASSIGNMENTS');
11:

Line 33: SELECT /*+ INDEX (acc CSM_TASK_ASSIGNMENTS_ACC_U1)*/

29: l_return_status VARCHAR2(2000);
30:
31: CURSOR l_purge_task_assignments_csr
32: IS
33: SELECT /*+ INDEX (acc CSM_TASK_ASSIGNMENTS_ACC_U1)*/
34: acc.task_assignment_id,
35: jt.task_id,
36: jt.source_object_type_code
37: FROM csm_task_assignments_acc acc,

Line 37: FROM csm_task_assignments_acc acc,

33: SELECT /*+ INDEX (acc CSM_TASK_ASSIGNMENTS_ACC_U1)*/
34: acc.task_assignment_id,
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

Line 951: SELECT /*+ INDEX (acc CSM_TASK_ASSIGNMENTS_ACC_U1)*/ au.user_id,

947:
948: CURSOR l_task_assg_purge_csr(p_task_assignment_id jtf_task_assignments.task_assignment_id%TYPE)
949: IS
950: --Bug 5220635
951: SELECT /*+ INDEX (acc CSM_TASK_ASSIGNMENTS_ACC_U1)*/ au.user_id,
952: au.resource_id,
953: jt.task_id,
954: csi.incident_id,
955: csi.customer_id,

Line 967: FROM csm_task_assignments_acc acc,

963: jt.source_object_type_code,
964: csi.incident_location_type,
965: jt.ADDRESS_ID,
966: csi.org_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,

Line 985: SELECT /*+ INDEX (acc CSM_TASK_ASSIGNMENTS_ACC_U1)*/ au.user_id,

981: AND jt.source_object_id = csi.INCIDENT_ID
982: AND hz_ps.party_site_id = NVL(csi.incident_location_id, jt.ADDRESS_ID)
983: AND NVL(csi.incident_location_type,'HZ_PARTY_SITE')='HZ_PARTY_SITE'
984: UNION
985: SELECT /*+ INDEX (acc CSM_TASK_ASSIGNMENTS_ACC_U1)*/ au.user_id,
986: au.resource_id,
987: jt.task_id,
988: csi.incident_id,
989: csi.customer_id,

Line 1001: FROM csm_task_assignments_acc acc,

997: jt.source_object_type_code,
998: csi.incident_location_type,
999: jt.ADDRESS_ID,
1000: csi.org_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,

Line 1019: SELECT /*+ INDEX (acc CSM_TASK_ASSIGNMENTS_ACC_U1)*/ au.user_id,

1015: AND jt.source_object_id = csi.INCIDENT_ID
1016: AND lc.location_id = NVL(jt.LOCATION_ID,csi.incident_location_id)
1017: AND csi.incident_location_type='HZ_LOCATION'
1018: UNION
1019: SELECT /*+ INDEX (acc CSM_TASK_ASSIGNMENTS_ACC_U1)*/ au.user_id,
1020: au.resource_id,
1021: jt.task_id,
1022: TO_NUMBER(NULL),
1023: TO_NUMBER(NULL),

Line 1035: FROM csm_task_assignments_acc acc,

1031: jt.source_object_type_code,
1032: TO_CHAR(NULL),
1033: jt.ADDRESS_ID,
1034: TO_NUMBER(NULL)
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