APPS.AS_LLOG_SUMMARY_PKG dependencies on AS_LAST_RUN_DATES

Line 124: from as_last_run_dates

120:
121:
122: CURSOR last_refresh_date IS
123: select PROGRAM_UPDATE_DATE
124: from as_last_run_dates
125: where PROGRAM_NAME = 'ASXRSSM';
126:
127: CURSOR from_date IS
128: select min(LAST_UPDATE_DATE)

Line 212: -- Update as_last_run_dates

208: from as_leads_log
209: where last_update_date >= l_last_refresh_date )
210: GROUP BY log.LEAD_ID, ld.DECISION_DATE, log.STATUS_CODE;
211:
212: -- Update as_last_run_dates
213: UPDATE AS_LAST_RUN_DATES
214: SET PROGRAM_UPDATE_DATE = l_this_refresh_date,
215: LAST_UPDATE_DATE = sysdate,
216: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,

Line 213: UPDATE AS_LAST_RUN_DATES

209: where last_update_date >= l_last_refresh_date )
210: GROUP BY log.LEAD_ID, ld.DECISION_DATE, log.STATUS_CODE;
211:
212: -- Update as_last_run_dates
213: UPDATE AS_LAST_RUN_DATES
214: SET PROGRAM_UPDATE_DATE = l_this_refresh_date,
215: LAST_UPDATE_DATE = sysdate,
216: LAST_UPDATED_BY = FND_GLOBAL.USER_ID,
217: LAST_UPDATE_LOGIN = FND_GLOBAL.CONC_LOGIN_ID,

Line 223: INSERT INTO AS_LAST_RUN_DATES

219: PROGRAM_APPLICATION_ID = FND_GLOBAL.Prog_Appl_Id,
220: PROGRAM_ID = FND_GLOBAL.Conc_Program_Id
221: WHERE PROGRAM_NAME = 'ASXRSSM';
222: IF (SQL%NOTFOUND) THEN
223: INSERT INTO AS_LAST_RUN_DATES
224: ( LAST_UPDATE_DATE,
225: LAST_UPDATED_BY,
226: CREATION_DATE,
227: CREATED_BY,