Line 1528: select sysdate into l_sysdate from dual;
1524: if (SQL%NOTFOUND) then
1525: Raise NO_DATA_FOUND;
1526: end if;
1527: 1528: select sysdate into l_sysdate from dual; 1529:
1530: UPDATE fa_book_controls_history
1531: SET date_inactive = l_sysdate
1532: WHERE book_type_code = X_Book_Type_Code