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_AMORT_PVT dependencies on FA_TRANSACTION_HEADERS

Line 1544: from fa_transaction_headers th

1540: , th.transaction_type_code
1541: , th.transaction_subtype
1542: , th.transaction_key
1543: , bs.period_counter
1544: from fa_transaction_headers th
1545: , fa_books_summary bs
1546: , fa_transaction_headers mth
1547: , fa_books bk
1548: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id

Line 1546: , fa_transaction_headers mth

1542: , th.transaction_key
1543: , bs.period_counter
1544: from fa_transaction_headers th
1545: , fa_books_summary bs
1546: , fa_transaction_headers mth
1547: , fa_books bk
1548: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id
1549: and th.asset_id = mth.asset_id
1550: and th.book_type_code = p_asset_hdr_rec.book_type_code

Line 1577: , fa_transaction_headers mth

1573: , mth.transaction_subtype
1574: , mth.transaction_key
1575: , bs.period_counter
1576: from fa_books_summary bs
1577: , fa_transaction_headers mth
1578: , fa_books bk
1579: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id
1580: and bs.asset_id = p_group_asset_id
1581: and bs.book_type_code = p_asset_hdr_rec.book_type_code

Line 1672: , fa_transaction_headers mth

1668: , inbk.allowed_deprn_limit
1669: , outbk.allowed_deprn_limit
1670: from fa_books inbk,
1671: fa_books outbk
1672: , fa_transaction_headers mth
1673: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id
1674: and inbk.asset_id = mth.asset_id
1675: and outbk.asset_id(+) = inbk.asset_id
1676: and inbk.book_type_code = p_asset_hdr_rec.book_type_code

Line 1704: , fa_transaction_headers mth

1700: , inbk.allowed_deprn_limit
1701: , outbk.allowed_deprn_limit
1702: from fa_mc_books inbk,
1703: fa_mc_books outbk
1704: , fa_transaction_headers mth
1705: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id
1706: and inbk.asset_id = mth.asset_id
1707: and outbk.asset_id(+) = inbk.asset_id
1708: and inbk.book_type_code = p_asset_hdr_rec.book_type_code

Line 2611: , fa_transaction_headers mth

2607: , -1 * ret.cost_of_removal
2608: , nvl(ret.reserve_retired, 0)
2609: , nbv_retired
2610: from fa_retirements ret
2611: , fa_transaction_headers mth
2612: where mth.transaction_header_id = c_transaction_header_id
2613: and mth.asset_id = ret.asset_id
2614: and mth.book_type_code = p_asset_hdr_rec.book_type_code
2615: and ret.book_type_code = p_asset_hdr_rec.book_type_code

Line 2624: , fa_transaction_headers mth

2620: , -1 * ret.cost_of_removal
2621: , nvl(ret.reserve_retired, 0)
2622: , nbv_retired
2623: from fa_mc_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

Line 3394: , fa_transaction_headers mth

3390: , nbv_retired
3391: , ret.recognize_gain_loss -- Added for bug 8425794 / 8244128
3392: , ret.recapture_amount
3393: from fa_retirements ret
3394: , fa_transaction_headers mth
3395: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id
3396: and mth.asset_id = ret.asset_id
3397: and mth.book_type_code = p_asset_hdr_rec.book_type_code
3398: and ret.book_type_code = p_asset_hdr_rec.book_type_code

Line 3409: , fa_transaction_headers mth

3405: , nbv_retired
3406: , ret.recognize_gain_loss -- Added for bug 8425794 / 8244128
3407: , ret.recapture_amount
3408: from fa_mc_retirements ret
3409: , fa_transaction_headers mth
3410: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id
3411: and mth.asset_id = ret.asset_id
3412: and mth.book_type_code = p_asset_hdr_rec.book_type_code
3413: and ret.book_type_code = p_asset_hdr_rec.book_type_code

Line 7677: fa_transaction_headers th

