APPS.CSM_CONTRACT_EVENT_PKG dependencies on CSM_CONTR_BUSS_TXN_TYPES_ACC

Line 21: g_acc_table_name3 CONSTANT VARCHAR2(30) := 'CSM_CONTR_BUSS_TXN_TYPES_ACC';

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 :=
23: CSM_ACC_PKG.t_publication_item_list('CSM_CONTR_BUSS_TXN_TYPES');
24: g_pk1_name3 CONSTANT VARCHAR2(30) := 'CONTRACT_SERVICE_ID';
25: g_pk2_name3 CONSTANT VARCHAR2(30) := 'BUSINESS_PROCESS_ID';

Line 27: g_sequence_name3 CONSTANT VARCHAR2(30) := 'CSM_CONTR_BUSS_TXN_TYPES_ACC_S';

23: CSM_ACC_PKG.t_publication_item_list('CSM_CONTR_BUSS_TXN_TYPES');
24: g_pk1_name3 CONSTANT VARCHAR2(30) := 'CONTRACT_SERVICE_ID';
25: g_pk2_name3 CONSTANT VARCHAR2(30) := 'BUSINESS_PROCESS_ID';
26: g_pk3_name3 CONSTANT VARCHAR2(30) := 'TXN_BILLING_TYPE_ID';
27: g_sequence_name3 CONSTANT VARCHAR2(30) := 'CSM_CONTR_BUSS_TXN_TYPES_ACC_S';
28:
29: -- CSF_M_NOTES
30: g_notes_acc_table_name CONSTANT VARCHAR2(30) := 'CSM_NOTES_ACC';
31: g_notes_table_name CONSTANT VARCHAR2(30) := 'JTF_NOTES_B';

Line 53: FROM csm_contr_buss_txn_types_acc acc

49: CURSOR l_access_id_csr(p_contract_service_id IN VARCHAR2, p_business_process_id in number,
50: p_txn_billing_type_id in number, p_user_id IN number)
51: IS
52: SELECT acc.access_id, acc.counter
53: FROM csm_contr_buss_txn_types_acc acc
54: WHERE user_id = p_user_id
55: AND contract_service_id = p_contract_service_id
56: AND business_process_id = p_business_process_id
57: AND txn_billing_type_id = p_txn_billing_type_id;

Line 477: FROM csm_contr_buss_txn_types_acc

473: p_businessprocessid IN number,
474: p_userid IN number)
475: IS
476: SELECT contract_service_id, business_process_id, txn_billing_type_id
477: FROM csm_contr_buss_txn_types_acc
478: WHERE user_id = p_userid
479: AND contract_service_id = p_contractserviceid
480: AND business_process_id = p_businessprocessid;
481: