DBA Data[Home] [Help]

APPS.FA_POLISH_PVT dependencies on FA_MC_BOOKS_SUMMARY

Line 688: from fa_mc_books_summary

684: select polish_deprn_basis,
685: polish_adj_rec_cost
686: into l_prev_year_adjusted_cost,
687: l_prev_year_adj_rec_cost
688: from fa_mc_books_summary
689: where book_type_code = p_Book_Type_Code
690: and asset_id = p_Asset_Id
691: and period_counter = l_prev_year_period_counter
692: and set_of_books_id = p_set_of_books_id;

Line 1543: from fa_mc_books_summary

1539: select polish_deprn_basis,
1540: polish_adj_rec_cost
1541: into x_prev_basis,
1542: x_prev_adj_rec_cost
1543: from fa_mc_books_summary
1544: where book_type_code = p_Book_Type_Code
1545: and asset_id = p_Asset_Id
1546: and period_counter = x_bef_trxn_period_counter
1547: and set_of_books_id = p_set_of_books_id;

Line 1814: from fa_mc_books_summary

1810: select polish_deprn_basis,
1811: polish_adj_rec_cost
1812: into x_prev_basis,
1813: x_prev_adj_rec_cost
1814: from fa_mc_books_summary
1815: where book_type_code = p_Book_Type_Code
1816: and asset_id = p_Asset_Id
1817: and period_counter = x_bef_trxn_period_counter
1818: and set_of_books_id = p_set_of_books_id;

Line 2134: from fa_mc_books_summary

2130: begin
2131:
2132: select nvl(switch_code, 'XX')
2133: into x_switch_code
2134: from fa_mc_books_summary
2135: where book_type_code = p_book_type_code
2136: and asset_id = p_asset_id
2137: and period_counter = p_period_counter
2138: and set_of_books_id = p_set_of_books_id;

Line 2166: from fa_mc_books_summary

2162:
2163: begin
2164: select nvl(switch_code, 'XX')
2165: into l_prev_switch_code
2166: from fa_mc_books_summary
2167: where book_type_code = p_book_type_code
2168: and asset_id = p_asset_id
2169: and period_counter = p_period_counter - 1
2170: and set_of_books_id = p_set_of_books_id;