7673: from fa_calendar_periods cp,
7674: fa_book_controls bc,
7675: fa_fiscal_year fy,
7676: fa_calendar_types ct,
7677: fa_transaction_headers th
7678: WHERE th.book_type_code = p_asset_hdr_rec.book_type_code
7679: and th.asset_id = p_asset_hdr_rec.asset_id
7680: and bc.book_type_code = th.book_type_code
7681: and bc.deprn_calendar = ct.calendar_type

Line 7777: FA_TRANSACTION_HEADERS TH

7773: 'CR', -1 * ADJ.ADJUSTMENT_AMOUNT)
7774: )),
7775: 0)
7776: FROM FA_ADJUSTMENTS ADJ,
7777: FA_TRANSACTION_HEADERS TH
7778: WHERE TH.ASSET_ID = p_asset_hdr_rec.asset_id
7779: AND TH.BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
7780: AND TH.TRANSACTION_HEADER_ID <> p_trans_rec.transaction_header_id
7781: AND TH.TRANSACTION_DATE_ENTERED <= p_trans_rec.transaction_date_entered

Line 7885: FA_TRANSACTION_HEADERS TH

7881: 'CR', -1 * ADJ.ADJUSTMENT_AMOUNT)
7882: )),
7883: 0)
7884: FROM FA_MC_ADJUSTMENTS ADJ,
7885: FA_TRANSACTION_HEADERS TH
7886: WHERE TH.ASSET_ID = p_asset_hdr_rec.asset_id
7887: AND TH.BOOK_TYPE_CODE = p_asset_hdr_rec.book_type_code
7888: AND TH.TRANSACTION_HEADER_ID <> p_trans_rec.transaction_header_id
7889: AND TH.TRANSACTION_DATE_ENTERED <= p_trans_rec.transaction_date_entered

Line 8194: fa_transaction_headers th,

8190: nvl(th.amortization_start_date, th.transaction_date_entered) transaction_date_entered,
8191: th.date_effective date_effective,
8192: th.transaction_type_code transaction_type_code
8193: from
8194: fa_transaction_headers th,
8195: fa_deprn_periods dp,
8196: fa_book_controls bc,
8197: fa_fiscal_year fy
8198: where th.asset_id = p_asset_hdr_rec.asset_id

Line 8232: fa_transaction_headers mth,

8228: CURSOR c_get_ret_trx IS
8229: select nvl(sum(ret.reserve_retired), 0),
8230: nvl(sum(ret.eofy_reserve), 0)
8231: from fa_retirements ret,
8232: fa_transaction_headers mth,
8233: fa_transaction_headers gth,
8234: fa_book_controls bc,
8235: fa_fiscal_year fy
8236: where gth.asset_id = p_asset_hdr_rec.asset_id

Line 8233: fa_transaction_headers gth,

8229: select nvl(sum(ret.reserve_retired), 0),
8230: nvl(sum(ret.eofy_reserve), 0)
8231: from fa_retirements ret,
8232: fa_transaction_headers mth,
8233: fa_transaction_headers gth,
8234: fa_book_controls bc,
8235: fa_fiscal_year fy
8236: where gth.asset_id = p_asset_hdr_rec.asset_id
8237: and gth.book_type_code = p_asset_hdr_rec.book_type_code

Line 8263: fa_transaction_headers mth,

8259: CURSOR c_get_mc_ret_trx IS
8260: select nvl(sum(ret.reserve_retired), 0),
8261: nvl(sum(ret.eofy_reserve), 0)
8262: from fa_mc_retirements ret,
8263: fa_transaction_headers mth,
8264: fa_transaction_headers gth,
8265: fa_mc_book_controls mbc,
8266: fa_book_controls bc,
8267: fa_fiscal_year fy

Line 8264: fa_transaction_headers gth,

