DBA Data[Home] [Help]

APPS.ALR_PERIODIC_SET_MEMBERS_PKG dependencies on ALR_PERIODIC_SETS

Line 114: from alr_periodic_sets

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

Line 131: from alr_periodic_sets

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: