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 2181: from dual;

2177: l_cancel_reg_conf_data cancel_reg_conf_details%ROWTYPE;
2178:
2179: CURSOR c_evtregs_cancel_seq IS
2180: select ams_event_reg_cancellation_s.nextval
2181: from dual;
2182:
2183: Cursor cur_user_stat_id is
2184: select USER_STATUS_ID
2185: from AMS_USER_STATUSES_VL

Line 4217: SELECT 1 FROM DUAL

4213: IS
4214:
4215: l_dummy NUMBER;
4216: cursor c_conf_code(conf_code_in IN VARCHAR2) IS
4217: SELECT 1 FROM DUAL
4218: WHERE EXISTS (select 1
4219: from ams_event_registrations
4220: where confirmation_code = conf_code_in
4221: );

Line 5256: FROM dual;

5252: WHERE event_offer_id = p_event_offer_id;
5253:
5254: CURSOR c_media_item_id IS
5255: SELECT JTF_IH_MEDIA_ITEMS_S1.NEXTVAL
5256: FROM dual;
5257:
5258: CURSOR c_interactions_id IS
5259: SELECT jtf_ih_interactions_s1.NEXTVAL
5260: FROM dual;

Line 5260: FROM dual;

5256: FROM dual;
5257:
5258: CURSOR c_interactions_id IS
5259: SELECT jtf_ih_interactions_s1.NEXTVAL
5260: FROM dual;
5261:
5262: CURSOR c_activities_id IS
5263: SELECT JTF_IH_ACTIVITIES_S1.NEXTVAL
5264: FROM dual;

Line 5264: FROM dual;

5260: FROM dual;
5261:
5262: CURSOR c_activities_id IS
5263: SELECT JTF_IH_ACTIVITIES_S1.NEXTVAL
5264: FROM dual;
5265:
5266: CURSOR c_user(p_resource_id IN NUMBER) IS
5267: SELECT user_id
5268: FROM ams_jtf_rs_emp_v