APPS.ALR_ALERTS_PKG dependencies on FND_APPLICATION

Line 175: from FND_APPLICATION

171: -- Translate char last_update_date to date
172: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
173:
174: select APPLICATION_ID into l_app_id
175: from FND_APPLICATION
176: where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME;
177:
178: if (X_TABLE_APPLICATION_SHORT_NAME is not null) then
179: select APPLICATION_ID into l_table_app_id

Line 180: from FND_APPLICATION

176: where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME;
177:
178: if (X_TABLE_APPLICATION_SHORT_NAME is not null) then
179: select APPLICATION_ID into l_table_app_id
180: from FND_APPLICATION
181: where APPLICATION_SHORT_NAME = X_TABLE_APPLICATION_SHORT_NAME;
182: end if;
183:
184: if ((X_TABLE_APPLICATION_SHORT_NAME is not null)