17: begin
18: -- get mrc related info
19: begin
20: select to_number(substrb(userenv('CLIENT_INFO'),45,10))
21: into h_set_of_books_id from dual;
22: exception
23: when others then
24: h_set_of_books_id := null;
25: end;
99: */
100: BEGIN
101: Select 1
102: Into bonus_count
103: From dual
104: where exists (select 1 from FA_Books
105: Where book_type_code = book
106: and bonus_rule is not null
107: and transaction_header_id_out is null);