8260: select nvl(sum(ret.reserve_retired), 0),
8261: nvl(sum(ret.eofy_reserve), 0)
8262: from fa_mc_retirements ret,
8263: fa_transaction_headers mth,
8264: fa_transaction_headers gth,
8265: fa_mc_book_controls mbc,
8266: fa_book_controls bc,
8267: fa_fiscal_year fy
8268: where gth.asset_id = p_asset_hdr_rec.asset_id

Line 8299: fa_transaction_headers th,

8295: CURSOR c_get_ret_trx2 IS
8296: select nvl(sum(ret.reserve_retired), 0),
8297: nvl(sum(ret.eofy_reserve), 0)
8298: from fa_retirements ret,
8299: fa_transaction_headers th,
8300: fa_book_controls bc,
8301: fa_fiscal_year fy
8302: where th.asset_id = p_asset_hdr_rec.asset_id
8303: and th.book_type_code = p_asset_hdr_rec.book_type_code

Line 8333: from fa_transaction_headers th

8329: select th.transaction_header_id transaction_header_id,
8330: nvl(th.amortization_start_date, th.transaction_date_entered) transaction_date_entered,
8331: th.date_effective date_effective,
8332: th.transaction_type_code transaction_type_code
8333: from fa_transaction_headers th
8334: where th.asset_id = p_asset_hdr_rec.asset_id
8335: and th.book_type_code = p_asset_hdr_rec.book_type_code
8336: and th.transaction_header_id =
8337: -- Get the latest trasnaction of reclassed member asset on group asset

Line 8339: from fa_transaction_headers th

