DBA Data[Home] [Help]

APPS.PAY_US_BALANCE_VIEW_PKG dependencies on DUAL

Line 1970: from dual;

1966: to_char ( to_date ( '01/12/1997', 'DD/MM/YYYY' ), 'J' );
1967: begin
1968: select to_char ( sysdate, 'J HH24:MI:SS' )
1969: into v_now
1970: from dual;
1971:
1972: v_days := to_number ( substr ( v_now, 1, 7 ) );
1973: v_hours := to_number ( substr ( v_now, 9, 2 ) );
1974: v_minutes := to_number ( substr ( v_now, 12, 2 ) );