APPS.FA_MASS_REVAL_PKG dependencies on FA_BOOKS

Line 1008: fa_books bk,

1004: mod(ad.asset_id, p_total_requests) + 1,
1005: 1,
1006: 'UNPROCESSED'
1007: FROM fa_additions_b ad,
1008: fa_books bk,
1009: fa_deprn_summary ds,
1010: fa_mass_revaluation_rules rr
1011: WHERE rr.mass_reval_id = p_mass_reval_id
1012: AND rr.category_id IS NULL

Line 1032: FROM fa_books oldbk

1028: AND ds.book_type_code = G_book_type_code
1029: AND ds.deprn_source_code = 'BOOKS'
1030: AND ds.period_counter < l_min_period_counter
1031: AND NOT EXISTS (SELECT 1
1032: FROM fa_books oldbk
1033: WHERE oldbk.asset_id = rr.asset_id
1034: AND oldbk.book_type_code = G_book_type_code
1035: AND oldbk.date_ineffective IS NOT NULL
1036: AND oldbk.group_asset_id IS NOT NULL)

Line 1070: fa_books bk,

1066: mod(ad.asset_id, p_total_requests) + 1,
1067: 1,
1068: 'UNPROCESSED'
1069: FROM fa_additions_b ad,
1070: fa_books bk,
1071: fa_deprn_summary ds,
1072: fa_mass_revaluation_rules rr
1073: WHERE rr.mass_reval_id = p_mass_reval_id
1074: AND rr.category_id = ad.asset_category_id

Line 1096: FROM fa_books oldbk

1092: AND ds.book_type_code = G_book_type_code
1093: AND ds.deprn_source_code = 'BOOKS'
1094: AND ds.period_counter < l_min_period_counter
1095: AND NOT EXISTS (SELECT 1
1096: FROM fa_books oldbk
1097: WHERE oldbk.asset_id = ad.asset_id
1098: AND oldbk.book_type_code = G_book_type_code
1099: AND oldbk.date_ineffective IS NOT NULL
1100: AND oldbk.group_asset_id IS NOT NULL)