DBA Data[Home] [Help]

APPS.FII_AR_PAID_REC_DTL_PKG dependencies on DUAL

Line 66: SELECT TO_CHAR(TRUNC(sysdate),'DD/MM/YYYY') INTO l_sysdate FROM dual;

62: END IF;
63:
64: l_col_curr_suffix := fii_ar_util_pkg.g_col_curr_suffix;
65:
66: SELECT TO_CHAR(TRUNC(sysdate),'DD/MM/YYYY') INTO l_sysdate FROM dual;
67:
68: -- Constructing the pmv sql query
69: sqlstmt := '
70: SELECT