DBA Data[Home] [Help]

APPS.OKL_UWQ_SEL_PKG dependencies on AMS_EVENT_REGISTRATIONS_V

Line 219: FROM ams_event_registrations_v

215: -- procedure get details from event confirmation number
216: PROCEDURE getDtlsFromEvent IS
217: CURSOR C_GetEventDetails(x_eventConfCode VARCHAR2) IS
218: SELECT registrant_party_Id,registrant_contact_Id,event_offer_Id
219: FROM ams_event_registrations_v
220: WHERE confirmation_code = x_eventConfCode;
221: BEGIN
222: OPEN C_GetEventDetails(l_eventConfCode);
223: FETCH C_GetEventDetails INTO l_partyId, l_contactId, l_eventId;