APPS.FA_QUERY_BALANCES_PKG dependencies on FA_DEPRN_DETAIL

Line 458: -- Query from fa_deprn_detail.

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

Line 1348: -- from fa_deprn_detail for given distribution

1344:
1345: -----------------------------------------------------------------------
1346:
1347: -- Use this procedure to query detail-level information
1348: -- from fa_deprn_detail for given distribution
1349: -- in given period (or current period if 0)
1350:
1351:
1352: PROCEDURE QUERY_DEPRN_DETAIL (

Line 1418: FROM FA_DEPRN_DETAIL_MRC_V DD

1414: NVL(ADDITION_COST_TO_CLEAR, 0),
1415: DECODE(ADDITION_COST_TO_CLEAR,
1416: NULL, 1,
1417: 0)
1418: FROM FA_DEPRN_DETAIL_MRC_V DD
1419: WHERE DD.ASSET_ID = X_dpr_row.asset_id
1420: AND DD.BOOK_TYPE_CODE = X_dpr_row.book
1421: AND DD.PERIOD_COUNTER <= h_period_counter
1422: AND DD.DISTRIBUTION_ID = X_dpr_row.dist_id

Line 1464: FROM FA_DEPRN_DETAIL DD

1460: NVL(ADDITION_COST_TO_CLEAR, 0),
1461: DECODE(ADDITION_COST_TO_CLEAR,
1462: NULL, 1,
1463: 0)
1464: FROM FA_DEPRN_DETAIL DD
1465: WHERE DD.ASSET_ID = X_dpr_row.asset_id
1466: AND DD.BOOK_TYPE_CODE = X_dpr_row.book
1467: AND DD.PERIOD_COUNTER <= h_period_counter
1468: AND DD.DISTRIBUTION_ID = X_dpr_row.dist_id