DBA Data[Home] [Help]

APPS.JL_ZZ_FA_CALC_ADJUSTMENT_PKG dependencies on FA_ADJUSTMENTS

Line 42: FROM fa_adjustments aj

38: SELECT nvl (sum (decode (aj.debit_credit_flag, 'DR', aj.adjustment_amount, 0)), 0),
39: nvl (sum (decode (aj.debit_credit_flag, 'CR', aj.adjustment_amount, 0)), 0)
40: INTO x_dr_amount,
41: x_cr_amount
42: FROM fa_adjustments aj
43: WHERE aj.asset_id = p_asset_id
44: AND aj.book_type_code = p_book_type_code
45: AND aj.period_counter_created = p_period_counter
46: AND aj.adjustment_type = p_adjustment_type