APPS.MTH_EVENT_PKG dependencies on DUAL

Line 91: SELECT mth_events_d_seq.CURRVAL INTO l_event_id FROM dual;

87: p_shift_workday_fk_key, p_workorder_fk_key, p_equip_status, SYSDATE, SYSDATE, -1, -99999, -1,
88: -99999, -99999);
89:
90: -- l_event_id := mth_events_d_seq.CURRVAL;
91: SELECT mth_events_d_seq.CURRVAL INTO l_event_id FROM dual;
92:
93:
94: -- commit the event generation no matter what SQL error caught
95: COMMIT;

Line 442: l_str := 'SELECT fnd_profile.Value@ ' || fnd_profile.Value('MTH_SOURCE_INSTANCE_DBLINK') || '(''MTH_EBS_GLOBAL_NAME'') FROM dual';

438:
439: BEGIN
440:
441: l_schema_name := USER;
442: l_str := 'SELECT fnd_profile.Value@ ' || fnd_profile.Value('MTH_SOURCE_INSTANCE_DBLINK') || '(''MTH_EBS_GLOBAL_NAME'') FROM dual';
443:
444: EXECUTE IMMEDIATE l_str INTO l_system_pk;
445:
446: OPEN cur_wr;