DBA Data[Home] [Help]

APPS.FA_RSVLDG_REP_INS_PKG dependencies on DUAL

Line 21: into h_set_of_books_id from dual;

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;

Line 103: From dual

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);