APPS.FA_ASSET_VAL_PVT dependencies on DUAL

Line 315: from dual

311: -- Check that numeric asset numbers are less than those used for
312: -- automatic asset numbering.
313: select count(*)
314: into l_count
315: from dual
316: where nvl(substr(p_asset_number, 1,1), '0') between '0' and '9'
317: and nvl(substr(p_asset_number, 2,1), '0') between '0' and '9'
318: and nvl(substr(p_asset_number, 3,1), '0') between '0' and '9'
319: and nvl(substr(p_asset_number, 4,1), '0') between '0' and '9'

Line 1798: from sys.dual;

1794: else -- not table
1795:
1796: select FA_METHODS_S.NEXTVAL
1797: into l_method_id
1798: from sys.dual;
1799:
1800: -- need to derive more values to distinguish between
1801: -- STL and Formula methods. Can't use cache as life
1802: -- is unknown so like the function in calc engine,

Line 2320: from dual

2316:
2317: if p_extended_flag then
2318: select count(1)
2319: into l_count
2320: from dual
2321: where exists (
2322: select 1
2323: from fa_transaction_headers th
2324: where th.book_type_code = p_book

Line 2335: from dual

2331: and th2.transaction_key = 'ES'));
2332: else
2333: select count(1)
2334: into l_count
2335: from dual
2336: where exists (
2337: select 1 from fa_transaction_headers
2338: where book_type_code = p_book
2339: and asset_id = p_asset_id

Line 2980: from dual

2976: -- and BOOK_TYPE_CODE = p_book_type_code;
2977: l_count := null;
2978: select 1
2979: into l_count
2980: from dual
2981: where exists (select 'X'
2982: from FA_BOOKS
2983: where ASSET_ID = p_group_asset_id
2984: and BOOK_TYPE_CODE = p_book_type_code);