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 2006/09/15 13:00:29 trajasek noship $ */
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 909: SELECT /*+ INDEX (acc CSM_TASK_ASSIGNMENTS_ACC_U1)*/ au.user_id,

905:
906: CURSOR l_task_assg_purge_csr(p_task_assignment_id jtf_task_assignments.task_assignment_id%TYPE)
907: IS
908: --Bug 5220635
909: SELECT /*+ INDEX (acc CSM_TASK_ASSIGNMENTS_ACC_U1)*/ au.user_id,
910: au.resource_id,
911: jt.task_id,
912: csi.incident_id,
913: csi.customer_id,

Line 923: FROM csm_task_assignments_acc acc,

919: csi.customer_product_id,
920: hz_ps.location_id,
921: jt.source_object_type_code,
922: csi.incident_location_type
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,

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

937: AND jt.source_object_id = csi.INCIDENT_ID
938: AND hz_ps.party_site_id = NVL(csi.incident_location_id, jt.ADDRESS_ID)
939: AND NVL(csi.incident_location_type,'HZ_PARTY_SITE')='HZ_PARTY_SITE'
940: UNION
941: SELECT /*+ INDEX (acc CSM_TASK_ASSIGNMENTS_ACC_U1)*/ au.user_id,
942: au.resource_id,
943: jt.task_id,
944: csi.incident_id,
945: csi.customer_id,

Line 955: FROM csm_task_assignments_acc acc,

951: csi.customer_product_id,
952: lc.location_id,
953: jt.source_object_type_code,
954: csi.incident_location_type
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,

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

969: AND jt.source_object_id = csi.INCIDENT_ID
970: AND lc.location_id = NVL(jt.LOCATION_ID,csi.incident_location_id)
971: AND csi.incident_location_type='HZ_LOCATION'
972: UNION
973: SELECT /*+ INDEX (acc CSM_TASK_ASSIGNMENTS_ACC_U1)*/ au.user_id,
974: au.resource_id,
975: jt.task_id,
976: TO_NUMBER(NULL),
977: TO_NUMBER(NULL),

Line 987: FROM csm_task_assignments_acc acc,

983: TO_NUMBER(NULL),
984: TO_NUMBER(NULL),
985: jt.source_object_type_code,
986: TO_CHAR(NULL)
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