APPS.FA_MASS_REVAL_PKG dependencies on FA_BOOKS

Line 925: fa_books bk,

921: mod(ad.asset_id, p_total_requests) + 1,
922: 1,
923: 'UNPROCESSED'
924: FROM fa_additions_b ad,
925: fa_books bk,
926: fa_mass_revaluation_rules rr
927: WHERE rr.mass_reval_id = p_mass_reval_id
928: AND rr.category_id IS NULL
929: AND rr.asset_id is not null

Line 944: FROM fa_books oldbk

940: g_def_revalue_cip_assets_flag), NULL, 'CAPITALIZED', 'N', 'CAPITALIZED',
941: ad.asset_type)
942: AND ad.asset_type <> 'GROUP'
943: AND NOT EXISTS (SELECT 1
944: FROM fa_books oldbk
945: WHERE oldbk.asset_id = rr.asset_id
946: AND oldbk.book_type_code = G_book_type_code
947: AND oldbk.date_ineffective IS NOT NULL
948: AND oldbk.group_asset_id IS NOT NULL)

Line 984: fa_books bk,

980: mod(ad.asset_id, p_total_requests) + 1,
981: 1,
982: 'UNPROCESSED'
983: FROM fa_additions_b ad,
984: fa_books bk,
985: fa_mass_revaluation_rules rr
986: WHERE rr.mass_reval_id = p_mass_reval_id
987: AND rr.category_id = ad.asset_category_id
988: AND rr.category_id IS not NULL

Line 1005: FROM fa_books oldbk

1001: 'N', 'CAPITALIZED',
1002: ad.asset_type)
1003: AND ad.asset_type <> 'GROUP'
1004: AND NOT EXISTS (SELECT 1
1005: FROM fa_books oldbk
1006: WHERE oldbk.asset_id = ad.asset_id
1007: AND oldbk.book_type_code = G_book_type_code
1008: AND oldbk.date_ineffective IS NOT NULL
1009: AND oldbk.group_asset_id IS NOT NULL)