APPS.CS_CREATE_AUDIT_REC_PKG dependencies on CS_INCIDENTS_AUDIT_B

Line 163: FROM cs_incidents_audit_b b

159: SECURITY_GROUP_ID
160: FROM CS_INCIDENTS_ALL_B a
161: WHERE ROWID BETWEEN c_start_rowid AND c_end_rowid
162: AND NOT EXISTS (SELECT b.incident_id
163: FROM cs_incidents_audit_b b
164: WHERE a.incident_id = b.incident_id
165: AND (b.upgrade_flag_for_create = 'Y'
166: OR (b.OLD_INCIDENT_STATUS_ID IS NULL
167: AND b.INCIDENT_STATUS_ID IS NOT NULL

Line 305: FROM CS_INCIDENTS_AUDIT_B

301: PRIMARY_CONTACT_ID ,
302: CHANGE_PRIMARY_CONTACT_FLAG ,
303: OLD_PRIMARY_CONTACT_ID ,
304: SECURITY_GROUP_ID
305: FROM CS_INCIDENTS_AUDIT_B
306: WHERE INCIDENT_ID = c_incident_id
307: ORDER BY creation_date desc, incident_audit_id DESC;
308:
309: l_request_id NUMBER;

Line 379: FROM cs_incidents_audit_b

375:
376: l_request_id := l_create_audit_rec.incident_id;
377: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Service Request Id : '||l_request_id);
378: SELECT COUNT(incident_audit_id) INTO l_audit_count
379: FROM cs_incidents_audit_b
380: WHERE incident_id= l_request_id;
381:
382: IF l_audit_count >0 THEN
383: OPEN c_sr_audit(l_request_id);

Line 636: INSERT INTO cs_incidents_audit_b (

632: end if;
633:
634: SELECT cs_incidents_audit_s1.NEXTVAL INTO l_incident_audit_id FROM DUAL;
635:
636: INSERT INTO cs_incidents_audit_b (
637: INCIDENT_ID ,
638: INCIDENT_AUDIT_ID ,
639: LAST_UPDATE_DATE ,
640: LAST_UPDATED_BY ,