APPS.FA_DEPRN_TAX_REP_PKG dependencies on FA_BOOKS

Line 318: FA_BOOKS BK

314: is
315: select AH.UNITS,
316: bk.cost
317: from FA_ASSET_HISTORY AH,
318: FA_BOOKS BK
319: Where AH.ASSET_ID = p_asset_id
320: and AH.ASSET_ID = BK.ASSET_ID
321: and BK.BOOK_TYPE_CODE = p_book_type_code
322: and AH.DATE_EFFECTIVE =

Line 336: from FA_BOOKS bk ,

332: > p_target_date
333: )
334: and bk.date_effective =
335: (SELECT MAX(bk.date_effective)
336: from FA_BOOKS bk ,
337: FA_TRANSACTION_HEADERS TH1,
338: FA_TRANSACTION_HEADERS TH2
339: where bk.asset_id= p_asset_id
340: and bk.book_type_code= p_book_type_code

Line 372: from FA_BOOKS bk ,

368: cursor c_bk_max_date_effective(p_asset_id number,
369: p_book varchar2,
370: p_prior_date date) is
371: SELECT MAX(bk.date_effective)
372: from FA_BOOKS bk ,
373: FA_TRANSACTION_HEADERS TH1,
374: FA_TRANSACTION_HEADERS TH2
375: where bk.asset_id= p_asset_id
376: and bk.book_type_code= p_book

Line 417: from FA_BOOKS bk

413: cursor c_bk_max_thid_in(p_asset_id number,
414: p_book varchar2,
415: p_date_effective date) is
416: SELECT MAX(bk.transaction_header_id_in)
417: from FA_BOOKS bk
418: where bk.asset_id= p_asset_id
419: and bk.book_type_code= p_book
420: and bk.date_effective = p_date_effective;
421:

Line 606: |--------------|FA_BOOKS(BK) |------------|FA_METHODS (MTH) |

602: | | |-|FA_TRANSACTION_HEADERS (THA2
603: ,p_log_level_rec => p_log_level_rec)|
604: | | +-----------------------------+
605: | +-------------+ +-----------------------------+
606: |--------------|FA_BOOKS(BK) |------------|FA_METHODS (MTH) |
607: +-------------+ | +-----------------------------+
608: | +-----------------------------+
609: |------|FA_TRANSACTION_HEADERS (THB1)|
610: | +-----------------------------+

Line 790: FA_BOOKS BK,

786:
787: l_from_stmt :=
788: ' From
789: FA_ADDITIONS AD,
790: FA_BOOKS BK,
791: FA_DISTRIBUTION_HISTORY DH,
792: FA_ASSET_HISTORY AH,
793: FA_TRANSACTION_HEADERS THA1,
794: FA_TRANSACTION_HEADERS THA2,

Line 888: FA_BOOKS BK,

884:
885: l_from_nbv :=
886: 'From
887: FA_ADDITIONS AD,
888: FA_BOOKS BK,
889: FA_ASSET_HISTORY AH,
890: FA_CATEGORIES CAT,
891: FA_METHODS MTH,
892: FA_DEPRN_TAX_REP_NBVS NBV

Line 985: From FA_BOOKS BK,

981: /* Changed sub_sql to check the state range */
982: l_sub_sql :=
983: 'Select distinct
984: BK.ASSET_ID
985: From FA_BOOKS BK,
986: FA_ADDITIONS AD,
987: FA_DISTRIBUTION_HISTORY DH,
988: FA_ASSET_HISTORY AH,
989: FA_LOCATIONS LOC,

Line 1354: -- Set asset cost and Units from FA_BOOKS at prior date

1350: fetch c_total_units_cost into l_total_prior_units, l_total_prior_cost;
1351: close c_total_units_cost;
1352:
1353: /*
1354: -- Set asset cost and Units from FA_BOOKS at prior date
1355: l_total_prior_cost := h_prior_total_cost;
1356: l_total_prior_units := h_prior_total_units;
1357:
1358: -- Set asset cost from FA_BOOKS at target date

Line 1358: -- Set asset cost from FA_BOOKS at target date

1354: -- Set asset cost and Units from FA_BOOKS at prior date
1355: l_total_prior_cost := h_prior_total_cost;
1356: l_total_prior_units := h_prior_total_units;
1357:
1358: -- Set asset cost from FA_BOOKS at target date
1359: l_total_cost := h_total_cost;
1360: l_total_units := h_total_units;
1361: */
1362: