APPS.ALR_ACTIONS_PKG dependencies on FND_APPLICATION

Line 190: from FND_APPLICATION

186: -- Translate char last_update_date to date
187: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
188:
189: select APPLICATION_ID into l_app_id
190: from FND_APPLICATION
191: where APPLICATION_SHORT_NAME = X_APPLICATION_SHORT_NAME;
192:
193: select ALERT_ID into l_alert_id
194: from ALR_ALERTS

Line 200: from FND_APPLICATION

196: and ALERT_NAME = X_ALERT_NAME;
197:
198: if (X_PROGRAM_APPLICATION_NAME is not null) then
199: select APPLICATION_ID into l_program_application_id
200: from FND_APPLICATION
201: where APPLICATION_SHORT_NAME = X_PROGRAM_APPLICATION_NAME;
202: end if;
203:
204: if (X_CONCURRENT_PROGRAM_NAME is not null) then

Line 213: from FND_APPLICATION

209: end if;
210:
211: if (X_LIST_APPLICATION_NAME is not null) then
212: select APPLICATION_ID into l_list_app_id
213: from FND_APPLICATION
214: where APPLICATION_SHORT_NAME = X_LIST_APPLICATION_NAME;
215: end if;
216:
217: if (X_LIST_NAME is not null) then