DBA Data[Home] [Help]

APPS.FA_POLISH_PVT dependencies on FA_BOOKS_SUMMARY_MRC_V

Line 559: from fa_books_summary_mrc_v

555: select polish_deprn_basis,
556: polish_adj_rec_cost
557: into l_prev_year_adjusted_cost,
558: l_prev_year_adj_rec_cost
559: from fa_books_summary_mrc_v
560: where book_type_code = p_Book_Type_Code
561: and asset_id = p_Asset_Id
562: and period_counter = l_prev_year_period_counter;
563:

Line 1387: from fa_books_summary_mrc_v

1383: select polish_deprn_basis,
1384: polish_adj_rec_cost
1385: into x_prev_basis,
1386: x_prev_adj_rec_cost
1387: from fa_books_summary_mrc_v
1388: where book_type_code = p_Book_Type_Code
1389: and asset_id = p_Asset_Id
1390: and period_counter = x_bef_trxn_period_counter;
1391:

Line 1635: from fa_books_summary_mrc_v

1631: select polish_deprn_basis,
1632: polish_adj_rec_cost
1633: into x_prev_basis,
1634: x_prev_adj_rec_cost
1635: from fa_books_summary_mrc_v
1636: where book_type_code = p_Book_Type_Code
1637: and asset_id = p_Asset_Id
1638: and period_counter = x_bef_trxn_period_counter;
1639:

Line 1950: from fa_books_summary_mrc_v

1946: begin
1947:
1948: select nvl(switch_code, 'XX')
1949: into x_switch_code
1950: from fa_books_summary_mrc_v
1951: where book_type_code = p_book_type_code
1952: and asset_id = p_asset_id
1953: and period_counter = p_period_counter;
1954: exception

Line 1981: from fa_books_summary_mrc_v

1977:
1978: begin
1979: select nvl(switch_code, 'XX')
1980: into l_prev_switch_code
1981: from fa_books_summary_mrc_v
1982: where book_type_code = p_book_type_code
1983: and asset_id = p_asset_id
1984: and period_counter = p_period_counter - 1;
1985: exception