[Home] [Help]
150: -- using count(*) instead of 1 as it throwing no data found. Fix for 8974754
151: select count(*) into v_count
152: from dual
153: where exists ( select 'x'
154: from fa_additions a,
155: fa_categories b
156: where a.asset_id = p_asset_id
157: and a.lease_id = p_Lease_Id
158: and a.asset_category_id = b.category_id
467: SELECT 'x' FROM FA_BOOKS
468: WHERE book_type_code = p_book_type_code AND asset_id = p_asset_id
469: AND rate_adjustment_factor <> 1;
470: CURSOR check_cip IS
471: SELECT 'x' FROM FA_ADDITIONS
472: WHERE asset_id = p_asset_id AND asset_type = 'CIP';
473: CURSOR check_amort_allowed IS
474: SELECT 'x' FROM FA_BOOK_CONTROLS
475: WHERE book_type_code = p_book_type_code AND amortize_flag = 'NO';
766: dh.assigned_to,
767: ad.asset_number
768: from fa_book_controls bc,
769: fa_distribution_history dh,
770: fa_additions ad
771: where dh.asset_id = p_asset_hdr_rec.asset_id
772: and dh.book_type_code = bc.distribution_source_book
773: and bc.book_type_code = p_asset_hdr_rec.book_type_code
774: and dh.book_type_code = p_asset_hdr_rec.book_type_code