APPS.FA_REC_PVT_PKG2 SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 26

	    SELECT	book_type_code,
			date_placed_in_service, date_placed_in_service,
			prorate_convention_code, deprn_method_code,
	   		life_in_months, basic_rate, adjusted_rate,
	   		production_capacity, unit_of_measure,
			bonus_rule, NULL, ceiling_name,
	   		depreciate_flag, allowed_deprn_limit,
	   		allowed_deprn_limit_amount, percent_salvage_value
    	    FROM 	FA_BOOKS
   	    WHERE 	book_type_code = p_book_type_code
	    AND 	asset_id = p_asset_id
    	    AND		date_ineffective IS NULL;

Line: 167

	    SELECT 'x' FROM FA_BOOK_CONTROLS
	    WHERE book_type_code = p_book_type_code AND allow_mass_changes = 'NO'
	    AND p_mr_req_id <> -1;

Line: 171

	    SELECT 'x' FROM FA_BOOKS
	    WHERE book_type_code = p_book_type_code AND asset_id = p_asset_id
	    AND rate_adjustment_factor <> 1;

Line: 175

	    SELECT 'x' FROM FA_ADDITIONS
	    WHERE asset_id = p_asset_id AND asset_type = 'CIP';

Line: 178

	    SELECT 'x' FROM FA_BOOK_CONTROLS
	    WHERE book_type_code = p_book_type_code AND amortize_flag = 'NO';

Line: 181

	    SELECT 'x' FROM FA_DEPRN_SUMMARY
	    WHERE book_type_code = p_book_type_code AND asset_id = p_asset_id
	    AND deprn_source_code = 'DEPRN' AND deprn_amount <> 0;