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 210: /* bug#2448122 -- Treate FA_DEPRN_TAX_REP_NBVS */

206:
207: /* bug#2433829 -- Supported Rate chenges */ -- Obsolete
208:
209: --
210: /* bug#2448122 -- Treate FA_DEPRN_TAX_REP_NBVS */
211:
212: CURSOR c_last_update
213: (
214: p_asset_id NUMBER,

Line 223: FROM FA_DEPRN_TAX_REP_NBVS dtn

219: SELECT cost,
220: tax_asset_type,
221: units_assigned,
222: life
223: FROM FA_DEPRN_TAX_REP_NBVS dtn
224: WHERE dtn.asset_id = p_asset_id
225: AND dtn.book_type_code = p_book_type_code
226: AND dtn.state = p_state
227: AND dtn.year = p_year -1;

Line 242: FROM FA_DEPRN_TAX_REP_NBVS dtn

238: theoretical_nbv,
239: evaluated_nbv,
240: year,
241: units_assigned
242: FROM FA_DEPRN_TAX_REP_NBVS dtn
243: WHERE dtn.asset_id = p_asset_id
244: AND dtn.book_type_code = p_book_type_code
245: AND dtn.state = p_state
246: AND dtn.year = p_year;

Line 297: FROM FA_DEPRN_TAX_REP_NBVS dtn

293: sum(dtn.evaluated_nbv),
294: sum(dtn.theoretical_nbv),
295: sum(dtn.units_assigned), -- bug#2661575
296: dtn.year
297: FROM FA_DEPRN_TAX_REP_NBVS dtn
298: WHERE asset_id = p_asset_id
299: AND book_type_code = p_book_type_code
300: AND year =
301: (SELECT MAX(year) FROM fa_deprn_tax_rep_nbvs dtn2

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

297: FROM FA_DEPRN_TAX_REP_NBVS dtn
298: WHERE asset_id = p_asset_id
299: AND book_type_code = p_book_type_code
300: AND year =
301: (SELECT MAX(year) FROM fa_deprn_tax_rep_nbvs dtn2
302: WHERE dtn2.asset_id = p_asset_id
303: AND dtn2.book_type_code = p_book_type_code
304: AND dtn2.year < p_year)
305: group by dtn.year;

Line 402: from FA_DEPRN_TAX_REP_NBVS

398: cursor c_sum_nbvs_cost(p_asset_id number,
399: p_book varchar2,
400: p_year number) is
401: SELECT SUM(cost),asset_id
402: from FA_DEPRN_TAX_REP_NBVS
403: where book_type_code = p_book
404: and asset_id = p_asset_id
405: and year = p_year
406: group by asset_id;

Line 805: ' , FA_DEPRN_TAX_REP_NBVS NBV

801: FA_METHODS MTH
802: ';
803:
804: l_from_stmt_ba2 :=
805: ' , FA_DEPRN_TAX_REP_NBVS NBV
806: ';
807:
808: l_sm_where :=
809: ' where

Line 892: FA_DEPRN_TAX_REP_NBVS NBV

888: FA_BOOKS BK,
889: FA_ASSET_HISTORY AH,
890: FA_CATEGORIES CAT,
891: FA_METHODS MTH,
892: FA_DEPRN_TAX_REP_NBVS NBV
893: ';
894:
895: l_nbv_where :=
896: ' where

Line 1027: from FA_DEPRN_TAX_REP_NBVS NBVS

1023: and max(nvl(TH_AH2.TRANSACTION_DATE_ENTERED, :p_prior_date+1)) > :p_prior_date
1024: group by BK.ASSET_ID
1025: UNION
1026: select distinct asset_id
1027: from FA_DEPRN_TAX_REP_NBVS NBVS
1028: where NBVS.BOOK_TYPE_CODE = :p_book
1029: and NBVS.STATE between :p_state_from and :p_state_to
1030: and NBVS.YEAR = :p_year - 1
1031: ';

Line 1319: from FA_DEPRN_TAX_REP_NBVS

1315:
1316: -- Check the values of theoretical nbv and evaluated nbv on all states
1317: select count(*),count(theoretical_nbv),count(evaluated_nbv)
1318: into l_chk_nbv_total,l_chk_theoretical_nbv,l_chk_evaluated_nbv
1319: from FA_DEPRN_TAX_REP_NBVS
1320: where asset_id = l_asset_id
1321: and book_type_code = h_book
1322: and year = h_year -1;
1323:

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

1326: elsif (nvl(l_chk_theoretical_nbv,0) <> 0 and nvl(l_chk_nbv_total,0) <> nvl(l_chk_theoretical_nbv,0)) then
1327: RAISE BOTH_NBV_ERROR;
1328: end if; -- End of check the values of theoretical nbv and evaluated nbv
1329:
1330: -- Delete the data parameter's year on FA_DEPRN_TAX_REP_NBVS to refresh data
1331: delete from FA_DEPRN_TAX_REP_NBVS
1332: where asset_id = l_asset_id
1333: and book_type_code = h_book
1334: and year = h_year;

Line 1331: delete from FA_DEPRN_TAX_REP_NBVS

1327: RAISE BOTH_NBV_ERROR;
1328: end if; -- End of check the values of theoretical nbv and evaluated nbv
1329:
1330: -- Delete the data parameter's year on FA_DEPRN_TAX_REP_NBVS to refresh data
1331: delete from FA_DEPRN_TAX_REP_NBVS
1332: where asset_id = l_asset_id
1333: and book_type_code = h_book
1334: and year = h_year;
1335:

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

2148: END IF;
2149:
2150: -- bug#2629893
2151: -- For FA_DEPRN_TAX_REP_ITF, insert and update date for state ranages.
2152: -- For FA_DEPRN_TAX_REP_NBVS, insert and update date for all states.
2153:
2154: Insert into FA_DEPRN_TAX_REP_ITF (
2155: REQUEST_ID,
2156: YEAR,

Line 2276: -- UPDATE FA_DEPRN_TAX_REP_NBVS

2272: -- FETCH c_chk_nbv INTO h_chk_nbv_flag;
2273: --
2274: IF h_end_cost >0 then
2275: -- IF c_chk_nbv%found then
2276: -- UPDATE FA_DEPRN_TAX_REP_NBVS
2277: -- SET cost = h_end_cost,
2278: -- theoretical_nbv = h_store_theoretical_nbv,
2279: -- evaluated_nbv = h_store_evaluated_nbv,
2280: -- tax_asset_type = h_tax_asset_type,

Line 2293: SELECT FA.FA_DEPRN_TAX_REP_NBVS_S.NEXTVAL

2289: -- AND year = h_year
2290: -- ;
2291: -- fa_rx_util_pkg.debug ('Updated - asset id:'||h_asset_id||', state: '||h_state||' to NBV table.');
2292: -- ELSE
2293: SELECT FA.FA_DEPRN_TAX_REP_NBVS_S.NEXTVAL
2294: INTO h_deprn_tax_rep_nbv_id
2295: FROM dual;
2296:
2297: INSERT INTO FA_DEPRN_TAX_REP_NBVS

Line 2297: INSERT INTO FA_DEPRN_TAX_REP_NBVS

2293: SELECT FA.FA_DEPRN_TAX_REP_NBVS_S.NEXTVAL
2294: INTO h_deprn_tax_rep_nbv_id
2295: FROM dual;
2296:
2297: INSERT INTO FA_DEPRN_TAX_REP_NBVS
2298: (
2299: deprn_tax_rep_nbv_id,
2300: asset_id,
2301: book_type_code,