APPS.JL_CO_FA_TA_REVAL_PKG dependencies on FA_ADDITIONS

Line 87: x_category_id fa_additions.asset_category_id%TYPE := 0;

83: x_end_date fa_calendar_periods.end_date%TYPE;
84: x_appr_revaluation jl_co_fa_asset_apprs.appraisal_value%TYPE := 0;
85: x_prev_revaluation jl_co_fa_asset_apprs.appraisal_value%TYPE := 0;
86: x_net_revaluation jl_co_fa_asset_apprs.appraisal_value%TYPE := 0;
87: x_category_id fa_additions.asset_category_id%TYPE := 0;
88: x_revaluation_account fa_category_books.global_attribute11%TYPE := 0;
89: x_surplus_account fa_category_books.global_attribute12%TYPE := 0;
90: x_reserve_account fa_category_books.global_attribute13%TYPE := 0;
91: x_expense_account fa_category_books.global_attribute14%TYPE := 0;

Line 150: fa_additions ad,

146: fnd_number.canonical_to_number(nvl(ab.global_attribute2,0)) prev_revaluation,
147: dr.deprn_reserve,
148: ab.date_placed_in_service
149: FROM jl_co_fa_asset_apprs ap,
150: fa_additions ad,
151: fa_books ab,
152: fa_deprn_summary dr
153: WHERE ap.asset_number = ad.asset_number
154: AND ap.appraisal_id = p_appr_id

Line 165: CURSOR c_distribution(p_asset_id fa_additions.asset_id%TYPE,

161: AND ab.date_ineffective IS NULL
162: ORDER BY ad.asset_category_id
163: FOR UPDATE OF ap.status;
164:
165: CURSOR c_distribution(p_asset_id fa_additions.asset_id%TYPE,
166: p_book_type VARCHAR2) IS
167:
168: SELECT distribution_id,
169: units_assigned,

Line 1729: fa_additions ad,

1725: FROM jl_co_fa_asset_apprs
1726: WHERE appraisal_id = p_appraisal_id
1727: AND asset_number NOT IN (SELECT ap.asset_number
1728: FROM jl_co_fa_asset_apprs ap,
1729: fa_additions ad,
1730: fa_books ab
1731: WHERE ap.asset_number = ad.asset_number
1732: AND ap.appraisal_id = p_appraisal_id
1733: AND ad.asset_id = ab.asset_id