58: -- we need to get SYSDATE into local variable as a string
59:
60: SELECT TO_CHAR(SYSDATE,'DD/MM/YYYY')
61: INTO l_sysdate 62: FROM dual; 63:
64: sqlstmt := '
65: SELECT FII_EA_INV_NUM FII_EA_INV_NUM,
66: FII_EA_TRAN_CURRENCY FII_EA_TRAN_CURRENCY,