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
115: where application_id = l_app_id
116: and name = X_NAME;
117:
118: select application_id into l_child_app_id
127: end if;
128:
129: if X_CHILD_PERIODIC_SET_NAME is not null then
130: select periodic_set_id into l_child_per_id
131: from alr_periodic_sets
132: where application_id = l_child_app_id
133: and name = X_CHILD_PERIODIC_SET_NAME;
134: end if;
135: