eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_DEPRN_TAX_REP_PKG dependencies on FA_DEPRN_TAX_REP_NBVS

Line 219: /* bug#2448122 -- Treate FA_DEPRN_TAX_REP_NBVS */

215:
216: /* bug#2433829 -- Supported Rate chenges */ -- Obsolete
217:
218: --
219: /* bug#2448122 -- Treate FA_DEPRN_TAX_REP_NBVS */
220:
221: CURSOR c_last_update
222: (
223: p_asset_id NUMBER,

Line 232: FROM FA_DEPRN_TAX_REP_NBVS dtn

228: SELECT cost,
229: tax_asset_type,
230: units_assigned,
231: life
232: FROM FA_DEPRN_TAX_REP_NBVS dtn
233: WHERE dtn.asset_id = p_asset_id
234: AND dtn.book_type_code = p_book_type_code
235: AND dtn.state = p_state
236: AND dtn.year = p_year -1;

Line 251: FROM FA_DEPRN_TAX_REP_NBVS dtn

247: theoretical_nbv,
248: evaluated_nbv,
249: year,
250: units_assigned
251: FROM FA_DEPRN_TAX_REP_NBVS dtn
252: WHERE dtn.asset_id = p_asset_id
253: AND dtn.book_type_code = p_book_type_code
254: AND dtn.state = p_state
255: AND dtn.year = p_year;

Line 306: FROM FA_DEPRN_TAX_REP_NBVS dtn

302: sum(dtn.evaluated_nbv),
303: sum(dtn.theoretical_nbv),
304: sum(dtn.units_assigned), -- bug#2661575
305: dtn.year
306: FROM FA_DEPRN_TAX_REP_NBVS dtn
307: WHERE asset_id = p_asset_id
308: AND book_type_code = p_book_type_code
309: AND year =
310: (SELECT MAX(year) FROM fa_deprn_tax_rep_nbvs dtn2

Line 310: (SELECT MAX(year) FROM fa_deprn_tax_rep_nbvs dtn2

306: FROM FA_DEPRN_TAX_REP_NBVS dtn
307: WHERE asset_id = p_asset_id
308: AND book_type_code = p_book_type_code
309: AND year =
310: (SELECT MAX(year) FROM fa_deprn_tax_rep_nbvs dtn2
311: WHERE dtn2.asset_id = p_asset_id
312: AND dtn2.book_type_code = p_book_type_code
313: AND dtn2.year < p_year)
314: group by dtn.year;

Line 411: from FA_DEPRN_TAX_REP_NBVS

407: cursor c_sum_nbvs_cost(p_asset_id number,
408: p_book varchar2,
409: p_year number) is
410: SELECT SUM(cost),asset_id
411: from FA_DEPRN_TAX_REP_NBVS
412: where book_type_code = p_book
413: and asset_id = p_asset_id
414: and year = p_year
415: group by asset_id;

Line 866: ' , FA_DEPRN_TAX_REP_NBVS NBV

862: FA_METHODS MTH
863: ';
864:
865: l_from_stmt_ba2 :=
866: ' , FA_DEPRN_TAX_REP_NBVS NBV
867: ';
868: -- bug 12401201 added not exist condition below so that any transaction which becomes effective before target
869: -- and ineffective before target date is not picked
870:

Line 967: FA_DEPRN_TAX_REP_NBVS NBV

963: FA_BOOKS BK,
964: FA_ASSET_HISTORY AH,
965: FA_CATEGORIES CAT,
966: FA_METHODS MTH,
967: FA_DEPRN_TAX_REP_NBVS NBV
968: ';
969:
970: l_nbv_where :=
971: ' where

Line 1102: from FA_DEPRN_TAX_REP_NBVS NBVS

1098: and max(nvl(TH_AH2.TRANSACTION_DATE_ENTERED, :p_prior_date+1)) > :p_prior_date
1099: group by BK.ASSET_ID
1100: UNION
1101: select distinct asset_id
1102: from FA_DEPRN_TAX_REP_NBVS NBVS
1103: where NBVS.BOOK_TYPE_CODE = :p_book
1104: and NBVS.STATE between :p_state_from and :p_state_to
1105: and NBVS.YEAR = :p_year - 1
1106: ';

Line 1397: from FA_DEPRN_TAX_REP_NBVS

1393:
1394: -- Check the values of theoretical nbv and evaluated nbv on all states
1395: select count(*),count(theoretical_nbv),count(evaluated_nbv)
1396: into l_chk_nbv_total,l_chk_theoretical_nbv,l_chk_evaluated_nbv
1397: from FA_DEPRN_TAX_REP_NBVS
1398: where asset_id = l_asset_id
1399: and book_type_code = h_book
1400: and year = h_year -1;
1401:

Line 1408: -- Delete the data parameter's year on FA_DEPRN_TAX_REP_NBVS to refresh data

1404: elsif (nvl(l_chk_theoretical_nbv,0) <> 0 and nvl(l_chk_nbv_total,0) <> nvl(l_chk_theoretical_nbv,0)) then
1405: RAISE BOTH_NBV_ERROR;
1406: end if; -- End of check the values of theoretical nbv and evaluated nbv
1407:
1408: -- Delete the data parameter's year on FA_DEPRN_TAX_REP_NBVS to refresh data
1409: delete from FA_DEPRN_TAX_REP_NBVS
1410: where asset_id = l_asset_id
1411: and book_type_code = h_book
1412: and year = h_year;

Line 1409: delete from FA_DEPRN_TAX_REP_NBVS

1405: RAISE BOTH_NBV_ERROR;
1406: end if; -- End of check the values of theoretical nbv and evaluated nbv
1407:
1408: -- Delete the data parameter's year on FA_DEPRN_TAX_REP_NBVS to refresh data
1409: delete from FA_DEPRN_TAX_REP_NBVS
1410: where asset_id = l_asset_id
1411: and book_type_code = h_book
1412: and year = h_year;
1413:

Line 2274: -- For FA_DEPRN_TAX_REP_NBVS, insert and update date for all states.

2270: END IF;
2271:
2272: -- bug#2629893
2273: -- For FA_DEPRN_TAX_REP_ITF, insert and update date for state ranages.
2274: -- For FA_DEPRN_TAX_REP_NBVS, insert and update date for all states.
2275:
2276: --Start for 9935602
2277:
2278: l_match_found := 0;

Line 2431: -- UPDATE FA_DEPRN_TAX_REP_NBVS

2427: -- FETCH c_chk_nbv INTO h_chk_nbv_flag;
2428: --
2429: IF h_end_cost >0 then
2430: -- IF c_chk_nbv%found then
2431: -- UPDATE FA_DEPRN_TAX_REP_NBVS
2432: -- SET cost = h_end_cost,
2433: -- theoretical_nbv = h_store_theoretical_nbv,
2434: -- evaluated_nbv = h_store_evaluated_nbv,
2435: -- tax_asset_type = h_tax_asset_type,

Line 2448: SELECT FA_DEPRN_TAX_REP_NBVS_S.NEXTVAL

2444: -- AND year = h_year
2445: -- ;
2446: -- fa_rx_util_pkg.debug ('Updated - asset id:'||h_asset_id||', state: '||h_state||' to NBV table.');
2447: -- ELSE
2448: SELECT FA_DEPRN_TAX_REP_NBVS_S.NEXTVAL
2449: INTO h_deprn_tax_rep_nbv_id
2450: FROM dual;
2451:
2452: INSERT INTO FA_DEPRN_TAX_REP_NBVS

Line 2452: INSERT INTO FA_DEPRN_TAX_REP_NBVS

2448: SELECT FA_DEPRN_TAX_REP_NBVS_S.NEXTVAL
2449: INTO h_deprn_tax_rep_nbv_id
2450: FROM dual;
2451:
2452: INSERT INTO FA_DEPRN_TAX_REP_NBVS
2453: (
2454: deprn_tax_rep_nbv_id,
2455: asset_id,
2456: book_type_code,