eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AMS_REGISTRANTS_PUB dependencies on AMS_EVENT_REGISTRATIONS

Line 149: from ams_event_registrations

145: select event_registration_id,
146: object_version_number,
147: confirmation_code,
148: system_status_code
149: from ams_event_registrations
150: where REGISTRANT_PARTY_ID = p_reg_party_id
151: and REGISTRANT_CONTACT_ID = p_reg_contact_id
152: and ATTENDANT_PARTY_ID = p_att_party_id
153: and ATTENDANT_CONTACT_ID = p_att_contact_id

Line 165: from ams_event_registrations

161: REGISTRANT_CONTACT_ID,
162: ATTENDANT_PARTY_ID,
163: ATTENDANT_CONTACT_ID,
164: system_status_code
165: from ams_event_registrations
166: where confirmation_code = p_confirmation_code;
167:
168: Cursor c_find_status_id(l_system_status_code VARCHAR2) is
169: select user_status_id

Line 184: from ams_event_registrations

180:
181: -- soagrawa added the following 24-apr-2003 cursor for bug 2863012
182: Cursor c_get_reg_status(p_reg_id NUMBER ) IS
183: select system_status_code
184: from ams_event_registrations
185: where event_registration_id = p_reg_id;
186:
187: -- soagrawa 09-jun-2003 added to fix bug# 2997372
188: CURSOR c_party_Type (p_party_id NUMBER) IS