APPS.BISM_EXPORT_READER dependencies on DUAL

Line 24: + TO_CHAR(systimestamp,'SS') into v_secs FROM dual;

20: -- time in secs since the beginning of the day
21: SELECT
22: TO_CHAR(systimestamp,'HH24') * 60*60+
23: + TO_CHAR(systimestamp,'MI') * 60
24: + TO_CHAR(systimestamp,'SS') into v_secs FROM dual;
25:
26: v_secs := v_secs - a_timeinsecs;
27:
28: -- reconstruct the time after substracting the time duration

Line 36: SELECT to_timestamp(v_temp, 'DD-MON-YY HH24.MI.SS') into v_timestamp from dual;

32: -- stage it as character data
33: v_temp := to_char(sysdate,'DD-MON-YY') || ' '|| v_hour||'.'||v_min||'.'||v_sec;
34: -- create timestamp
35:
36: SELECT to_timestamp(v_temp, 'DD-MON-YY HH24.MI.SS') into v_timestamp from dual;
37: -- delete objects from local cache
38: EXECUTE IMMEDIATE 'delete from bism_export_temp where to_char(time_created, ''DD-MON-YY HH24.MI.SS'') < :1' using v_temp;
39: -- we do not want to delete from actual table because an adversary having access (EXECUTE priv)
40: -- to BISM_EXPORT_READER package can potentially wipe out all objects