APPS.FA_SORP_UPG_PKG dependencies on FA_MASS_REVALUATIONS

Line 1900: FROM fa_mass_revaluations

1896:
1897: CURSOR c_reval_id_cur
1898: IS
1899: SELECT DISTINCT mass_reval_id, description
1900: FROM fa_mass_revaluations
1901: WHERE book_type_code = p_book;
1902:
1903: -- Bug#7578069 cursor queries for c_reval_asset_cur and c_reval_cat_cur modified
1904:

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 2446: FROM fa_mass_revaluations

2442:
2443: CURSOR c_reval_id_cur
2444: IS
2445: SELECT DISTINCT mass_reval_id, description
2446: FROM fa_mass_revaluations
2447: WHERE book_type_code = p_book;
2448:
2449: -- Bug#7578069 cursor queries for c_reval_asset_cur and c_reval_cat_cur modified
2450:

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