APPS.FA_CDE_PKG dependencies on FA_DEPRN_SUMMARY

Line 1906: FROM fa_deprn_summary

1902: -- If deprn is already run for the Asset, follow the standard procedure of calculating the Deprn.
1903: BEGIN
1904: SELECT 'Y'
1905: INTO h_deprn_run
1906: FROM fa_deprn_summary
1907: WHERE book_type_code = dpr.book
1908: AND asset_id = dpr.asset_id
1909: AND deprn_source_code = 'DEPRN'
1910: AND period_counter = ((dpr_in.y_begin*perds_per_yr_dcal+dpr_in.p_cl_begin)-1);

Line 3447: from fa_books_summary bs,fa_deprn_summary ds

3443:
3444: BEGIN
3445: select 'Y'
3446: into prod_life_complete
3447: from fa_books_summary bs,fa_deprn_summary ds
3448: where bs.asset_id = dpr.asset_id
3449: and bs.period_counter = l_period_counter
3450: and bs.life_complete_flag = 'Y'
3451: and bs.book_type_code = dpr.book