765: and b.book_type_code = p_book_type_code;
766:
767: cursor ck_check_batch_for_transfers is
768: select 1 769: from dual 770: where exists
771: ( select 'x'
772: from fa_mass_update_batch_headers a
773: where a.status_code IN ('P', 'E', 'R', 'N', 'IP')