[Home] [Help]
1480: , th.transaction_type_code
1481: , th.transaction_subtype
1482: , th.transaction_key
1483: , bs.period_counter
1484: from fa_transaction_headers th
1485: , fa_books_summary bs
1486: , fa_transaction_headers mth
1487: , fa_books bk
1488: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id
1482: , th.transaction_key
1483: , bs.period_counter
1484: from fa_transaction_headers th
1485: , fa_books_summary bs
1486: , fa_transaction_headers mth
1487: , fa_books bk
1488: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id
1489: and th.asset_id = mth.asset_id
1490: and th.book_type_code = p_asset_hdr_rec.book_type_code
1514: , mth.transaction_subtype
1515: , mth.transaction_key
1516: , bs.period_counter
1517: from fa_books_summary bs
1518: , fa_transaction_headers mth
1519: , fa_books bk
1520: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id
1521: and bs.asset_id = p_group_asset_id
1522: and bs.book_type_code = p_asset_hdr_rec.book_type_code
1592: , inbk.allowed_deprn_limit
1593: , outbk.allowed_deprn_limit
1594: from fa_books inbk,
1595: fa_books outbk
1596: , fa_transaction_headers mth
1597: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id
1598: and inbk.asset_id = mth.asset_id
1599: and outbk.asset_id(+) = inbk.asset_id
1600: and inbk.book_type_code = p_asset_hdr_rec.book_type_code
1627: , inbk.allowed_deprn_limit
1628: , outbk.allowed_deprn_limit
1629: from fa_books_mrc_v inbk,
1630: fa_books_mrc_v outbk
1631: , fa_transaction_headers mth
1632: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id
1633: and inbk.asset_id = mth.asset_id
1634: and outbk.asset_id(+) = inbk.asset_id
1635: and inbk.book_type_code = p_asset_hdr_rec.book_type_code
2620: , -1 * ret.cost_of_removal
2621: , nvl(ret.reserve_retired, 0)
2622: , nbv_retired
2623: from fa_retirements ret
2624: , fa_transaction_headers mth
2625: where mth.transaction_header_id = c_transaction_header_id
2626: and mth.asset_id = ret.asset_id
2627: and mth.book_type_code = p_asset_hdr_rec.book_type_code
2628: and ret.book_type_code = p_asset_hdr_rec.book_type_code
2633: , -1 * ret.cost_of_removal
2634: , nvl(ret.reserve_retired, 0)
2635: , nbv_retired
2636: from fa_retirements_mrc_v ret
2637: , fa_transaction_headers mth
2638: where mth.transaction_header_id = c_transaction_header_id
2639: and mth.asset_id = ret.asset_id
2640: and mth.book_type_code = p_asset_hdr_rec.book_type_code
2641: and ret.book_type_code = p_asset_hdr_rec.book_type_code
3368: , -1 * ret.cost_of_removal
3369: , ret.reserve_retired
3370: , nbv_retired
3371: from fa_retirements ret
3372: , fa_transaction_headers mth
3373: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id
3374: and mth.asset_id = ret.asset_id
3375: and mth.book_type_code = p_asset_hdr_rec.book_type_code
3376: and ret.book_type_code = p_asset_hdr_rec.book_type_code
3381: , -1 * ret.cost_of_removal
3382: , nvl(ret.reserve_retired, 0)
3383: , nbv_retired
3384: from fa_retirements_mrc_v ret
3385: , fa_transaction_headers mth
3386: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id
3387: and mth.asset_id = ret.asset_id
3388: and mth.book_type_code = p_asset_hdr_rec.book_type_code
3389: and ret.book_type_code = p_asset_hdr_rec.book_type_code
7624: 'CR', -1 * ADJ.ADJUSTMENT_AMOUNT)
7625: )),
7626: 0)
7627: FROM FA_ADJUSTMENTS ADJ,
7628: FA_TRANSACTION_HEADERS TH
7629: WHERE TH.ASSET_ID = p_asset_hdr_rec.asset_id
7630: AND TH.BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
7631: AND TH.TRANSACTION_HEADER_ID <> p_trans_rec.transaction_header_id
7632: AND TH.TRANSACTION_DATE_ENTERED <= p_trans_rec.transaction_date_entered
7711: 'CR', -1 * ADJ.ADJUSTMENT_AMOUNT)
7712: )),
7713: 0)
7714: FROM FA_ADJUSTMENTS_MRC_V ADJ,
7715: FA_TRANSACTION_HEADERS TH
7716: WHERE TH.ASSET_ID = p_asset_hdr_rec.asset_id
7717: AND TH.BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
7718: AND TH.TRANSACTION_HEADER_ID <> p_trans_rec.transaction_header_id
7719: AND TH.TRANSACTION_DATE_ENTERED <= p_trans_rec.transaction_date_entered
7979: nvl(th.amortization_start_date, th.transaction_date_entered) transaction_date_entered,
7980: th.date_effective date_effective,
7981: th.transaction_type_code transaction_type_code
7982: from
7983: fa_transaction_headers th,
7984: fa_deprn_periods dp,
7985: fa_book_controls bc,
7986: fa_fiscal_year fy
7987: where th.asset_id = p_asset_hdr_rec.asset_id
8018: CURSOR c_get_ret_trx IS
8019: select nvl(sum(ret.reserve_retired), 0),
8020: nvl(sum(ret.eofy_reserve), 0)
8021: from fa_retirements ret,
8022: fa_transaction_headers mth,
8023: fa_transaction_headers gth,
8024: fa_book_controls bc,
8025: fa_fiscal_year fy
8026: where gth.asset_id = p_asset_hdr_rec.asset_id
8019: select nvl(sum(ret.reserve_retired), 0),
8020: nvl(sum(ret.eofy_reserve), 0)
8021: from fa_retirements ret,
8022: fa_transaction_headers mth,
8023: fa_transaction_headers gth,
8024: fa_book_controls bc,
8025: fa_fiscal_year fy
8026: where gth.asset_id = p_asset_hdr_rec.asset_id
8027: and gth.book_type_code = p_asset_hdr_rec.book_type_code
8049: CURSOR c_get_mc_ret_trx IS
8050: select nvl(sum(ret.reserve_retired), 0),
8051: nvl(sum(ret.eofy_reserve), 0)
8052: from fa_retirements_mrc_v ret,
8053: fa_transaction_headers mth,
8054: fa_transaction_headers gth,
8055: fa_book_controls_mrc_v bc,
8056: fa_fiscal_year fy
8057: where gth.asset_id = p_asset_hdr_rec.asset_id
8050: select nvl(sum(ret.reserve_retired), 0),
8051: nvl(sum(ret.eofy_reserve), 0)
8052: from fa_retirements_mrc_v ret,
8053: fa_transaction_headers mth,
8054: fa_transaction_headers gth,
8055: fa_book_controls_mrc_v bc,
8056: fa_fiscal_year fy
8057: where gth.asset_id = p_asset_hdr_rec.asset_id
8058: and gth.book_type_code = p_asset_hdr_rec.book_type_code
8080: CURSOR c_get_ret_trx2 IS
8081: select nvl(sum(ret.reserve_retired), 0),
8082: nvl(sum(ret.eofy_reserve), 0)
8083: from fa_retirements ret,
8084: fa_transaction_headers th,
8085: fa_book_controls bc,
8086: fa_fiscal_year fy
8087: where th.asset_id = p_asset_hdr_rec.asset_id
8088: and th.book_type_code = p_asset_hdr_rec.book_type_code
8114: select th.transaction_header_id transaction_header_id,
8115: nvl(th.amortization_start_date, th.transaction_date_entered) transaction_date_entered,
8116: th.date_effective date_effective,
8117: th.transaction_type_code transaction_type_code
8118: from fa_transaction_headers th
8119: where th.asset_id = p_asset_hdr_rec.asset_id
8120: and th.book_type_code = p_asset_hdr_rec.book_type_code
8121: and th.transaction_header_id =
8122: -- Get the latest trasnaction of reclassed member asset on group asset
8120: and th.book_type_code = p_asset_hdr_rec.book_type_code
8121: and th.transaction_header_id =
8122: -- Get the latest trasnaction of reclassed member asset on group asset
8123: (select max(th.transaction_header_id)
8124: from fa_transaction_headers th
8125: where th.asset_id =p_asset_hdr_rec.asset_id
8126: and th.book_type_code = p_asset_hdr_rec.book_type_code
8127: and th.transaction_type_code not in (G_TRX_TYPE_TFR_OUT, G_TRX_TYPE_TFR_IN,
8128: G_TRX_TYPE_TFR, G_TRX_TYPE_TFR_VOID,
8130: G_TRX_TYPE_TFR_VOID)
8131: and th.transaction_header_id <
8132: -- Get first transaction of reclassed member asset on group asset
8133: (select min(th.transaction_header_id)
8134: from fa_transaction_headers th
8135: where th.book_type_code = p_asset_hdr_rec.book_type_code
8136: and th.asset_id = p_asset_hdr_rec.asset_id
8137: and th.member_transaction_header_id in
8138: -- Get reclassed member's all transaction headers
8136: and th.asset_id = p_asset_hdr_rec.asset_id
8137: and th.member_transaction_header_id in
8138: -- Get reclassed member's all transaction headers
8139: (select th.transaction_header_id
8140: from fa_transaction_headers th
8141: where th.book_type_code = p_asset_hdr_rec.book_type_code
8142: and th.asset_id in
8143: -- Get reclassed member's asset_id
8144: (select th.asset_id
8141: where th.book_type_code = p_asset_hdr_rec.book_type_code
8142: and th.asset_id in
8143: -- Get reclassed member's asset_id
8144: (select th.asset_id
8145: from fa_transaction_headers th
8146: where th.book_type_code = p_asset_hdr_rec.book_type_code
8147: and transaction_header_id in
8148: -- Get reclassed transaction after this transaction's fiscal year
8149: (select th.member_transaction_header_id
8146: where th.book_type_code = p_asset_hdr_rec.book_type_code
8147: and transaction_header_id in
8148: -- Get reclassed transaction after this transaction's fiscal year
8149: (select th.member_transaction_header_id
8150: from fa_transaction_headers th,
8151: fa_deprn_periods dp,
8152: fa_fiscal_year fy,
8153: fa_book_controls bc
8154: where th.asset_id = p_asset_hdr_rec.asset_id
8404: , decode(p_reclass_src_dest, 'SOURCE', -1, 1) * sum(inbk.unrevalued_cost - nvl(outbk.unrevalued_cost, 0))
8405: , decode(p_reclass_src_dest, 'SOURCE', -1, 1) * sum(nvl(inbk.allowed_deprn_limit_amount, 0) -
8406: nvl(outbk.allowed_deprn_limit_amount, 0))
8407: , decode(p_reclass_src_dest, 'SOURCE', -1, 1) * sum(nvl(inbk.cip_cost, 0) - nvl(outbk.cip_cost, 0))
8408: from fa_transaction_headers th,
8409: fa_books inbk,
8410: fa_books outbk
8411: where inbk.asset_id = p_asset_hdr_rec.asset_id
8412: and inbk.book_type_code = p_asset_hdr_rec.book_type_code
8423: and nvl(th.amortization_start_date,
8424: th.transaction_date_entered) <= p_transaction_date_entered
8425: and not exists(select 'Exclude This Retirement'
8426: from fa_retirements ret,
8427: fa_transaction_headers reith
8428: where ret.transaction_header_id_in = th.transaction_header_id
8429: and ret.transaction_header_id_out = reith.transaction_header_id
8430: and nvl(reith.amortization_start_date,
8431: reith.transaction_date_entered) <= p_transaction_date_entered)
8454: , decode(p_reclass_src_dest, 'SOURCE', -1, 1) * sum(inbk.unrevalued_cost - nvl(outbk.unrevalued_cost, 0))
8455: , decode(p_reclass_src_dest, 'SOURCE', -1, 1) * sum(nvl(inbk.allowed_deprn_limit_amount, 0) -
8456: nvl(outbk.allowed_deprn_limit_amount, 0))
8457: , decode(p_reclass_src_dest, 'SOURCE', -1, 1) * sum(nvl(inbk.cip_cost, 0) - nvl(outbk.cip_cost, 0))
8458: from fa_transaction_headers th,
8459: fa_books_mrc_v inbk,
8460: fa_books_mrc_v outbk
8461: where inbk.asset_id = p_asset_hdr_rec.asset_id
8462: and inbk.book_type_code = p_asset_hdr_rec.book_type_code
8473: and nvl(th.amortization_start_date,
8474: th.transaction_date_entered) <= p_transaction_date_entered
8475: and not exists(select 'Exclude This Retirement'
8476: from fa_retirements_mrc_v ret,
8477: fa_transaction_headers reith
8478: where ret.transaction_header_id_in = th.transaction_header_id
8479: and ret.transaction_header_id_out = reith.transaction_header_id
8480: and nvl(reith.amortization_start_date,
8481: reith.transaction_date_entered) <= p_transaction_date_entered)
8565: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8566: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type,
8567: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
8568: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8569: p_init_transaction_header_id FA_TRANSACTION_HEADERS.TRANSACTION_HEADER_ID%TYPE,
8570: p_use_fin_rec_adj BOOLEAN,
8571: p_use_new_deprn_rule BOOLEAN,
8572: p_process_this_trx BOOLEAN,
8573: x_dpis_change OUT NOCOPY BOOLEAN,
9749:
9750:
9751: CURSOR c_get_member_asset_id IS
9752: select asset_id
9753: from fa_transaction_headers
9754: where transaction_header_id = p_trans_rec.member_transaction_header_id;
9755:
9756: l_calling_fn VARCHAR2(100) := 'FA_AMORT_PVT.GetFinRec';
9757: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;
11211: CURSOR c_get_first_trx IS
11212: select th.transaction_header_id
11213: , nvl(th.amortization_start_date, th.transaction_date_entered)
11214: , th.date_effective
11215: from fa_transaction_headers th
11216: where th.asset_id = p_asset_hdr_rec.asset_id
11217: and th.book_type_code = p_asset_hdr_rec.book_type_code
11218: and th.transaction_header_id = (select min(th2.transaction_header_id)
11219: from fa_transaction_headers th2
11215: from fa_transaction_headers th
11216: where th.asset_id = p_asset_hdr_rec.asset_id
11217: and th.book_type_code = p_asset_hdr_rec.book_type_code
11218: and th.transaction_header_id = (select min(th2.transaction_header_id)
11219: from fa_transaction_headers th2
11220: where th2.asset_id = p_asset_hdr_rec.asset_id
11221: and th2.book_type_code = p_asset_hdr_rec.book_type_code);
11222:
11223: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
11259: nvl(th.amortization_start_date,th.transaction_date_entered)
11260: ) transaction_date_entered,
11261: th.date_effective date_effective,
11262: th.transaction_type_code transaction_type_code
11263: from fa_transaction_headers th
11264: , fa_deprn_periods dp
11265: where th.asset_id = p_asset_hdr_rec.asset_id
11266: and th.book_type_code = p_asset_hdr_rec.book_type_code
11267: and dp.book_type_code = p_asset_hdr_rec.book_type_code
11286: select ret.transaction_header_id transaction_header_id,
11287: ret.transaction_date_entered transaction_date_entered,
11288: ret.date_effective date_effective,
11289: ret.transaction_type_code transaction_type_code
11290: from fa_transaction_headers ret,
11291: fa_transaction_headers rei,
11292: fa_retirements faret
11293: where ret.asset_id = p_asset_hdr_rec.asset_id
11294: and rei.asset_id = p_asset_hdr_rec.asset_id
11287: ret.transaction_date_entered transaction_date_entered,
11288: ret.date_effective date_effective,
11289: ret.transaction_type_code transaction_type_code
11290: from fa_transaction_headers ret,
11291: fa_transaction_headers rei,
11292: fa_retirements faret
11293: where ret.asset_id = p_asset_hdr_rec.asset_id
11294: and rei.asset_id = p_asset_hdr_rec.asset_id
11295: and ret.book_type_code = p_asset_hdr_rec.book_type_code
11311: nvl(th.amortization_start_date,th.transaction_date_entered)
11312: ) transaction_date_entered,
11313: th.date_effective date_effective,
11314: th.transaction_type_code transaction_type_code
11315: from fa_transaction_headers th
11316: where th.asset_id = p_asset_hdr_rec.asset_id
11317: and th.book_type_code = p_asset_hdr_rec.book_type_code
11318: and th.transaction_type_code not in (G_TRX_TYPE_TFR_OUT, G_TRX_TYPE_TFR_IN,
11319: G_TRX_TYPE_TFR, G_TRX_TYPE_TFR_VOID,
11402: th.member_transaction_header_id member_transaction_header_id,
11403: th.trx_reference_id trx_reference_id,
11404: th.invoice_transaction_id,
11405: '1st SELECT in c_get_ths_adj'
11406: from fa_transaction_headers th,
11407: fa_books bk
11408: , fa_books outbk
11409: , fa_deprn_summary ds
11410: where th.asset_id = p_asset_hdr_rec.asset_id
11471: th.member_transaction_header_id member_transaction_header_id,
11472: th.trx_reference_id trx_reference_id,
11473: th.invoice_transaction_id,
11474: '2nd SELECT in c_get_ths_adj'
11475: from fa_transaction_headers th,
11476: fa_retirements ret,
11477: fa_conventions con,
11478: fa_calendar_periods cp,
11479: fa_calendar_periods cptrx
11546: CURSOR c_get_next_ths (c_transaction_date_entered date,
11547: c_date_effective date) IS
11548: select th.transaction_date_entered transaction_date_entered,
11549: th.date_effective date_effective
11550: from fa_transaction_headers th
11551: where th.asset_id = p_asset_hdr_rec.asset_id
11552: and th.book_type_code = p_asset_hdr_rec.book_type_code
11553: and th.transaction_date_entered >= c_transaction_date_entered
11554: and th.date_effective > c_date_effective
11553: and th.transaction_date_entered >= c_transaction_date_entered
11554: and th.date_effective > c_date_effective
11555: and (p_asset_type_rec.asset_type <> G_ASSET_TYPE_GROUP or
11556: not exists (select 'Y'
11557: from fa_transaction_headers mth,
11558: fa_books bk
11559: where mth.transaction_header_id = th.member_transaction_header_id
11560: and mth.book_type_code = p_asset_hdr_rec.book_type_code
11561: and bk.asset_id = mth.asset_id
11574: and p_trans_rec.transaction_date_entered >= c_transaction_date_entered
11575: and p_trans_rec.who_info.creation_date = c_date_effective
11576: and (p_asset_type_rec.asset_type <> G_ASSET_TYPE_GROUP or
11577: not exists (select 'Y'
11578: from fa_transaction_headers mth,
11579: fa_books bk
11580: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id
11581: and mth.book_type_code = p_asset_hdr_rec.book_type_code
11582: and bk.asset_id = mth.asset_id
11712: -- to member's dpis.
11713: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
11714: CURSOR c_get_init_thid IS
11715: select gth.transaction_header_id
11716: from fa_transaction_headers gth
11717: where gth.asset_id = p_asset_hdr_rec.asset_id
11718: and gth.book_type_code = p_asset_hdr_rec.book_type_code
11719: and gth.member_transaction_header_id =
11720: (select min(mth.transaction_header_id)
11717: where gth.asset_id = p_asset_hdr_rec.asset_id
11718: and gth.book_type_code = p_asset_hdr_rec.book_type_code
11719: and gth.member_transaction_header_id =
11720: (select min(mth.transaction_header_id)
11721: from fa_transaction_headers mth
11722: where mth.asset_id = p_reclassed_asset_id
11723: and mth.book_type_code = p_asset_hdr_rec.book_type_code);
11724:
11725: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
11730: nvl(th.amortization_start_date,
11731: th.transaction_date_entered) transaction_date_entered,
11732: th.date_effective date_effective,
11733: th.transaction_type_code transaction_type_code
11734: from fa_transaction_headers th
11735: where asset_id = p_asset_hdr_rec.asset_id
11736: and book_type_code = p_asset_hdr_rec.book_type_code
11737: and not exists (select 'Y'
11738: from fa_transaction_headers mth,
11734: from fa_transaction_headers th
11735: where asset_id = p_asset_hdr_rec.asset_id
11736: and book_type_code = p_asset_hdr_rec.book_type_code
11737: and not exists (select 'Y'
11738: from fa_transaction_headers mth,
11739: fa_books bk
11740: where mth.transaction_header_id = th.member_transaction_header_id
11741: and mth.book_type_code = p_asset_hdr_rec.book_type_code
11742: and bk.asset_id = mth.asset_id
11753: p_trans_rec.who_info.creation_date date_effective,
11754: p_trans_rec.transaction_type_code transaction_type_code
11755: from dual
11756: where not exists (select 'Y'
11757: from fa_transaction_headers mth,
11758: fa_books bk
11759: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id
11760: and mth.book_type_code = p_asset_hdr_rec.book_type_code
11761: and bk.asset_id = mth.asset_id
11773: -- header id to get correct initial books row.
11774: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
11775: CURSOR c_get_init_trx2 (c_transaction_header_id number) IS
11776: select outgth.transaction_header_id
11777: from fa_transaction_headers outgth,
11778: fa_transaction_headers ingth,
11779: fa_books gbk
11780: where outgth.asset_id = p_asset_hdr_rec.asset_id
11781: and outgth.book_type_code = p_asset_hdr_rec.book_type_code
11774: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
11775: CURSOR c_get_init_trx2 (c_transaction_header_id number) IS
11776: select outgth.transaction_header_id
11777: from fa_transaction_headers outgth,
11778: fa_transaction_headers ingth,
11779: fa_books gbk
11780: where outgth.asset_id = p_asset_hdr_rec.asset_id
11781: and outgth.book_type_code = p_asset_hdr_rec.book_type_code
11782: and outgth.transaction_header_id <= c_transaction_header_id
11784: and ingth.book_type_code = p_asset_hdr_rec.book_type_code
11785: and gbk.transaction_header_id_out = outgth.transaction_header_id
11786: and gbk.transaction_header_id_in = ingth.transaction_header_id
11787: and not exists (select 1
11788: from fa_transaction_headers mth,
11789: fa_books bk
11790: where mth.transaction_header_id = ingth.member_transaction_header_id
11791: and mth.asset_id = bk.asset_id
11792: and bk.book_type_code = p_asset_hdr_rec.book_type_code
11817: select th.transaction_header_id
11818: , th.transaction_date_entered
11819: , th.date_effective
11820: , th.transaction_type_code
11821: from fa_transaction_headers th
11822: , fa_books bk
11823: where bk.transaction_header_id_out < c_thid
11824: and bk.book_type_code = p_asset_hdr_rec.book_type_code
11825: and th.book_type_code = p_asset_hdr_rec.book_type_code
12041: select th.transaction_header_id,
12042: th.transaction_date_entered,
12043: th.date_effective,
12044: th.transaction_type_code
12045: from fa_transaction_headers th,
12046: fa_deprn_periods fdp
12047: where th.asset_id = p_asset_hdr_rec.asset_id
12048: and th.book_type_code = p_asset_hdr_rec.book_type_code
12049: and fdp.book_type_code = p_asset_hdr_rec.book_type_code
14897:
14898: -- multiple backdate amortization enhancement - begin LSON
14899: cursor amort_date_before_add is
14900: select th.transaction_header_id
14901: from fa_transaction_headers th,
14902: fa_deprn_periods dp
14903: where th.book_type_code = p_asset_hdr_rec.book_type_code
14904: and th.asset_id = p_asset_hdr_rec.asset_id
14905: and th.transaction_type_code = 'ADDITION'
16217: , inbk.allowed_deprn_limit_amount
16218: , bs.period_counter
16219: from fa_books inbk
16220: , fa_books outbk
16221: , fa_transaction_headers inth
16222: , fa_transaction_headers outth
16223: , fa_books_summary bs
16224: where inbk.transaction_header_id_in = p_transaction_header_id
16225: and outbk.asset_id = inbk.asset_id
16218: , bs.period_counter
16219: from fa_books inbk
16220: , fa_books outbk
16221: , fa_transaction_headers inth
16222: , fa_transaction_headers outth
16223: , fa_books_summary bs
16224: where inbk.transaction_header_id_in = p_transaction_header_id
16225: and outbk.asset_id = inbk.asset_id
16226: and outbk.book_type_code = p_book_type_code