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

Line 430: FROM DUAL

426: l_dummy NUMBER;
427:
428: CURSOR c_evh_calendar IS
429: SELECT 1
430: FROM DUAL
431: WHERE EXISTS(
432: SELECT 1
433: FROM gl_periods_v
434: WHERE period_set_name = p_evh_calendar

Line 535: FROM DUAL;

531: IS
532: l_pk NUMBER;
533: CURSOR c_seq IS
534: SELECT ams_source_codes_s.NEXTVAL
535: FROM DUAL;
536: BEGIN
537: OPEN c_seq;
538: FETCH c_seq INTO l_pk;
539: CLOSE c_seq;

Line 1022: FROM DUAL

1018:
1019:
1020: CURSOR c_bgtsrc_exist IS
1021: SELECT 1
1022: FROM DUAL
1023: WHERE EXISTS(
1024: SELECT 1
1025: FROM ozf_act_budgets --anchaudh: changed call from ams_act_budgets to ozf_act_budgets : bug#3453430
1026: WHERE act_budget_used_by_id = p_event_id

Line 1340: FROM DUAL;

1336: l_return_status VARCHAR2(1); --holds the status coming back from other procedure calls.
1337:
1338: CURSOR c_batch_id IS --Cursor to pick up the Batch ID.
1339: SELECT as_sl_imp_batch_s.NEXTVAL
1340: FROM DUAL;
1341:
1342: CURSOR c_get_evnt_sched_src_cd(event_id_in IN NUMBER) IS
1343: SELECT source_code
1344: FROM ams_event_offers_all_b

Line 1676: FROM DUAL;

1672: l_party_site_id NUMBER; --primary party_site_id for the party_id from hz_party_sites table.
1673:
1674: CURSOR c_rec_id IS --Cursor to pick up the next value in the sequence.
1675: SELECT as_import_interface_s.NEXTVAL
1676: FROM DUAL;
1677:
1678: --Cursor to pick up the data from HZ_PARTIES table.
1679: CURSOR c_party_info (party_id_in IN NUMBER) IS
1680: SELECT party_type