Line 3607: select nvl(FAILURES,0) into l_fail from dba_jobs
3603: loop
3604: loop
3605: begin
3606: 3607: select nvl(FAILURES,0) into l_fail from dba_jobs 3608: where job = l_tbl_job(I).job_no and rownum = 1;
3609:
3610: --Bug Fix 6870415 Begin
3611: -- IF l_fail > 0