DBA Data[Home] [Help]

APPS.AK_QUERY_PKG dependencies on V$NLS_PARAMETERS

Line 966: from V$NLS_PARAMETERS WHERE PARAMETER='NLS_DATE_FORMAT';

962: END IF;
963:
964: if ( select_rec.data_type = 'DATETIME' ) then
965: select value into l_date_format
966: from V$NLS_PARAMETERS WHERE PARAMETER='NLS_DATE_FORMAT';
967: l_date_format := l_date_format ||' HH24:MI:SS';
968: select_stmt := select_stmt ||'TO_CHAR(akq.'||
969: select_rec.column_name||', '''||
970: l_date_format||''')';