DBA Data[Home] [Help]

APPS.FA_POLISH_PVT dependencies on FA_DEPRN_SUMMARY

Line 539: from fa_deprn_summary_mrc_v

535:
536: if (p_MRC_SOB_Type_Code = 'R') then
537: select deprn_reserve
538: into l_first_year_reserve
539: from fa_deprn_summary_mrc_v
540: where book_type_code = p_Book_Type_Code
541: and asset_id = p_Asset_Id
542: and period_counter = l_first_year_period_counter;
543:

Line 546: from fa_deprn_summary_mrc_v

542: and period_counter = l_first_year_period_counter;
543:
544: select deprn_reserve
545: into l_prev_year_reserve
546: from fa_deprn_summary_mrc_v
547: where book_type_code = p_Book_Type_Code
548: and asset_id = p_Asset_Id
549: and period_counter = l_prev_year_period_counter;
550:

Line 641: from fa_deprn_summary

637:
638: else
639: select deprn_reserve
640: into l_first_year_reserve
641: from fa_deprn_summary
642: where book_type_code = p_Book_Type_Code
643: and asset_id = p_Asset_Id
644: and period_counter = l_first_year_period_counter;
645:

Line 648: from fa_deprn_summary

644: and period_counter = l_first_year_period_counter;
645:
646: select deprn_reserve
647: into l_prev_year_reserve
648: from fa_deprn_summary
649: where book_type_code = p_Book_Type_Code
650: and asset_id = p_Asset_Id
651: and period_counter = l_prev_year_period_counter;
652:

Line 1461: from fa_deprn_summary_mrc_v

1457: end;
1458:
1459: select deprn_reserve
1460: into x_prev_reserve
1461: from fa_deprn_summary_mrc_v
1462: where book_type_code = p_Book_Type_Code
1463: and asset_id = p_Asset_Id
1464: and period_counter = x_bef_trxn_period_counter;
1465: else

Line 1549: from fa_deprn_summary

1545: end;
1546:
1547: select deprn_reserve
1548: into x_prev_reserve
1549: from fa_deprn_summary
1550: where book_type_code = p_Book_Type_Code
1551: and asset_id = p_Asset_Id
1552: and period_counter = x_bef_trxn_period_counter;
1553: end if;