APPS.FA_QUERY_BALANCES_PKG dependencies on FA_DEPRN_SUMMARY

Line 459: -- If dist_id is 0, then query at summary level: fa_deprn_summary.

455: if h_count=0 then raise bad_trx_id; end if;
456:
457: -- If dist_id is given, then query that distribution only...
458: -- Query from fa_deprn_detail.
459: -- If dist_id is 0, then query at summary level: fa_deprn_summary.
460:
461: if (X_dpr_row.dist_id <> 0) then
462:
463: h_mrc_sob_type_code := X_dpr_row.mrc_sob_type_code;

Line 726: -- from fa_deprn_summary in given period (or current period if 0)

722:
723: -------------------------------------------------------------------------------------
724:
725: -- Use this procedure to query summary-level information
726: -- from fa_deprn_summary in given period (or current period if 0)
727:
728:
729: PROCEDURE QUERY_DEPRN_SUMMARY (
730: X_DPR_ROW IN OUT NOCOPY FA_STD_TYPES.FA_DEPRN_ROW_STRUCT,

Line 802: FROM FA_DEPRN_SUMMARY_MRC_V DS

798: DEPRN_SOURCE_CODE,
799: 0,
800: NVL(PRIOR_FY_EXPENSE, 0),
801: NVL(PRIOR_FY_BONUS_EXPENSE, 0)
802: FROM FA_DEPRN_SUMMARY_MRC_V DS
803: WHERE DS.ASSET_ID = X_dpr_row.asset_id
804: AND DS.BOOK_TYPE_CODE = X_dpr_row.book
805: AND DS.PERIOD_COUNTER <= h_period_counter
806: ORDER BY PERIOD_COUNTER DESC;

Line 856: FROM FA_DEPRN_SUMMARY DS

852: DEPRN_SOURCE_CODE,
853: 0,
854: NVL(PRIOR_FY_EXPENSE, 0),
855: NVL(PRIOR_FY_BONUS_EXPENSE, 0)
856: FROM FA_DEPRN_SUMMARY DS
857: WHERE DS.ASSET_ID = X_dpr_row.asset_id
858: AND DS.BOOK_TYPE_CODE = X_dpr_row.book
859: AND DS.PERIOD_COUNTER <= h_period_counter
860: ORDER BY PERIOD_COUNTER DESC;

Line 911: FROM FA_DEPRN_SUMMARY_MRC_V DS

907: 'DEPRN' DEPRN_SOURCE_CODE,
908: 0,
909: sum(NVL(PRIOR_FY_EXPENSE, 0)),
910: sum(NVL(PRIOR_FY_BONUS_EXPENSE, 0))
911: FROM FA_DEPRN_SUMMARY_MRC_V DS
912: WHERE DS.ASSET_ID in (select bk.asset_id
913: from fa_books bk
914: where bk.book_type_code = x_dpr_row.book
915: and bk.transaction_header_id_out is null

Line 970: FROM FA_DEPRN_SUMMARY DS

966: 'DEPRN' DEPRN_SOURCE_CODE,
967: 0,
968: sum(NVL(PRIOR_FY_EXPENSE, 0)),
969: sum(NVL(PRIOR_FY_BONUS_EXPENSE, 0))
970: FROM FA_DEPRN_SUMMARY DS
971: WHERE DS.ASSET_ID in (select bk.asset_id
972: from fa_books bk
973: where bk.book_type_code = x_dpr_row.book
974: and bk.transaction_header_id_out is null

Line 1143: -- If no fa_deprn_summary row exists, then return all zeroes.

1139: X_dpr_row.add_cost_to_clear,
1140: X_dpr_row.prior_fy_exp,
1141: X_dpr_row.prior_fy_bonus_exp;
1142:
1143: -- If no fa_deprn_summary row exists, then return all zeroes.
1144:
1145: if (GET_DM%NOTFOUND) then
1146:
1147: X_dpr_row.cost := 0;

Line 1252: -- If no fa_deprn_summary row exists, then return all zeroes.

1248: X_dpr_row.add_cost_to_clear,
1249: X_dpr_row.prior_fy_exp,
1250: X_dpr_row.prior_fy_bonus_exp;
1251:
1252: -- If no fa_deprn_summary row exists, then return all zeroes.
1253:
1254: if (GET_DS%NOTFOUND) then
1255:
1256: X_dpr_row.cost := 0;

Line 1558: -- If no fa_deprn_summary row exists, then return all zeroes.

1554: X_found_per_ctr,
1555: X_dpr_row.add_cost_to_clear,
1556: h_is_acc_null_num;
1557:
1558: -- If no fa_deprn_summary row exists, then return all zeroes.
1559:
1560: if (GET_MC_DD%NOTFOUND) then
1561: X_dpr_row.cost := 0;
1562: X_dpr_row.deprn_rsv := 0;

Line 1594: -- If no fa_deprn_summary row exists, then return all zeroes.

1590: X_found_per_ctr,
1591: X_dpr_row.add_cost_to_clear,
1592: h_is_acc_null_num;
1593:
1594: -- If no fa_deprn_summary row exists, then return all zeroes.
1595:
1596: if (GET_DD%NOTFOUND) then
1597: X_dpr_row.cost := 0;
1598: X_dpr_row.deprn_rsv := 0;