DBA Data[Home] [Help]

APPS.FA_MASS_REVAL_PKG dependencies on FA_TRANSACTION_HEADERS

Line 1038: FROM fa_transaction_headers th_rev

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)
1037: AND NOT EXISTS (SELECT 1
1038: FROM fa_transaction_headers th_rev
1039: WHERE th_rev.asset_id = rr.asset_id
1040: AND th_rev.book_type_code = G_book_type_code
1041: AND th_rev.transaction_type_code = 'REVALUATION'
1042: AND th_rev.mass_transaction_id = p_mass_reval_id);

Line 1102: FROM fa_transaction_headers th_rev

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)
1101: AND NOT EXISTS (SELECT 1
1102: FROM fa_transaction_headers th_rev
1103: WHERE th_rev.asset_id = ad.asset_id
1104: AND th_rev.book_type_code = G_book_type_code
1105: AND th_rev.transaction_type_code = 'REVALUATION'
1106: AND th_rev.mass_transaction_id = p_mass_reval_id)