APPS.BIM_POPDATES_PKG dependencies on AMS_EVENT_REGISTRATIONS
Line 64: FROM ams_event_registrations A,
60: and b.active_from_date>p_date
61: and b.system_status_code in ('ACTIVE', 'CANCELLED', 'COMPLETED','CLOSED')
62: union all
63: SELECT min(a.last_reg_status_date) de 64: FROM ams_event_registrations A, 65: ams_event_headers_all_b b,
66: ams_event_offers_all_b c
67: where b.active_from_date>p_date
68: and b.system_status_code in ('ACTIVE', 'CANCELLED', 'COMPLETED')