DBA Data[Home] [Help]

APPS.FA_RECLASS_UTIL_PVT dependencies on FA_ADDITIONS

Line 159: from fa_additions a,

155:
156: select 1 into v_count
157: from dual
158: where exists ( select 'x'
159: from fa_additions a,
160: fa_categories b
161: where a.asset_id = p_asset_id
162: and a.lease_id = p_Lease_Id
163: and a.asset_category_id = b.category_id

Line 494: SELECT 'x' FROM FA_ADDITIONS

490: SELECT 'x' FROM FA_BOOKS
491: WHERE book_type_code = p_book_type_code AND asset_id = p_asset_id
492: AND rate_adjustment_factor <> 1;
493: CURSOR check_cip IS
494: SELECT 'x' FROM FA_ADDITIONS
495: WHERE asset_id = p_asset_id AND asset_type = 'CIP';
496: CURSOR check_amort_allowed IS
497: SELECT 'x' FROM FA_BOOK_CONTROLS
498: WHERE book_type_code = p_book_type_code AND amortize_flag = 'NO';

Line 806: fa_additions ad

802: dh.assigned_to,
803: ad.asset_number
804: from fa_book_controls bc,
805: fa_distribution_history dh,
806: fa_additions ad
807: where dh.asset_id = p_asset_hdr_rec.asset_id
808: and dh.book_type_code = bc.distribution_source_book
809: and bc.book_type_code = p_asset_hdr_rec.book_type_code
810: and dh.book_type_code = p_asset_hdr_rec.book_type_code