APPS.FA_ASSET_CALC_PVT dependencies on FA_TRANSACTION_HEADERS

Line 95: from fa_transaction_headers

91: , trx_reference_id
92: , last_update_date
93: , last_updated_by
94: , last_update_login
95: from fa_transaction_headers
96: where transaction_header_id = px_trans_rec.member_transaction_header_id;
97:
98: -- Bug4958977: Introducing new cursor to trap dpis change only trx.
99: CURSOR c_check_dpis_change is

Line 1261: fa_transaction_headers th

1257: -1 * adj.adjustment_amount,
1258: adj.adjustment_amount))
1259: INTO l_deprn_exp
1260: FROM fa_adjustments adj,
1261: fa_transaction_headers th
1262: WHERE th.book_type_code = p_asset_hdr_rec.book_type_code
1263: and th.asset_id = p_asset_hdr_rec.asset_id
1264: and th.transaction_type_code in ('ADDITION', 'ADJUSTMENT') --Bug7409454
1265: and adj.book_type_code = p_asset_hdr_rec.book_type_code

Line 1279: fa_transaction_headers th

1275: -1 * adj.adjustment_amount,
1276: adj.adjustment_amount))
1277: INTO l_deprn_exp
1278: FROM fa_adjustments_mrc_v adj,
1279: fa_transaction_headers th
1280: WHERE th.book_type_code = p_asset_hdr_rec.book_type_code
1281: and th.asset_id = p_asset_hdr_rec.asset_id
1282: and th.transaction_type_code in ('ADDITION', 'ADJUSTMENT') ----Bug7409454
1283: and adj.book_type_code = p_asset_hdr_rec.book_type_code

Line 1315: fa_transaction_headers th

1311: -1 * adj.adjustment_amount,
1312: adj.adjustment_amount))
1313: INTO l_deprn_exp
1314: FROM fa_adjustments adj,
1315: fa_transaction_headers th
1316: WHERE th.book_type_code = p_asset_hdr_rec.book_type_code
1317: and th.asset_id = p_asset_hdr_rec.asset_id
1318: and th.transaction_type_code in ('ADDITION', 'ADJUSTMENT')
1319: and adj.book_type_code = p_asset_hdr_rec.book_type_code

Line 1333: fa_transaction_headers th

1329: -1 * adj.adjustment_amount,
1330: adj.adjustment_amount))
1331: INTO l_deprn_exp
1332: FROM fa_adjustments_mrc_v adj,
1333: fa_transaction_headers th
1334: WHERE th.book_type_code = p_asset_hdr_rec.book_type_code
1335: and th.asset_id = p_asset_hdr_rec.asset_id
1336: and th.transaction_type_code in ('ADDITION', 'ADJUSTMENT')
1337: and adj.book_type_code = p_asset_hdr_rec.book_type_code

Line 3605: fa_transaction_headers th

3601: bk.transaction_header_id_in
3602: into l_depreciate_flag,
3603: l_dep_flag_thid
3604: from fa_books bk,
3605: fa_transaction_headers th
3606: where th.asset_id = p_asset_hdr_rec.asset_id
3607: and th.book_type_code = p_asset_hdr_rec.book_type_code
3608: and th.transaction_type_code = 'ADDITION'
3609: and th.transaction_header_id = bk.transaction_header_id_in;