APPS.FA_QUERY_BALANCES_PKG dependencies on FA_DEPRN_SUMMARY

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

466: if h_count=0 then raise bad_trx_id; end if;
467:
468: -- If dist_id is given, then query that distribution only...
469: -- Query from fa_deprn_detail.
470: -- If dist_id is 0, then query at summary level: fa_deprn_summary.
471:
472: if (X_dpr_row.dist_id <> 0) then
473:
474: QUERY_DEPRN_DETAIL

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

709:
710: -------------------------------------------------------------------------------------
711:
712: -- Use this procedure to query summary-level information
713: -- from fa_deprn_summary in given period (or current period if 0)
714:
715:
716: PROCEDURE QUERY_DEPRN_SUMMARY (
717: X_DPR_ROW IN OUT NOCOPY FA_STD_TYPES.FA_DEPRN_ROW_STRUCT,

Line 872: FROM FA_DEPRN_SUMMARY DS

868: NVL(PRIOR_FY_BONUS_EXPENSE, 0),
869: NVL(CAPITAL_ADJUSTMENT,0), --Bug 6666666
870: NVL(GENERAL_FUND,0), --Bug 6666666
871: NVL(REVAL_LOSS_BALANCE,0)
872: FROM FA_DEPRN_SUMMARY DS
873: WHERE DS.ASSET_ID = X_dpr_row.asset_id
874: AND DS.BOOK_TYPE_CODE = X_dpr_row.book
875: AND DS.PERIOD_COUNTER <= h_period_counter
876: ORDER BY PERIOD_COUNTER DESC;

Line 1011: FROM FA_DEPRN_SUMMARY DS

1007: sum(NVL(PRIOR_FY_EXPENSE, 0)),
1008: sum(NVL(PRIOR_FY_BONUS_EXPENSE, 0)),
1009: sum(NVL(CAPITAL_ADJUSTMENT,0)), --Bug 6666666
1010: sum(NVL(GENERAL_FUND,0)) --Bug 6666666
1011: FROM FA_DEPRN_SUMMARY DS
1012: WHERE DS.ASSET_ID in (select bk.asset_id
1013: from fa_books bk
1014: where bk.book_type_code = x_dpr_row.book
1015: and bk.transaction_header_id_out is null

Line 1019: AND DS.PERIOD_COUNTER = ( select max(period_counter) from fa_deprn_summary

1015: and bk.transaction_header_id_out is null
1016: and bk.group_asset_id = x_dpr_row.asset_id)
1017: AND DS.BOOK_TYPE_CODE = X_dpr_row.book
1018: -- Bug#6350172: Modified query to fetch correct reserve values
1019: AND DS.PERIOD_COUNTER = ( select max(period_counter) from fa_deprn_summary
1020: where asset_id = ds.asset_id and book_type_code = X_dpr_row.book );
1021:
1022:
1023: BEGIN

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

1195: X_dpr_row.capital_adjustment, -- Bug 6666666
1196: X_dpr_row.general_fund; -- Bug 6666666
1197:
1198:
1199: -- If no fa_deprn_summary row exists, then return all zeroes.
1200:
1201: if (GET_DM%NOTFOUND) then
1202:
1203: X_dpr_row.cost := 0;

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

1326: X_dpr_row.capital_adjustment, -- Bug 6666666
1327: X_dpr_row.general_fund, -- Bug 6666666
1328: X_dpr_row.reval_loss_balance;
1329:
1330: -- If no fa_deprn_summary row exists, then return all zeroes.
1331:
1332: if (GET_DS%NOTFOUND) then
1333:
1334: X_dpr_row.cost := 0;

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

1657: h_is_acc_null_num,
1658: X_dpr_row.capital_adjustment, -- Bug 6666666
1659: X_dpr_row.general_fund; -- Bug 6666666
1660:
1661: -- If no fa_deprn_summary row exists, then return all zeroes.
1662:
1663: if (GET_MC_DD%NOTFOUND) then
1664: X_dpr_row.cost := 0;
1665: X_dpr_row.deprn_rsv := 0;

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

1703: h_is_acc_null_num,
1704: X_dpr_row.capital_adjustment, -- Bug 6666666
1705: X_dpr_row.general_fund; -- Bug 6666666
1706:
1707: -- If no fa_deprn_summary row exists, then return all zeroes.
1708:
1709: if (GET_DD%NOTFOUND) then
1710: X_dpr_row.cost := 0;
1711: X_dpr_row.deprn_rsv := 0;