DBA Data[Home] [Help]

APPS.PAY_CA_BALANCE_VIEW_PKG dependencies on DUAL

Line 1962: from dual;

1958: to_char ( to_date ( '01/12/1997', 'DD/MM/YYYY' ), 'J' );
1959: begin
1960: select to_char ( sysdate, 'J HH24:MI:SS' )
1961: into v_now
1962: from dual;
1963:
1964: v_days := to_number ( substr ( v_now, 1, 7 ) );
1965: v_hours := to_number ( substr ( v_now, 9, 2 ) );
1966: v_minutes := to_number ( substr ( v_now, 12, 2 ) );