APPS.FA_WHATIF_DEPRN_PKG dependencies on FA_DEPRN_SUMMARY

Line 1085: from fa_deprn_summary where

1081: into first_fy
1082: from fa_deprn_periods where
1083: book_type_code = X_book
1084: and period_counter = ( select period_counter + 1
1085: from fa_deprn_summary where
1086: book_type_code = X_book
1087: and asset_id = X_asset_id
1088: and deprn_source_code = 'BOOKS'); */
1089:

Line 1096: fa_deprn_summary fads

1092: from dual
1093: where EXISTS (
1094: select 'Y'
1095: from fa_deprn_periods fadp,
1096: fa_deprn_summary fads
1097: where fadp.book_type_code = X_book
1098: and fads.book_type_code = X_book
1099: and fads.asset_id = X_asset_id
1100: and fads.deprn_source_code = 'BOOKS'

Line 1338: from fa_deprn_summary

1334: h_deprn_run := 'N';
1335: begin
1336: select 'Y'
1337: into h_deprn_run
1338: from fa_deprn_summary
1339: where asset_id = dpr_in.asset_id
1340: and book_type_code = dpr_in.book
1341: and period_counter = fa_cache_pkg.fazcdp_record.period_counter --Bug#16045341
1342: and deprn_source_code = 'DEPRN';

Line 1352: from fa_deprn_summary

1348:
1349: if nvl(h_deprn_run,'X') = 'Y' then
1350: select system_deprn_amount
1351: into adj_amt
1352: from fa_deprn_summary
1353: where asset_id = dpr_in.asset_id
1354: and book_type_code = dpr_in.book
1355: and period_counter = dpr_row.period_ctr;
1356:

Line 1379: from fa_deprn_summary

1375: IF dpr_in.method_code = 'JP-STL-EXTND' THEN
1376: BEGIN
1377: SELECT COUNT(1)
1378: INTO h_count
1379: from fa_deprn_summary
1380: where book_type_code = dpr_in.book
1381: and asset_id = dpr_in.asset_id
1382: and period_counter = fa_cache_pkg.fazcdp_record.period_counter - 1;
1383: exception