APPS.FA_SORP_UPG_PKG dependencies on FA_ADDITIONS_V

Line 108: FROM fa_additions_v

104:
105: CURSOR c_cat_cur
106: IS
107: SELECT DISTINCT attribute_category_code
108: FROM fa_additions_v
109: WHERE asset_category_id = p_category_id;
110: BEGIN
111: OPEN c_cat_cur;
112:

Line 842: FROM fa_deprn_summary dep, fa_additions_v adda

838: IS
839: SELECT DISTINCT dep.asset_id, adda.asset_number,
840: adda.asset_category_id,
841: adda.attribute_category_code category_name
842: FROM fa_deprn_summary dep, fa_additions_v adda
843: WHERE adda.asset_id = dep.asset_id
844: AND book_type_code = p_book_type_code;
845:
846: CURSOR c_deprn_apr_cur

Line 980: FROM FA_MC_DEPRN_SUMMARY dep, fa_additions_v adda

976: SELECT DISTINCT adda.asset_id, adda.asset_number,
977: adda.description asset_description,
978: adda.asset_category_id,
979: adda.attribute_category_code category_name
980: FROM FA_MC_DEPRN_SUMMARY dep, fa_additions_v adda
981: WHERE adda.asset_id = dep.asset_id
982: AND book_type_code = p_book_type_code;
983:
984: v_asset_cur c_asset_cur%ROWTYPE;

Line 1404: FROM fa_deprn_summary dep, fa_additions_v adda

1400: SELECT DISTINCT adda.asset_id, adda.asset_number,
1401: adda.description asset_description,
1402: adda.asset_category_id,
1403: adda.attribute_category_code category_name
1404: FROM fa_deprn_summary dep, fa_additions_v adda
1405: WHERE adda.asset_id = dep.asset_id
1406: AND book_type_code = p_book_type_code;
1407:
1408: v_asset_cur c_asset_cur%ROWTYPE;

Line 1838: FROM fa_additions_v a, FA_MC_IMPAIRMENTS i

1834: 'CEB','CEB',
1835: 'OTH'),
1836: 'OTH'
1837: ) impair_classification_type
1838: FROM fa_additions_v a, FA_MC_IMPAIRMENTS i
1839: WHERE a.asset_id = i.asset_id AND i.book_type_code = p_book;
1840:
1841: v_imp_asset_cur c_imp_asset_cur%ROWTYPE;
1842:

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 2384: FROM fa_additions_v a, fa_impairments i

2380: 'CEB','CEB',
2381: 'OTH'),
2382: 'OTH'
2383: ) impair_classification_type
2384: FROM fa_additions_v a, fa_impairments i
2385: WHERE a.asset_id = i.asset_id AND i.book_type_code = p_book;
2386:
2387: v_imp_asset_cur c_imp_asset_cur%ROWTYPE;
2388:

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