APPS.CSM_CONTRACT_EVENT_PKG dependencies on CSM_CONTR_HEADERS_ACC

Line 6: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_CONTR_HEADERS_ACC';

2: /* $Header: csmectrb.pls 120.2.12010000.2 2009/09/03 05:03:28 trajasek ship $*/
3:
4: /*** Globals ***/
5: -- CSM_CONTR_HEADERS
6: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_CONTR_HEADERS_ACC';
7: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
8: CSM_ACC_PKG.t_publication_item_list('CSM_CONTR_HEADERS');
9: g_pk1_name1 CONSTANT VARCHAR2(30) := 'INCIDENT_ID';
10: g_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_CONTR_HEADERS_ACC_S';

Line 10: g_sequence_name1 CONSTANT VARCHAR2(30) := 'CSM_CONTR_HEADERS_ACC_S';

6: g_acc_table_name1 CONSTANT VARCHAR2(30) := 'CSM_CONTR_HEADERS_ACC';
7: g_publication_item_name1 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
8: CSM_ACC_PKG.t_publication_item_list('CSM_CONTR_HEADERS');
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 :=

Line 505: FROM csm_contr_headers_acc acc

501:
502: CURSOR l_access_id_csr(p_incident_id IN number, p_user_id IN number)
503: IS
504: SELECT acc.access_id, acc.counter
505: FROM csm_contr_headers_acc acc
506: WHERE incident_id = p_incident_id
507: AND user_id = p_user_id;
508:
509: r_csm_contract_line_details l_csm_contract_line_details%ROWTYPE;

Line 619: FROM CSM_CONTR_HEADERS_ACC

615: CURSOR l_contr_headers_csr(p_incidentid IN number,
616: p_userid IN number)
617: IS
618: SELECT incident_id, contract_service_id
619: FROM CSM_CONTR_HEADERS_ACC
620: WHERE user_id = p_user_id
621: AND incident_id = p_incidentid;
622:
623: CURSOR l_contr_buss_processes_csr(p_contractserviceid IN VARCHAR2,