DBA Data[Home] [Help]

APPS.PAY_US_BALANCE_VIEW_PKG dependencies on DUAL

Line 1994: from dual;

1990: to_char ( to_date ( '01/12/1997', 'DD/MM/YYYY' ), 'J' );
1991: begin
1992: select to_char ( sysdate, 'J HH24:MI:SS' )
1993: into v_now
1994: from dual;
1995:
1996: v_days := to_number ( substr ( v_now, 1, 7 ) );
1997: v_hours := to_number ( substr ( v_now, 9, 2 ) );
1998: v_minutes := to_number ( substr ( v_now, 12, 2 ) );