APPS.FA_RSVLDG_REP_INS_PKG dependencies on DUAL

Line 31: into h_set_of_books_id from dual;

27: begin
28: -- get mrc related info
29: begin
30: select to_number(substrb(userenv('CLIENT_INFO'),45,10))
31: into h_set_of_books_id from dual;
32: exception
33: when others then
34: h_set_of_books_id := null;
35: end;

Line 107: From dual

103: /* Bugfix 6677528 : query should have more conditions. Use exists instead of count */
104: BEGIN
105: Select 1
106: Into bonus_count
107: From dual
108: where exists (select 1 from FA_Books
109: Where book_type_code = book
110: and bonus_rule is not null
111: and transaction_header_id_out is null);