APPS.ALR_PERIODIC_SET_MEMBERS_PKG dependencies on FND_APPLICATION

Line 110: from fnd_application

106: -- Translate char last_update_date to date
107: f_ludate := nvl(to_date(x_last_update_date, 'YYYY/MM/DD'), sysdate);
108:
109: select application_id into l_app_id
110: from fnd_application
111: where application_short_name = X_APPLICATION_SHORT_NAME;
112:
113: select periodic_set_id into l_per_id
114: from alr_periodic_sets

Line 119: from fnd_application

115: where application_id = l_app_id
116: and name = X_NAME;
117:
118: select application_id into l_child_app_id
119: from fnd_application
120: where application_short_name = X_CHILD_APPLICATION_SHORT_NAME;
121:
122: if X_CHILD_ALERT_NAME is not null then
123: select alert_id into l_child_alert_id