APPS.FA_REC_PVT_PKG3 SQL Statements

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

Line: 121

	    SELECT book_class, allow_cost_ceiling, allow_deprn_exp_ceiling
	    FROM FA_BOOK_CONTROLS
    	    WHERE book_type_code = p_book_type_code;

Line: 125

	    SELECT ceiling_type FROM FA_CEILING_TYPES
    	    WHERE ceiling_name = p_new_ceiling_name;

Line: 128

	    SELECT cost, itc_amount_id FROM FA_BOOKS
    	    WHERE asset_id = p_asset_id and book_type_code = p_book_type_code
    	    AND date_ineffective IS NULL;

Line: 211

	    SELECT 'N'
	    FROM FA_METHODS mth
	    WHERE mth.method_code = p_old_rules.deprn_method
	    AND mth.rate_source_rule = 'PRODUCTION';

Line: 297

	    SELECT conv.prorate_date
	    FROM FA_CONVENTIONS conv
	    WHERE conv.prorate_convention_code = p_new_conv
	    AND p_date_placed_in_service between conv.start_date and conv.end_date;

Line: 302

	    SELECT 'x'
	    FROM FA_CALENDAR_PERIODS cp, FA_BOOK_CONTROLS bc
	    WHERE bc.book_type_code = p_book_type_code
	    AND bc.prorate_calendar = cp.calendar_type
	    AND l_prorate_date between cp.start_date and cp.end_date;

Line: 382

	    SELECT 'N'
  	    FROM FA_METHODS mth
	    WHERE l_depreciation_check = 'Y'
	    AND p_old_deprn_method = mth.method_code
	    AND mth.rate_source_rule <> 'PRODUCTION'
	    AND l_new_rate_src_rule = 'PRODUCTION';

Line: 389

	    SELECT 'x'
	    FROM FA_METHODS mth, FA_CATEGORY_BOOK_DEFAULTS cbd,
		 FA_BOOK_CONTROLS bc, FA_BOOKS bk
	    WHERE bc.distribution_source_book = p_book_type_code
	    AND bc.book_class = 'TAX'
	    AND bk.book_type_code = bc.book_type_code
	    AND bk.asset_id = p_asset_id
	    AND bk.date_ineffective IS NULL
	    AND bk.book_type_code = cbd.book_type_code
	    AND cbd.category_id = p_new_category_id
	    AND bk.date_placed_in_service between cbd.start_dpis
		and nvl(cbd.end_dpis, to_date('31-12-4712', 'DD-MM-YYYY'))
	    AND cbd.deprn_method = mth.method_code
	    AND mth.rate_source_rule = 'PRODUCTION'
	    AND l_new_rate_src_rule <> 'PRODUCTION';

Line: 405

	    SELECT 'x'
	    FROM FA_METHODS corp_mth, FA_CATEGORY_BOOK_DEFAULTS cbd,
		 FA_BOOK_CONTROLS bc, FA_BOOKS bk
	    WHERE bc.book_type_code = p_book_type_code
	    AND bk.book_type_code = bc.distribution_source_book
	    AND bk.asset_id = p_asset_id
	    AND bk.date_ineffective IS NULL
	    AND bk.book_type_code = cbd.book_type_code
	    AND cbd.category_id = p_new_category_id
	    AND bk.date_placed_in_service between cbd.start_dpis
		and nvl(cbd.end_dpis, to_date('31-12-4712', 'DD-MM-YYYY'))
	    AND cbd.deprn_method = corp_mth.method_code
	    AND corp_mth.rate_source_rule <> 'PRODUCTION'
	    AND l_new_rate_src_rule = 'PRODUCTION';

Line: 420

	    SELECT rate_source_rule, deprn_basis_rule
    	    FROM FA_METHODS
    	    WHERE method_code = p_new_deprn_method;

Line: 425

            SELECT itc_amount_id, conversion_date
            FROM FA_BOOKS
            WHERE asset_id = p_asset_id AND book_type_code = p_book_type_code
            AND date_ineffective IS NULL;

Line: 430

	    SELECT book_class FROM FA_BOOK_CONTROLS
    	    WHERE book_type_code = p_book_type_code;

Line: 435

            SELECT 'N'
            FROM FA_DEPRN_SUMMARY ds, FA_METHODS mth
            WHERE mth.method_code = p_old_deprn_method
            AND mth.rate_source_rule = 'FORMULA'
            AND ds.asset_id = p_asset_id
            AND ds.book_type_code = p_book_type_code
            AND ds.deprn_source_code = 'DEPRN' AND deprn_amount <> 0;

Line: 472

    SELECT count(1) INTO l_count 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
    AND rownum < 2;

Line: 593

	    SELECT 'Y'
	    FROM FA_FLAT_RATES fr, FA_METHODS mth
	    WHERE mth.method_code = p_deprn_method
	    AND mth.life_in_months IS NULL
	    AND mth.method_id = fr.method_id
	    AND fr.basic_rate = p_basic_rate
	    AND fr.adjusted_rate = p_adjusted_rate;

Line: 601

	    SELECT 'Y'
	    FROM FA_METHODS mth
	    WHERE mth.method_code = p_deprn_method
	    AND nvl(mth.life_in_months, 99999) = p_life_in_months;

Line: 606

	    SELECT rate_source_rule FROM FA_METHODS
    	    WHERE method_code = p_deprn_method;