APPS.CSM_CONTRACT_EVENT_PKG dependencies on CSM_CONTR_BUSS_PROCESSES_ACC

Line 13: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_CONTR_BUSS_PROCESSES_ACC';

9: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INCIDENT_ID';
10: g_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_CONTR_HEADERS_ACC_S';
11:
12: -- CSM_CONTR_BUSS_PROCESSES
13: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_CONTR_BUSS_PROCESSES_ACC';
14: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
15: CSM_ACC_PKG.t_publication_item_list('CSM_CONTR_BUSS_PROCESSES');
16: g_pk1_name2 CONSTANT VARCHAR2(30) := 'CONTRACT_SERVICE_ID';
17: g_pk2_name2 CONSTANT VARCHAR2(30) := 'BUSINESS_PROCESS_ID';

Line 18: g_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_CONTR_BUSS_PROCESSES_ACC_S';

14: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
15: CSM_ACC_PKG.t_publication_item_list('CSM_CONTR_BUSS_PROCESSES');
16: g_pk1_name2 CONSTANT VARCHAR2(30) := 'CONTRACT_SERVICE_ID';
17: g_pk2_name2 CONSTANT VARCHAR2(30) := 'BUSINESS_PROCESS_ID';
18: g_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_CONTR_BUSS_PROCESSES_ACC_S';
19:
20: -- CSM_CONTR_BUSS_TXN_TYPES
21: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSM_CONTR_BUSS_TXN_TYPES_ACC';
22: g_publication_item_name3 CONSTANT CSM_ACC_PKG.t_publication_item_list :=

Line 184: FROM csm_contr_buss_processes_acc acc

180: IS
181: CURSOR l_access_id_csr(p_contract_service_id IN VARCHAR2, p_business_process_id in number, p_user_id IN number)
182: IS
183: SELECT acc.access_id, acc.counter
184: FROM csm_contr_buss_processes_acc acc
185: WHERE user_id = p_user_id
186: AND contract_service_id = p_contract_service_id
187: AND business_process_id = p_business_process_id;
188:

Line 468: FROM CSM_CONTR_BUSS_PROCESSES_ACC

464: CURSOR l_contr_buss_processes_csr(p_contractserviceid IN VARCHAR2,
465: p_userid IN number)
466: IS
467: SELECT contract_service_id, business_process_id
468: FROM CSM_CONTR_BUSS_PROCESSES_ACC
469: WHERE user_id = p_userid
470: AND contract_service_id = p_contractserviceid;
471:
472: CURSOR l_contr_buss_txn_types_csr(p_contractserviceid IN varchar2,