DBA Data[Home] [Help]

APPS.JL_ZZ_FA_FUNCTIONS_PKG dependencies on FA_ADJUSTMENTS_MRC_V

Line 444: FROM fa_adjustments_mrc_v

440: IF p_transaction_type in ('RECLASS','CIP RECLASS') THEN
441: BEGIN
442: SELECT nvl(sum(decode(debit_credit_flag,'DR',adjustment_amount,0)),0)
443: INTO p_adjustment
444: FROM fa_adjustments_mrc_v
445: WHERE book_type_code = p_book_type_code
446: AND asset_id = p_asset_id
447: AND period_counter_created = p_period_counter
448: AND source_type_code = l_source_type_code

Line 458: FROM fa_adjustments_mrc_v

454: ELSE
455: BEGIN
456: SELECT nvl(sum(decode(debit_credit_flag,'DR',adjustment_amount,-1 * adjustment_amount)),0)
457: INTO p_adjustment
458: FROM fa_adjustments_mrc_v
459: WHERE book_type_code = p_book_type_code
460: AND asset_id = p_asset_id
461: AND period_counter_created = p_period_counter
462: AND source_type_code = l_source_type_code