APPS.AS_LLOG_SUMMARY_PKG dependencies on AS_LLOG_STATUS_SUMMARY
Line 162: DELETE FROM AS_LLOG_STATUS_SUMMARY
158: END IF;
159:
160: l_this_refresh_date := sysdate;
161: 162: DELETE FROM AS_LLOG_STATUS_SUMMARY 163: WHERE lead_id in
164: ( select lead_id
165: from as_leads_log
166: where last_update_date >= l_last_refresh_date );
Line 168: INSERT INTO AS_LLOG_STATUS_SUMMARY
164: ( select lead_id
165: from as_leads_log
166: where last_update_date >= l_last_refresh_date );
167: 168: INSERT INTO AS_LLOG_STATUS_SUMMARY 169: ( CREATION_DATE,
170: CREATED_BY,
171: LAST_UPDATE_DATE,
172: LAST_UPDATED_BY,