APPS.CSM_SYSTEM_ITEM_EVENT_PKG dependencies on CSM_ITEM_INSTANCES_ACC

Line 24: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC';

20: g_pk2_name1 CONSTANT VARCHAR2(30) := 'ORGANIZATION_ID';
21: g_pub_item CONSTANT VARCHAR2(30) := 'CSF_M_SYSTEM_ITEMS';
22:
23: g_table_name2 CONSTANT VARCHAR2(30) := 'CSI_ITEM_INSTANCES';
24: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC';
25: g_acc_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC_S';
26: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
27: CSM_ACC_PKG.t_publication_item_list('CSF_M_ITEM_INSTANCES');
28: g_pk1_name2 CONSTANT VARCHAR2(30) := 'INSTANCE_ID';

Line 25: g_acc_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC_S';

21: g_pub_item CONSTANT VARCHAR2(30) := 'CSF_M_SYSTEM_ITEMS';
22:
23: g_table_name2 CONSTANT VARCHAR2(30) := 'CSI_ITEM_INSTANCES';
24: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC';
25: g_acc_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_ITEM_INSTANCES_ACC_S';
26: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
27: CSM_ACC_PKG.t_publication_item_list('CSF_M_ITEM_INSTANCES');
28: g_pk1_name2 CONSTANT VARCHAR2(30) := 'INSTANCE_ID';
29: g_pub_item2 CONSTANT VARCHAR2(30) := 'CSF_M_ITEM_INSTANCES';

Line 1474: FROM csm_item_instances_acc cia

1470: AND NVL(iis.terminated_flag,'N') = 'N'
1471: AND asg.user_id = asg.owner_id AND asg.user_id = cqa.user_id AND asg.ENABLED = 'Y'
1472: AND NOT EXISTS
1473: ( SELECT 1
1474: FROM csm_item_instances_acc cia
1475: WHERE cia.user_id = cqa.user_id
1476: AND cia.instance_id = cii.instance_id
1477: );
1478: