APPS.FA_QUERY_BALANCES_PKG dependencies on FA_DEPRN_DETAIL

Line 469: -- Query from fa_deprn_detail.

465:
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:

Line 1425: -- from fa_deprn_detail for given distribution

1421:
1422: -----------------------------------------------------------------------
1423:
1424: -- Use this procedure to query detail-level information
1425: -- from fa_deprn_detail for given distribution
1426: -- in given period (or current period if 0)
1427:
1428:
1429: PROCEDURE QUERY_DEPRN_DETAIL (

Line 1562: FROM FA_DEPRN_DETAIL DD

1558: NULL, 1,
1559: 0),
1560: NVL(CAPITAL_ADJUSTMENT,0), -- Bug 6666666
1561: NVL(GENERAL_FUND,0) -- Bug 6666666
1562: FROM FA_DEPRN_DETAIL DD
1563: WHERE DD.ASSET_ID = X_dpr_row.asset_id
1564: AND DD.BOOK_TYPE_CODE = X_dpr_row.book
1565: AND DD.PERIOD_COUNTER <= h_period_counter
1566: AND DD.DISTRIBUTION_ID = X_dpr_row.dist_id