DBA Data[Home] [Help]

APPS.FA_MASS_REVAL_PKG dependencies on FA_TRANSACTION_HEADERS

Line 950: FROM fa_transaction_headers th_rev

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)
949: AND NOT EXISTS (SELECT 1
950: FROM fa_transaction_headers th_rev
951: WHERE th_rev.asset_id = rr.asset_id
952: AND th_rev.book_type_code = G_book_type_code
953: AND th_rev.transaction_type_code = 'REVALUATION'
954: AND th_rev.mass_transaction_id = p_mass_reval_id);

Line 1011: FROM fa_transaction_headers th_rev

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)
1010: AND NOT EXISTS (SELECT 1
1011: FROM fa_transaction_headers th_rev
1012: WHERE th_rev.asset_id = ad.asset_id
1013: AND th_rev.book_type_code = G_book_type_code
1014: AND th_rev.transaction_type_code = 'REVALUATION'
1015: AND th_rev.mass_transaction_id = p_mass_reval_id)