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 134: From CSM_PARTY_SITES_ACC ps

130: )
131: AND NOT EXISTS
132: (
133: SELECT 1
134: From CSM_PARTY_SITES_ACC ps
135: WHERE ps.USER_ID = p.USER_ID
136: AND ps.PARTY_ID= p.PARTY_ID
137: )
138: AND NOT EXISTS

Line 248: FROM csm_party_sites_acc

244:
245: CURSOR l_party_sites_csr (p_party_id hz_parties.party_id%TYPE)
246: IS
247: SELECT access_id, user_id
248: FROM csm_party_sites_acc
249: WHERE party_id = p_party_id;
250:
251: BEGIN
252: CSM_UTIL_PKG.LOG('Entering PARTY_ORG_UPD_WF_EVENT_SUB',

Line 316: From CSM_PARTY_SITES_ACC ps

312: )
313: AND NOT EXISTS
314: (
315: SELECT 1
316: From CSM_PARTY_SITES_ACC ps
317: WHERE ps.USER_ID=p.USER_ID
318: AND ps.PARTY_ID=p.PARTY_ID
319: )
320: AND NOT EXISTS