APPS.CSL_PARTY_CONTACTS_ACC_PKG dependencies on CSL_CS_HZ_SR_CONTACT_PTS_ACC

Line 245: FROM CSL_CS_HZ_SR_CONTACT_PTS_ACC CCA

241: FROM CS_HZ_SR_CONTACT_POINTS CHS
242: WHERE CHS.INCIDENT_ID = b_incident_id
243: AND CHS.SR_CONTACT_POINT_ID NOT IN (
244: SELECT CCA.SR_CONTACT_POINT_ID
245: FROM CSL_CS_HZ_SR_CONTACT_PTS_ACC CCA
246: WHERE CCA.RESOURCE_ID = b_resource_id
247: );
248:
249: CURSOR c_obsolete_contacts( b_incident_id NUMBER

Line 253: FROM CSL_CS_HZ_SR_CONTACT_PTS_ACC CCA

249: CURSOR c_obsolete_contacts( b_incident_id NUMBER
250: , b_resource_id NUMBER)
251: IS
252: SELECT CCA.*
253: FROM CSL_CS_HZ_SR_CONTACT_PTS_ACC CCA
254: WHERE CCA.RESOURCE_ID = b_resource_id
255: AND CCA.SR_CONTACT_POINT_ID NOT IN (
256: SELECT CHS.SR_CONTACT_POINT_ID
257: FROM CS_HZ_SR_CONTACT_POINTS CHS

Line 263: l_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_CS_HZ_SR_CONTACT_PTS_ACC';

259: );
260:
261: /*Each procedure has its own set of constants*/
262: l_table_name CONSTANT VARCHAR2(30) := 'CS_HZ_SR_CONTACT_POINTS';
263: l_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_CS_HZ_SR_CONTACT_PTS_ACC';
264: l_pk1_name CONSTANT VARCHAR2(30) := 'SR_CONTACT_POINT_ID';
265: l_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
266: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CS_HZ_SR_CONTACT_PTS');
267: BEGIN

Line 408: l_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_CS_HZ_SR_CONTACT_PTS_ACC';

404: , p_resource_id IN NUMBER
405: , p_flow_type IN NUMBER ) --DEFAULT CSL_CS_INCIDENTS_ALL_ACC_PKG.G_FLOW_NORMAL)
406: IS
407: l_table_name CONSTANT VARCHAR2(30) := 'CS_HZ_SR_CONTACT_POINTS';
408: l_acc_table_name CONSTANT VARCHAR2(30) := 'CSL_CS_HZ_SR_CONTACT_PTS_ACC';
409: l_pk1_name CONSTANT VARCHAR2(30) := 'SR_CONTACT_POINT_ID';
410: l_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
411: JTM_HOOK_UTIL_PKG.t_publication_item_list('CSL_CS_HZ_SR_CONTACT_PTS');
412:

Line 421: FROM CSL_CS_HZ_SR_CONTACT_PTS_ACC CCA

417: FROM CS_HZ_SR_CONTACT_POINTS CHS
418: WHERE CHS.INCIDENT_ID = b_incident_id
419: AND CHS.SR_CONTACT_POINT_ID IN (
420: SELECT CCA.SR_CONTACT_POINT_ID
421: FROM CSL_CS_HZ_SR_CONTACT_PTS_ACC CCA
422: WHERE CCA.RESOURCE_ID = b_resource_id
423: );
424:
425: BEGIN