APPS.ASG_OA_BASE SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 11

    select to_char(lpad(trunc(sec/3600),2,'0')) into h from dual;

Line: 12

    select  mod(sec, 3600) into temp from dual;

Line: 13

    select to_char(lpad(trunc(temp/60),2,'0')) into m from dual;

Line: 14

    select  mod(temp, 60) into s from dual;