DBA Data[Home] [Help]

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,