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_EVTREGS_PVT dependencies on DUAL

Line 144: FROM DUAL;

140: where event_offer_id = p_event_offer_id;
141:
142: CURSOR c_evt_regs_seq IS
143: SELECT ams_event_registrations_s.NEXTVAL
144: FROM DUAL;
145:
146: -- added by soagrawa on 24-oct-2002 for uniqueness sake
147: -- needed so as to not conflict with ids generated in migration
148: CURSOR c_id_exists (l_id IN NUMBER) IS

Line 150: FROM dual

146: -- added by soagrawa on 24-oct-2002 for uniqueness sake
147: -- needed so as to not conflict with ids generated in migration
148: CURSOR c_id_exists (l_id IN NUMBER) IS
149: SELECT 1
150: FROM dual
151: WHERE EXISTS (SELECT 1
152: -- FROM AMS_event_offers_all_B Modified by ptendulk on 12-Feb-2002
153: -- WHERE event_offer_id = l_id);
154: FROM ams_event_registrations

Line 159: FROM dual;

155: WHERE event_registration_id = l_id);
156:
157: CURSOR c_evt_reg_conf_seq IS
158: SELECT ams_event_reg_confirmation_s.nextval
159: FROM dual;
160:
161: CURSOR c_evt_reg_waitlist_seq IS
162: SELECT ams_reg_waitlist_priority_s.nextval
163: FROM dual;

Line 163: FROM dual;

159: FROM dual;
160:
161: CURSOR c_evt_reg_waitlist_seq IS
162: SELECT ams_reg_waitlist_priority_s.nextval
163: FROM dual;
164:
165: CURSOR c_evt_reg_status IS
166: SELECT user_status_id
167: FROM ams_user_statuses_b

Line 2166: from dual;

2162: l_cancel_reg_conf_data cancel_reg_conf_details%ROWTYPE;
2163:
2164: CURSOR c_evtregs_cancel_seq IS
2165: select ams_event_reg_cancellation_s.nextval
2166: from dual;
2167:
2168: Cursor cur_user_stat_id is
2169: select USER_STATUS_ID
2170: from AMS_USER_STATUSES_VL

Line 4202: SELECT 1 FROM DUAL

4198: IS
4199:
4200: l_dummy NUMBER;
4201: cursor c_conf_code(conf_code_in IN VARCHAR2) IS
4202: SELECT 1 FROM DUAL
4203: WHERE EXISTS (select 1
4204: from ams_event_registrations
4205: where confirmation_code = conf_code_in
4206: );

Line 5241: FROM dual;

5237: WHERE event_offer_id = p_event_offer_id;
5238:
5239: CURSOR c_media_item_id IS
5240: SELECT JTF_IH_MEDIA_ITEMS_S1.NEXTVAL
5241: FROM dual;
5242:
5243: CURSOR c_interactions_id IS
5244: SELECT jtf_ih_interactions_s1.NEXTVAL
5245: FROM dual;

Line 5245: FROM dual;

5241: FROM dual;
5242:
5243: CURSOR c_interactions_id IS
5244: SELECT jtf_ih_interactions_s1.NEXTVAL
5245: FROM dual;
5246:
5247: CURSOR c_activities_id IS
5248: SELECT JTF_IH_ACTIVITIES_S1.NEXTVAL
5249: FROM dual;

Line 5249: FROM dual;

5245: FROM dual;
5246:
5247: CURSOR c_activities_id IS
5248: SELECT JTF_IH_ACTIVITIES_S1.NEXTVAL
5249: FROM dual;
5250:
5251: CURSOR c_user(p_resource_id IN NUMBER) IS
5252: SELECT user_id
5253: FROM ams_jtf_rs_emp_v