APPS.CSM_PARTY_EVENT_PKG dependencies on CSM_PARTY_SITES_ACC

Line 14: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_PARTY_SITES_ACC';

10:
11: g_pub_item CONSTANT varchar(30) := 'CSF_M_PARTIES';
12:
13: g_table_name2 CONSTANT VARCHAR2(30) := 'HZ_PARTY_SITES';
14: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_PARTY_SITES_ACC';
15: g_acc_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_PARTY_SITES_ACC_S';
16: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
17: CSM_ACC_PKG.t_publication_item_list('CSF_M_PARTY_SITES');
18: g_pk1_name2 CONSTANT VARCHAR2(30) := 'PARTY_SITE_ID';

Line 15: g_acc_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_PARTY_SITES_ACC_S';

11: g_pub_item CONSTANT varchar(30) := 'CSF_M_PARTIES';
12:
13: g_table_name2 CONSTANT VARCHAR2(30) := 'HZ_PARTY_SITES';
14: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'CSM_PARTY_SITES_ACC';
15: g_acc_sequence_name2 CONSTANT VARCHAR2(30) := 'CSM_PARTY_SITES_ACC_S';
16: g_publication_item_name2 CONSTANT CSM_ACC_PKG.t_publication_item_list :=
17: CSM_ACC_PKG.t_publication_item_list('CSF_M_PARTY_SITES');
18: g_pk1_name2 CONSTANT VARCHAR2(30) := 'PARTY_SITE_ID';
19: g_pk2_name2 CONSTANT VARCHAR2(30) := 'PARTY_ID';

Line 203: FROM csm_party_sites_acc

199:
200: CURSOR l_party_sites_csr (p_party_id hz_parties.party_id%TYPE)
201: IS
202: SELECT access_id, user_id
203: FROM csm_party_sites_acc
204: WHERE party_id = p_party_id;
205:
206: BEGIN
207: CSM_UTIL_PKG.LOG('Entering PARTY_ORG_UPD_WF_EVENT_SUB',