8335: and th.book_type_code = p_asset_hdr_rec.book_type_code
8336: and th.transaction_header_id =
8337: -- Get the latest trasnaction of reclassed member asset on group asset
8338: (select max(th.transaction_header_id)
8339: from fa_transaction_headers th
8340: where th.asset_id =p_asset_hdr_rec.asset_id
8341: and th.book_type_code = p_asset_hdr_rec.book_type_code
8342: and th.transaction_type_code not in (G_TRX_TYPE_TFR_OUT, G_TRX_TYPE_TFR_IN,
8343: G_TRX_TYPE_TFR, G_TRX_TYPE_TFR_VOID,

Line 8349: from fa_transaction_headers th

8345: G_TRX_TYPE_TFR_VOID)
8346: and th.transaction_header_id <
8347: -- Get first transaction of reclassed member asset on group asset
8348: (select min(th.transaction_header_id)
8349: from fa_transaction_headers th
8350: where th.book_type_code = p_asset_hdr_rec.book_type_code
8351: and th.asset_id = p_asset_hdr_rec.asset_id
8352: and th.member_transaction_header_id in
8353: -- Get reclassed member's all transaction headers

Line 8355: from fa_transaction_headers th

8351: and th.asset_id = p_asset_hdr_rec.asset_id
8352: and th.member_transaction_header_id in
8353: -- Get reclassed member's all transaction headers
8354: (select th.transaction_header_id
8355: from fa_transaction_headers th
8356: where th.book_type_code = p_asset_hdr_rec.book_type_code
8357: and th.asset_id in
8358: -- Get reclassed member's asset_id
8359: (select th.asset_id

Line 8360: from fa_transaction_headers th

8356: where th.book_type_code = p_asset_hdr_rec.book_type_code
8357: and th.asset_id in
8358: -- Get reclassed member's asset_id
8359: (select th.asset_id
8360: from fa_transaction_headers th
8361: where th.book_type_code = p_asset_hdr_rec.book_type_code
8362: and transaction_header_id in
8363: -- Get reclassed transaction after this transaction's fiscal year
8364: (select th.member_transaction_header_id

Line 8365: from fa_transaction_headers th,

8361: where th.book_type_code = p_asset_hdr_rec.book_type_code
8362: and transaction_header_id in
8363: -- Get reclassed transaction after this transaction's fiscal year
8364: (select th.member_transaction_header_id
8365: from fa_transaction_headers th,
8366: fa_deprn_periods dp,
8367: fa_fiscal_year fy,
8368: fa_book_controls bc
8369: where th.asset_id = p_asset_hdr_rec.asset_id

Line 8613: from fa_transaction_headers th,

8609: , decode(p_reclass_src_dest, 'SOURCE', -1, 1) * sum(inbk.unrevalued_cost - nvl(outbk.unrevalued_cost, 0))
8610: , decode(p_reclass_src_dest, 'SOURCE', -1, 1) * sum(nvl(inbk.allowed_deprn_limit_amount, 0) -
8611: nvl(outbk.allowed_deprn_limit_amount, 0))
8612: , decode(p_reclass_src_dest, 'SOURCE', -1, 1) * sum(nvl(inbk.cip_cost, 0) - nvl(outbk.cip_cost, 0))
8613: from fa_transaction_headers th,
8614: fa_books inbk,
8615: fa_books outbk
8616: where inbk.asset_id = p_asset_hdr_rec.asset_id
8617: and inbk.book_type_code = p_asset_hdr_rec.book_type_code

Line 8632: fa_transaction_headers reith

8628: and nvl(th.amortization_start_date,
8629: th.transaction_date_entered) <= p_transaction_date_entered
8630: and not exists(select 'Exclude This Retirement'
8631: from fa_retirements ret,
8632: fa_transaction_headers reith
8633: where ret.transaction_header_id_in = th.transaction_header_id
8634: and ret.transaction_header_id_out = reith.transaction_header_id
8635: and nvl(reith.amortization_start_date,
8636: reith.transaction_date_entered) <= p_transaction_date_entered)

Line 8663: from fa_transaction_headers th,

8659: , decode(p_reclass_src_dest, 'SOURCE', -1, 1) * sum(inbk.unrevalued_cost - nvl(outbk.unrevalued_cost, 0))
8660: , decode(p_reclass_src_dest, 'SOURCE', -1, 1) * sum(nvl(inbk.allowed_deprn_limit_amount, 0) -
8661: nvl(outbk.allowed_deprn_limit_amount, 0))
8662: , decode(p_reclass_src_dest, 'SOURCE', -1, 1) * sum(nvl(inbk.cip_cost, 0) - nvl(outbk.cip_cost, 0))
8663: from fa_transaction_headers th,
8664: fa_mc_books inbk,
8665: fa_mc_books outbk
8666: where inbk.asset_id = p_asset_hdr_rec.asset_id
8667: and inbk.book_type_code = p_asset_hdr_rec.book_type_code

Line 8684: fa_transaction_headers reith

8680: and nvl(th.amortization_start_date,
8681: th.transaction_date_entered) <= p_transaction_date_entered
8682: and not exists(select 'Exclude This Retirement'
8683: from fa_mc_retirements ret,
8684: fa_transaction_headers reith
8685: where ret.transaction_header_id_in = th.transaction_header_id
8686: and ret.transaction_header_id_out = reith.transaction_header_id
8687: and ret.set_of_books_id = p_asset_hdr_rec.set_of_books_id
8688: and nvl(reith.amortization_start_date,

Line 8773: p_init_transaction_header_id FA_TRANSACTION_HEADERS.TRANSACTION_HEADER_ID%TYPE,

8769: px_asset_fin_rec IN OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8770: p_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type,
8771: p_asset_fin_rec_new FA_API_TYPES.asset_fin_rec_type,
8772: x_asset_fin_rec_new OUT NOCOPY FA_API_TYPES.asset_fin_rec_type,
8773: p_init_transaction_header_id FA_TRANSACTION_HEADERS.TRANSACTION_HEADER_ID%TYPE,
8774: p_use_fin_rec_adj BOOLEAN,
8775: p_use_new_deprn_rule BOOLEAN,
8776: p_process_this_trx BOOLEAN,
8777: x_dpis_change OUT NOCOPY BOOLEAN,

Line 10012: from fa_transaction_headers

10008:
10009:
10010: CURSOR c_get_member_asset_id IS
10011: select asset_id
10012: from fa_transaction_headers
10013: where transaction_header_id = p_trans_rec.member_transaction_header_id;
10014:
10015: l_calling_fn VARCHAR2(100) := 'FA_AMORT_PVT.GetFinRec';
10016: l_asset_fin_rec_adj FA_API_TYPES.asset_fin_rec_type;

Line 11658: from fa_transaction_headers th

11654: select th.transaction_header_id
11655: , nvl(th.amortization_start_date, th.transaction_date_entered)
11656: , th.date_effective
11657: , th.transaction_type_code
11658: from fa_transaction_headers th
11659: where th.asset_id = p_asset_hdr_rec.asset_id
11660: and th.book_type_code = p_asset_hdr_rec.book_type_code
11661: and th.transaction_header_id = (select min(th2.transaction_header_id)
11662: from fa_transaction_headers th2

Line 11662: from fa_transaction_headers th2

11658: from fa_transaction_headers th
11659: where th.asset_id = p_asset_hdr_rec.asset_id
11660: and th.book_type_code = p_asset_hdr_rec.book_type_code
11661: and th.transaction_header_id = (select min(th2.transaction_header_id)
11662: from fa_transaction_headers th2
11663: where th2.asset_id = p_asset_hdr_rec.asset_id
11664: and th2.book_type_code = p_asset_hdr_rec.book_type_code);
11665:
11666: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Line 11709: from fa_transaction_headers th

11705: nvl(th.amortization_start_date,th.transaction_date_entered)
11706: ) transaction_date_entered,
11707: th.date_effective date_effective,
11708: th.transaction_type_code transaction_type_code
11709: from fa_transaction_headers th
11710: , fa_deprn_periods dp
11711: where th.asset_id = p_asset_hdr_rec.asset_id
11712: and th.book_type_code = p_asset_hdr_rec.book_type_code
11713: and dp.book_type_code = p_asset_hdr_rec.book_type_code

Line 11740: from fa_transaction_headers ret,

11736: select ret.transaction_header_id transaction_header_id,
11737: ret.transaction_date_entered transaction_date_entered,
11738: ret.date_effective date_effective,
11739: ret.transaction_type_code transaction_type_code
11740: from fa_transaction_headers ret,
11741: fa_transaction_headers rei,
11742: fa_retirements faret
11743: where ret.asset_id = p_asset_hdr_rec.asset_id
11744: and rei.asset_id = p_asset_hdr_rec.asset_id

Line 11741: fa_transaction_headers rei,

11737: ret.transaction_date_entered transaction_date_entered,
11738: ret.date_effective date_effective,
11739: ret.transaction_type_code transaction_type_code
11740: from fa_transaction_headers ret,
11741: fa_transaction_headers rei,
11742: fa_retirements faret
11743: where ret.asset_id = p_asset_hdr_rec.asset_id
11744: and rei.asset_id = p_asset_hdr_rec.asset_id
11745: and ret.book_type_code = p_asset_hdr_rec.book_type_code

Line 11765: from fa_transaction_headers th

11761: nvl(th.amortization_start_date,th.transaction_date_entered)
11762: ) transaction_date_entered,
11763: th.date_effective date_effective,
11764: th.transaction_type_code transaction_type_code
11765: from fa_transaction_headers th
11766: where th.asset_id = p_asset_hdr_rec.asset_id
11767: and th.book_type_code = p_asset_hdr_rec.book_type_code
11768: and th.transaction_type_code not in (G_TRX_TYPE_TFR_OUT, G_TRX_TYPE_TFR_IN,
11769: G_TRX_TYPE_TFR, G_TRX_TYPE_TFR_VOID,

Line 11857: from fa_transaction_headers th,

11853: th.member_transaction_header_id member_transaction_header_id,
11854: th.trx_reference_id trx_reference_id,
11855: th.invoice_transaction_id,
11856: '1st SELECT in c_get_ths_adj'
11857: from fa_transaction_headers th,
11858: fa_books bk
11859: , fa_books outbk
11860: , fa_deprn_summary ds
11861: where th.asset_id = p_asset_hdr_rec.asset_id

Line 11899: from fa_transaction_headers th2

11895: and tr.book_type_code = p_asset_hdr_rec.book_type_code
11896: and tr.transaction_type = G_TRX_TYPE_GRP_CHG)
11897: /*Bug# 8946649 - No need to pick rolled back impairment and transaction got created to reverse impairment*/
11898: and bk.transaction_header_id_out not in (select transaction_header_id
11899: from fa_transaction_headers th2
11900: where th2.asset_id = th.asset_id
11901: and th2.book_type_code = p_asset_hdr_rec.book_type_code
11902: and th2.transaction_key = 'RM')
11903: and nvl(th.transaction_key,'XX') <> 'RM' /*Bug#9355389 - placed nvl around key */

Line 11948: from fa_transaction_headers th,

11944: th.member_transaction_header_id member_transaction_header_id,
11945: th.trx_reference_id trx_reference_id,
11946: th.invoice_transaction_id,
11947: '2nd SELECT in c_get_ths_adj'
11948: from fa_transaction_headers th,
11949: fa_retirements ret,
11950: fa_conventions con,
11951: fa_calendar_periods cp,
11952: fa_calendar_periods cptrx

Line 12025: from fa_transaction_headers th

12021: CURSOR c_get_next_ths (c_transaction_date_entered date,
12022: c_date_effective date) IS
12023: select th.transaction_date_entered transaction_date_entered,
12024: th.date_effective date_effective
12025: from fa_transaction_headers th
12026: where th.asset_id = p_asset_hdr_rec.asset_id
12027: and th.book_type_code = p_asset_hdr_rec.book_type_code
12028: and th.transaction_date_entered >= c_transaction_date_entered
12029: and th.date_effective > c_date_effective

Line 12032: from fa_transaction_headers mth,

12028: and th.transaction_date_entered >= c_transaction_date_entered
12029: and th.date_effective > c_date_effective
12030: and (p_asset_type_rec.asset_type <> G_ASSET_TYPE_GROUP or
12031: not exists (select 'Y'
12032: from fa_transaction_headers mth,
12033: fa_books bk
12034: where mth.transaction_header_id = th.member_transaction_header_id
12035: and mth.book_type_code = p_asset_hdr_rec.book_type_code
12036: and bk.asset_id = mth.asset_id

Line 12053: from fa_transaction_headers mth,

12049: and p_trans_rec.transaction_date_entered >= c_transaction_date_entered
12050: and p_trans_rec.who_info.creation_date = c_date_effective
12051: and (p_asset_type_rec.asset_type <> G_ASSET_TYPE_GROUP or
12052: not exists (select 'Y'
12053: from fa_transaction_headers mth,
12054: fa_books bk
12055: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id
12056: and mth.book_type_code = p_asset_hdr_rec.book_type_code
12057: and bk.asset_id = mth.asset_id

Line 12285: from fa_transaction_headers gth

12281: -- to member's dpis.
12282: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
12283: CURSOR c_get_init_thid IS
12284: select gth.transaction_header_id
12285: from fa_transaction_headers gth
12286: where gth.asset_id = p_asset_hdr_rec.asset_id
12287: and gth.book_type_code = p_asset_hdr_rec.book_type_code
12288: and gth.member_transaction_header_id =
12289: (select min(mth.transaction_header_id)

Line 12290: from fa_transaction_headers mth

12286: where gth.asset_id = p_asset_hdr_rec.asset_id
12287: and gth.book_type_code = p_asset_hdr_rec.book_type_code
12288: and gth.member_transaction_header_id =
12289: (select min(mth.transaction_header_id)
12290: from fa_transaction_headers mth
12291: where mth.asset_id = p_reclassed_asset_id
12292: and mth.book_type_code = p_asset_hdr_rec.book_type_code);
12293:
12294: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Line 12303: from fa_transaction_headers th

12299: nvl(th.amortization_start_date,
12300: th.transaction_date_entered) transaction_date_entered,
12301: th.date_effective date_effective,
12302: th.transaction_type_code transaction_type_code
12303: from fa_transaction_headers th
12304: where asset_id = p_asset_hdr_rec.asset_id
12305: and book_type_code = p_asset_hdr_rec.book_type_code
12306: and not exists (select 'Y'
12307: from fa_transaction_headers mth,

Line 12307: from fa_transaction_headers mth,

12303: from fa_transaction_headers th
12304: where asset_id = p_asset_hdr_rec.asset_id
12305: and book_type_code = p_asset_hdr_rec.book_type_code
12306: and not exists (select 'Y'
12307: from fa_transaction_headers mth,
12308: fa_books bk
12309: where mth.transaction_header_id = th.member_transaction_header_id
12310: and mth.book_type_code = p_asset_hdr_rec.book_type_code
12311: and bk.asset_id = mth.asset_id

Line 12326: from fa_transaction_headers mth,

12322: p_trans_rec.who_info.creation_date date_effective,
12323: p_trans_rec.transaction_type_code transaction_type_code
12324: from dual
12325: where not exists (select 'Y'
12326: from fa_transaction_headers mth,
12327: fa_books bk
12328: where mth.transaction_header_id = p_trans_rec.member_transaction_header_id
12329: and mth.book_type_code = p_asset_hdr_rec.book_type_code
12330: and bk.asset_id = mth.asset_id

Line 12346: from fa_transaction_headers outgth,

12342: -- header id to get correct initial books row.
12343: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
12344: CURSOR c_get_init_trx2 (c_transaction_header_id number) IS
12345: select outgth.transaction_header_id
12346: from fa_transaction_headers outgth,
12347: fa_transaction_headers ingth,
12348: fa_books gbk
12349: where outgth.asset_id = p_asset_hdr_rec.asset_id
12350: and outgth.book_type_code = p_asset_hdr_rec.book_type_code

Line 12347: fa_transaction_headers ingth,

12343: --+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
12344: CURSOR c_get_init_trx2 (c_transaction_header_id number) IS
12345: select outgth.transaction_header_id
12346: from fa_transaction_headers outgth,
12347: fa_transaction_headers ingth,
12348: fa_books gbk
12349: where outgth.asset_id = p_asset_hdr_rec.asset_id
12350: and outgth.book_type_code = p_asset_hdr_rec.book_type_code
12351: and outgth.transaction_header_id <= c_transaction_header_id

Line 12357: from fa_transaction_headers mth,

12353: and ingth.book_type_code = p_asset_hdr_rec.book_type_code
12354: and gbk.transaction_header_id_out = outgth.transaction_header_id
12355: and gbk.transaction_header_id_in = ingth.transaction_header_id
12356: and not exists (select 1
12357: from fa_transaction_headers mth,
12358: fa_books bk
12359: where mth.transaction_header_id = ingth.member_transaction_header_id
12360: and mth.asset_id = bk.asset_id
12361: and bk.book_type_code = p_asset_hdr_rec.book_type_code

Line 12394: from fa_transaction_headers th

12390: select th.transaction_header_id
12391: , th.transaction_date_entered
12392: , th.date_effective
12393: , th.transaction_type_code
12394: from fa_transaction_headers th
12395: , fa_books bk
12396: where bk.transaction_header_id_out < c_thid
12397: and bk.book_type_code = p_asset_hdr_rec.book_type_code
12398: and th.book_type_code = p_asset_hdr_rec.book_type_code

Line 13241: fa_transaction_headers th,

13237:
13238: SELECT count(th.transaction_header_id)
13239: INTO l_future_ret_count
13240: FROM fa_deprn_periods dp,
13241: fa_transaction_headers th,
13242: fa_retirements ret,
13243: fa_conventions con
13244: WHERE th.book_type_code = p_asset_hdr_rec.book_type_code
13245: and th.asset_id = p_asset_hdr_rec.asset_id

Line 13265: FROM fa_transaction_headers th

13261: INTO l_trans_rec.transaction_date_entered,
13262: l_trans_rec.who_info.creation_date,
13263: l_trans_rec.transaction_header_id,
13264: l_retirement_flag
13265: FROM fa_transaction_headers th
13266: WHERE th.book_type_code = p_asset_hdr_rec.book_type_code
13267: and th.asset_id = p_asset_hdr_rec.asset_id
13268: and th.transaction_type_code = 'ADDITION';
13269:

Line 13372: from fa_transaction_headers hdr,

13368: -- bug 9003531. check if retirement trx is overlapping with
13369: -- TAX reserve transaction. If they are overlapped raise exception
13370: begin
13371: Select 1 into l_check_tax_overlap
13372: from fa_transaction_headers hdr,
13373: fa_transaction_headers tax
13374: where hdr.transaction_header_id < t_transaction_header_id(i) --Transaction header id for TAX transaction
13375: and hdr.transaction_date_entered <= t_transaction_date_entered(i) --Transaction date for TAX transaction
13376: and hdr.transaction_type_code like '%RETIREMENT'

Line 13373: fa_transaction_headers tax

13369: -- TAX reserve transaction. If they are overlapped raise exception
13370: begin
13371: Select 1 into l_check_tax_overlap
13372: from fa_transaction_headers hdr,
13373: fa_transaction_headers tax
13374: where hdr.transaction_header_id < t_transaction_header_id(i) --Transaction header id for TAX transaction
13375: and hdr.transaction_date_entered <= t_transaction_date_entered(i) --Transaction date for TAX transaction
13376: and hdr.transaction_type_code like '%RETIREMENT'
13377: and hdr.book_type_code = tax.book_type_code

Line 16019: from fa_transaction_headers th,

16015:
16016: -- multiple backdate amortization enhancement - begin LSON
16017: cursor amort_date_before_add is
16018: select th.transaction_header_id
16019: from fa_transaction_headers th,
16020: fa_deprn_periods dp
16021: where th.book_type_code = p_asset_hdr_rec.book_type_code
16022: and th.asset_id = p_asset_hdr_rec.asset_id
16023: and th.transaction_type_code = 'ADDITION'

Line 16820: fa_transaction_headers fatr,

16816: Select count (1)
16817: from
16818: fa_deprn_periods fadp,
16819: fa_deprn_periods fadp1,
16820: fa_transaction_headers fatr,
16821: fa_deprn_summary fads
16822: where fadp.book_type_code = p_asset_hdr_rec.book_type_code
16823: and p_trans_rec.amortization_start_date between fadp.calendar_period_open_date and fadp.calendar_period_close_date
16824: and fatr.book_type_code = p_asset_hdr_rec.book_type_code

Line 17403: , fa_transaction_headers inth

17399: , inbk.allowed_deprn_limit_amount
17400: , bs.period_counter
17401: from fa_books inbk
17402: , fa_books outbk
17403: , fa_transaction_headers inth
17404: , fa_transaction_headers outth
17405: , fa_books_summary bs
17406: where inbk.transaction_header_id_in = p_transaction_header_id
17407: and outbk.asset_id = inbk.asset_id

Line 17404: , fa_transaction_headers outth

17400: , bs.period_counter
17401: from fa_books inbk
17402: , fa_books outbk
17403: , fa_transaction_headers inth
17404: , fa_transaction_headers outth
17405: , fa_books_summary bs
17406: where inbk.transaction_header_id_in = p_transaction_header_id
17407: and outbk.asset_id = inbk.asset_id
17408: and outbk.book_type_code = p_book_type_code