APPS.FA_ASSET_CALC_PVT dependencies on FA_TRANSACTION_HEADERS

Line 105: from fa_transaction_headers

101: , trx_reference_id
102: , last_update_date
103: , last_updated_by
104: , last_update_login
105: from fa_transaction_headers
106: where transaction_header_id = px_trans_rec.member_transaction_header_id;
107:
108: -- Bug4958977: Introducing new cursor to trap dpis change only trx.
109: CURSOR c_check_dpis_change is

Line 137: from fa_transaction_headers

133:
134: -- Bug 8520695
135: CURSOR c_check_addn is -- to check if there exists an addition transaction before current transaction
136: select count(1)
137: from fa_transaction_headers
138: where asset_id = p_asset_hdr_rec.asset_id
139: and transaction_header_id < px_trans_rec.transaction_header_id
140: and transaction_type_code = 'ADDITION';
141:

Line 1564: fa_transaction_headers th

1560: -1 * adj.adjustment_amount,
1561: adj.adjustment_amount))
1562: INTO l_deprn_exp_temp
1563: FROM fa_adjustments adj,
1564: fa_transaction_headers th
1565: WHERE th.book_type_code = p_asset_hdr_rec.book_type_code
1566: and th.asset_id = p_asset_hdr_rec.asset_id
1567: and th.transaction_type_code in ('ADDITION', 'ADJUSTMENT') --Bug7409454
1568: and adj.book_type_code = p_asset_hdr_rec.book_type_code

Line 1582: fa_transaction_headers th

1578: -1 * adj.adjustment_amount,
1579: adj.adjustment_amount))
1580: INTO l_deprn_exp_temp
1581: FROM fa_mc_adjustments adj,
1582: fa_transaction_headers th
1583: WHERE th.book_type_code = p_asset_hdr_rec.book_type_code
1584: and th.asset_id = p_asset_hdr_rec.asset_id
1585: and th.transaction_type_code in ('ADDITION', 'ADJUSTMENT') ----Bug7409454
1586: and adj.book_type_code = p_asset_hdr_rec.book_type_code

Line 1664: fa_transaction_headers th

1660: -1 * adj.annualized_adjustment,
1661: adj.annualized_adjustment))
1662: INTO l_deprn_exp,l_ann_adj_deprn_exp
1663: FROM fa_adjustments adj,
1664: fa_transaction_headers th
1665: WHERE th.book_type_code = p_asset_hdr_rec.book_type_code
1666: and th.asset_id = p_asset_hdr_rec.asset_id
1667: and th.transaction_type_code in ('ADDITION', 'ADJUSTMENT') --Bug7409454
1668: and adj.book_type_code = p_asset_hdr_rec.book_type_code

Line 1685: fa_transaction_headers th

1681: -1 * adj.annualized_adjustment,
1682: adj.annualized_adjustment))
1683: INTO l_deprn_exp,l_ann_adj_deprn_exp
1684: FROM fa_mc_adjustments adj,
1685: fa_transaction_headers th
1686: WHERE th.book_type_code = p_asset_hdr_rec.book_type_code
1687: and th.asset_id = p_asset_hdr_rec.asset_id
1688: and th.transaction_type_code in ('ADDITION', 'ADJUSTMENT') ----Bug7409454
1689: and adj.book_type_code = p_asset_hdr_rec.book_type_code

Line 1752: fa_transaction_headers th

1748: -1 * adj.annualized_adjustment,
1749: adj.annualized_adjustment))
1750: INTO l_deprn_exp,l_ann_adj_deprn_exp
1751: FROM fa_adjustments adj,
1752: fa_transaction_headers th
1753: WHERE th.book_type_code = p_asset_hdr_rec.book_type_code
1754: and th.asset_id = p_asset_hdr_rec.asset_id
1755: and th.transaction_type_code in ('ADDITION', 'ADJUSTMENT')
1756: and adj.book_type_code = p_asset_hdr_rec.book_type_code

Line 1773: fa_transaction_headers th

1769: -1 * adj.annualized_adjustment,
1770: adj.annualized_adjustment))
1771: INTO l_deprn_exp,l_ann_adj_deprn_exp
1772: FROM fa_mc_adjustments adj,
1773: fa_transaction_headers th
1774: WHERE th.book_type_code = p_asset_hdr_rec.book_type_code
1775: and th.asset_id = p_asset_hdr_rec.asset_id
1776: and th.transaction_type_code in ('ADDITION', 'ADJUSTMENT')
1777: and adj.book_type_code = p_asset_hdr_rec.book_type_code

Line 4367: fa_transaction_headers th

4363: bk.transaction_header_id_in
4364: into l_depreciate_flag,
4365: l_dep_flag_thid
4366: from fa_books bk,
4367: fa_transaction_headers th
4368: where th.asset_id = p_asset_hdr_rec.asset_id
4369: and th.book_type_code = p_asset_hdr_rec.book_type_code
4370: and th.transaction_type_code = 'ADDITION'
4371: and th.transaction_header_id = bk.transaction_header_id_in;