APPS.FA_SORP_UPG_PKG dependencies on FA_MASS_REVALUATION_RULES

Line 1910: FROM fa_additions_v a, fa_mass_revaluation_rules r,fa_mass_revaluations mr

1906: IS
1907: SELECT 'Revaluation' transaction_type, r.asset_id, a.asset_number,
1908: a.description asset_description, r.mass_reval_id,
1909: r.reval_percent
1910: FROM fa_additions_v a, fa_mass_revaluation_rules r,fa_mass_revaluations mr
1911: WHERE a.asset_id = r.asset_id
1912: AND r.mass_reval_id = mr.mass_reval_id
1913: AND mr.mass_reval_id = v_mass_reval_id
1914: AND r.category_id IS NULL

Line 1925: FROM fa_additions_v a, fa_mass_revaluation_rules r,fa_mass_revaluations mr

1921: SELECT distinct 'Revaluation' transaction_type,
1922: r.category_id asset_category_id,
1923: a.attribute_category_code category_name, r.mass_reval_id,
1924: r.reval_percent
1925: FROM fa_additions_v a, fa_mass_revaluation_rules r,fa_mass_revaluations mr
1926: WHERE a.asset_category_id = r.category_id
1927: AND r.mass_reval_id = mr.mass_reval_id
1928: AND mr.mass_reval_id = v_mass_reval_id
1929: AND r.asset_id IS NULL

Line 2263: UPDATE fa_mass_revaluation_rules

2259: INTO v_final_reval_asset_cur;
2260:
2261: EXIT WHEN c_final_reval_asset_cur%NOTFOUND;
2262:
2263: UPDATE fa_mass_revaluation_rules
2264: SET reason = v_final_reval_asset_cur.reval_reason,
2265: value_type = 'PER',
2266: book_type_code = p_book
2267: WHERE mass_reval_id = v_final_reval_asset_cur.mass_reval_id

Line 2281: UPDATE fa_mass_revaluation_rules

2277: INTO v_final_reval_cat_cur;
2278:
2279: EXIT WHEN c_final_reval_cat_cur%NOTFOUND;
2280:
2281: UPDATE fa_mass_revaluation_rules
2282: SET reason = v_final_reval_cat_cur.reval_reason,
2283: value_type = 'PER',
2284: book_type_code = p_book
2285: WHERE mass_reval_id = v_final_reval_cat_cur.mass_reval_id

Line 2456: FROM fa_additions_v a, fa_mass_revaluation_rules r,fa_mass_revaluations mr

2452: IS
2453: SELECT 'Revaluation' transaction_type, r.asset_id, a.asset_number,
2454: a.description asset_description, r.mass_reval_id,
2455: r.reval_percent
2456: FROM fa_additions_v a, fa_mass_revaluation_rules r,fa_mass_revaluations mr
2457: WHERE a.asset_id = r.asset_id
2458: AND r.mass_reval_id = mr.mass_reval_id
2459: AND mr.mass_reval_id = v_mass_reval_id
2460: AND r.category_id IS NULL

Line 2471: FROM fa_additions_v a, fa_mass_revaluation_rules r,fa_mass_revaluations mr

2467: SELECT distinct 'Revaluation' transaction_type,
2468: r.category_id asset_category_id,
2469: a.attribute_category_code category_name, r.mass_reval_id,
2470: r.reval_percent
2471: FROM fa_additions_v a, fa_mass_revaluation_rules r,fa_mass_revaluations mr
2472: WHERE a.asset_category_id = r.category_id
2473: AND r.mass_reval_id = mr.mass_reval_id
2474: AND mr.mass_reval_id = v_mass_reval_id
2475: AND r.asset_id IS NULL

Line 2810: UPDATE fa_mass_revaluation_rules

2806: INTO v_final_reval_asset_cur;
2807:
2808: EXIT WHEN c_final_reval_asset_cur%NOTFOUND;
2809:
2810: UPDATE fa_mass_revaluation_rules
2811: SET reason = v_final_reval_asset_cur.reval_reason,
2812: value_type = 'PER',
2813: book_type_code = p_book
2814: WHERE mass_reval_id = v_final_reval_asset_cur.mass_reval_id

Line 2828: UPDATE fa_mass_revaluation_rules

2824: INTO v_final_reval_cat_cur;
2825:
2826: EXIT WHEN c_final_reval_cat_cur%NOTFOUND;
2827:
2828: UPDATE fa_mass_revaluation_rules
2829: SET reason = v_final_reval_cat_cur.reval_reason,
2830: value_type = 'PER',
2831: book_type_code = p_book
2832: WHERE mass_reval_id = v_final_reval_cat_cur.mass_reval_id