APPS.FA_POLISH_PVT dependencies on FA_ADJUSTMENTS

Line 571: -- adjustment in fa_transaction_headers or fa_adjustments.

567:
568: if (FA_POLISH_PVT.calling_mode = 'ADJUSTMENT') then
569: -- If we are currently doing an adjustment, no rows for the adjustment
570: -- will be been added yet, so there will not exist rows for the
571: -- adjustment in fa_transaction_headers or fa_adjustments.
572: l_transaction_type_code := 'ADJUSTMENT';
573:
574: else
575:

Line 581: -- we may have multiple transactions to select from fa_adjustments

577: -- specifically, adjustments and partial retirements, which would affect
578: -- the rate and deprn basis. We want to get the most recent transaction.
579:
580: -- Fix for Bug #3629991. Added transaction_header_id to select b/c
581: -- we may have multiple transactions to select from fa_adjustments
582: -- later.
583: begin
584: select transaction_type_code,
585: transaction_header_id

Line 1426: from fa_adjustments

1422: select adjustment_amount,
1423: debit_credit_flag
1424: into x_adjustment_amount,
1425: l_debit_credit_flag
1426: from fa_adjustments
1427: where book_type_code = p_Book_Type_Code
1428: and asset_id = p_Asset_Id
1429: and transaction_header_id = p_transaction_header_id
1430: and source_type_code = 'ADJUSTMENT'

Line 1775: from fa_adjustments

1771: select adjustment_amount,
1772: debit_credit_flag
1773: into x_retirement_amount,
1774: l_debit_credit_flag
1775: from fa_adjustments
1776: where book_type_code = p_Book_Type_Code
1777: and asset_id = p_Asset_Id
1778: and transaction_header_id = p_transaction_header_id
1779: and source_type_code = 'RETIREMENT'