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_TRACK_MEMBER_PVT dependencies on FA_MC_BOOKS

Line 465: from fa_mc_books bk,

461: nvl(ds.deprn_reserve,0) deprn_reserve,
462: nvl(ds.ytd_deprn,0) ytd_deprn,
463: nvl(ds.bonus_deprn_reserve,0) bonus_deprn_reserve,
464: nvl(ds.bonus_ytd_deprn,0) bonus_ytd_deprn
465: from fa_mc_books bk,
466: fa_mc_deprn_summary ds,
467: fa_additions_b ad
468: where bk.group_asset_id = h_group_asset_id
469: and bk.book_type_code = h_book_type_code

Line 505: from fa_mc_books bk,

501: cursor ALL_MEMBERS_TOTAL_MRC is
502: select sum(bk.cost),
503: decode(h_excl_sv,'N',sum(bk.adjusted_cost),sum(bk.adjusted_cost+bk.salvage_value)),
504: sum(bk.recoverable_cost)
505: from fa_mc_books bk,
506: fa_additions_b ad
507: where bk.group_asset_id = h_group_asset_id
508: and bk.date_ineffective is null
509: and bk.book_type_code = h_book_type_code

Line 534: from fa_mc_books bk,

530: cursor MEMBERS_EX_RETIRED_TOTAL_MRC is
531: select sum(bk.cost),
532: decode(h_excl_sv,'N',sum(bk.adjusted_cost),sum(bk.adjusted_cost+bk.salvage_value)),
533: sum(bk.recoverable_cost)
534: from fa_mc_books bk,
535: fa_additions_b ad
536: where bk.group_asset_id = h_group_asset_id
537: and bk.date_ineffective is null
538: and bk.period_counter_fully_retired is null

Line 564: from fa_mc_books bk,

560: cursor MEMBERS_EX_RESERVED_TOTAL_MRC is
561: select sum(bk.cost),
562: decode(h_excl_sv,'N',sum(bk.adjusted_cost),sum(bk.adjusted_cost+bk.salvage_value)),
563: sum(bk.recoverable_cost)
564: from fa_mc_books bk,
565: fa_additions_b ad
566: where bk.group_asset_id = h_group_asset_id
567: and bk.date_ineffective is null
568: and bk.period_counter_fully_reserved is null

Line 595: from fa_mc_books bk,

591: cursor MEMBER_EX_BOTH_TOTAL_MRC is
592: select sum(bk.cost),
593: decode(h_excl_sv,'N',sum(bk.adjusted_cost),sum(bk.adjusted_cost+bk.salvage_value)),
594: sum(bk.recoverable_cost)
595: from fa_mc_books bk,
596: fa_additions_b ad
597: where bk.group_asset_id = h_group_asset_id
598: and bk.date_ineffective is null
599: and bk.period_counter_fully_retired is null

Line 668: fa_mc_books bk,

664: ds.ytd_deprn,
665: ds.bonus_deprn_reserve,
666: ds.bonus_ytd_deprn
667: from fa_track_members tr,
668: fa_mc_books bk,
669: fa_mc_deprn_summary ds,
670: fa_mc_deprn_periods dp,
671: fa_additions_b ad
672: where tr.group_asset_id = h_group_asset_id

Line 705: from fa_mc_books bk

701:
702: cursor GROUP_BASIS_MRC is
703: select decode(h_excl_sv,'N',bk.adjusted_cost,bk.adjusted_cost+bk.salvage_value) adjusted_cost,
704: bk.recoverable_cost recoverable_cost
705: from fa_mc_books bk
706: where bk.book_type_code=h_book_type_code
707: and bk.asset_id = h_group_asset_id
708: and bk.date_ineffective is null
709: and bk.set_of_books_id = p_set_of_books_id;

Line 1843: update fa_mc_books -- ENERGY

1839: (mem.asset_id is not null) and -- ENERGY
1840: (nvl(l_track_member_out.allocated_deprn_amount, 0) <> 0) and -- ENERGY
1841: (nvl(P_mode,'DEPRECIATION') = 'UNPLANNED') then -- ENERGY
1842:
1843: update fa_mc_books -- ENERGY
1844: set adjusted_cost = adjusted_cost - nvl(l_track_member_out.allocated_deprn_amount, 0) -- ENERGY
1845: where transaction_header_id_out is null -- ENERGY
1846: and asset_id = mem.asset_id -- ENERGY
1847: and book_type_code = h_book_type_code -- ENERGY

Line 3010: UPDATE FA_MC_BOOKS_SUMMARY

3006: l_unplanned_exp_tbl(l_count) := l_unplanned_exp_tbl(l_count) + l_unplanned_exp_mem_tbl(l_count);
3007: end loop;
3008:
3009: FORALL l_count IN 1..l_mem_asset_id_tbl.count
3010: UPDATE FA_MC_BOOKS_SUMMARY
3011: SET DEPRN_AMOUNT = l_unplanned_exp_tbl(l_count) + DEPRN_AMOUNT,
3012: YTD_DEPRN = l_unplanned_exp_tbl(l_count) + YTD_DEPRN
3013: WHERE BOOK_TYPE_CODE = h_book_type_code
3014: AND PERIOD_COUNTER = h_period_counter

Line 3996: from fa_mc_books bk,

3992: temp.eofy_recoverable_cost temp_eofy_recoverable_cost,
3993: temp.eop_recoverable_cost temp_eop_recoverable_cost,
3994: temp.eofy_salvage_value temp_eofy_salvage_value,
3995: temp.eop_salvage_value temp_eop_salvage_value
3996: from fa_mc_books bk,
3997: fa_mc_deprn_summary ds,
3998: fa_track_members temp
3999: where bk.book_type_code = h_book_type_code
4000: and bk.group_asset_id = h_group_asset_id

Line 4153: from fa_mc_books new_bk,

4149: new_bk.salvage_type,
4150: decode(new_bk.salvage_type,'PCT',new_bk.percent_salvage_value),
4151: new_bk.deprn_limit_type,
4152: decode(new_bk.deprn_limit_type,'PCT',new_bk.allowed_deprn_limit)
4153: from fa_mc_books new_bk,
4154: fa_mc_books old_bk
4155: where new_bk.book_type_code = p_group_rule_in.book_type_code
4156: and new_bk.asset_id = h_member_asset_id
4157: and new_bk.transaction_header_id_in = h_adj_member_trans_header_id

Line 4154: fa_mc_books old_bk

4150: decode(new_bk.salvage_type,'PCT',new_bk.percent_salvage_value),
4151: new_bk.deprn_limit_type,
4152: decode(new_bk.deprn_limit_type,'PCT',new_bk.allowed_deprn_limit)
4153: from fa_mc_books new_bk,
4154: fa_mc_books old_bk
4155: where new_bk.book_type_code = p_group_rule_in.book_type_code
4156: and new_bk.asset_id = h_member_asset_id
4157: and new_bk.transaction_header_id_in = h_adj_member_trans_header_id
4158: and new_bk.set_of_books_id = h_set_of_books_id

Line 4336: from fa_mc_books new_bk

4332: new_bk.salvage_type,
4333: new_bk.percent_salvage_value,
4334: new_bk.deprn_limit_type,
4335: new_bk.allowed_deprn_limit
4336: from fa_mc_books new_bk
4337: where new_bk.book_type_code = p_group_rule_in.book_type_code
4338: and new_bk.asset_id = h_member_asset_id
4339: and new_bk.transaction_header_id_in = h_adj_member_trans_header_id
4340: and new_bk.set_of_books_id = h_set_of_books_id;

Line 4351: from fa_mc_books

4347: and date_ineffective is null;
4348:
4349: cursor GET_EXCLUDE_FULLY_RSV_FLAG_MRC is
4350: select exclude_fully_rsv_flag
4351: from fa_mc_books
4352: where book_type_code = h_book_type_code
4353: and asset_id = h_group_asset_id
4354: and date_ineffective is null
4355: and set_of_books_id = h_set_of_books_id;

Line 5475: update fa_mc_books

5471: fa_debug_pkg.add(l_calling_fn, 'h_eofy_adj_cost:h_eop_adj_cost:h_new_eofy_reserve ',
5472: h_eofy_adj_cost||':'||h_eop_adj_cost||':'||h_new_eofy_reserve, p_log_level_rec => p_log_level_rec);
5473: end if;
5474:
5475: update fa_mc_books
5476: set adjusted_cost = fa_rule_out.new_adjusted_cost,
5477: eofy_adj_cost = h_eofy_adj_cost,
5478: eofy_reserve = h_new_eofy_reserve,
5479: eop_adj_cost = h_eop_adj_cost,

Line 6078: from fa_mc_books bk,

6074: order by ad.asset_number;
6075:
6076: cursor ALL_MEMBERS_MRC(h_date date) is
6077: select bk.asset_id
6078: from fa_mc_books bk,
6079: fa_additions_b ad
6080: where bk.book_type_code = h_book_type_code
6081: and bk.group_asset_id = h_group_asset_id
6082: and bk.set_of_books_id = p_set_of_books_id

Line 6157: from fa_mc_books bk,

6153: decode(dp1.fiscal_year,h_fiscal_year,ds.ytd_deprn,0),
6154: ds.bonus_deprn_reserve,
6155: decode(dp1.fiscal_year,h_fiscal_year,ds.bonus_ytd_deprn,0),
6156: dp1.fiscal_year
6157: from fa_mc_books bk,
6158: fa_mc_deprn_periods dp,
6159: fa_mc_deprn_periods dp1,
6160: fa_mc_deprn_summary ds,
6161: fa_additions_b ad

Line 6173: from fa_mc_books bk1

6169: bk.transaction_header_id_out = h_last_trans_id or
6170: (bk.date_ineffective is null and
6171: bk.transaction_header_id_in <> nvl(p_transaction_header_id,-1) and
6172: not exists (select 'y'
6173: from fa_mc_books bk1
6174: where bk1.book_type_code = bk.book_type_code
6175: and bk1.asset_id = bk.asset_id
6176: and bk1.transaction_header_id_out = nvl(p_transaction_header_id,-1)
6177: and set_of_books_id = p_set_of_books_id)))

Line 6250: from fa_mc_books bk,

6246: ds.ytd_deprn,
6247: ds.bonus_deprn_reserve,
6248: ds.bonus_ytd_deprn,
6249: dp.fiscal_year
6250: from fa_mc_books bk,
6251: fa_mc_deprn_periods dp,
6252: fa_mc_deprn_summary ds,
6253: fa_additions_b ad
6254: where dp.book_type_code = h_book_type_code

Line 6293: from fa_mc_books bk,

6289:
6290: cursor MEMBER_START_PERIOD_MRC is
6291: select bk.recoverable_cost,
6292: bk.salvage_value
6293: from fa_mc_books bk,
6294: fa_mc_deprn_periods dp
6295: where bk.book_type_code = h_book_type_code
6296: and bk.group_asset_id = h_member_asset_id
6297: and bk.set_of_books_id = p_set_of_books_id

Line 6790: from fa_mc_books

6786:
6787: if nvl(p_calling_fn,'OTHER') = 'TRACK_ASSETS' then -- Get group level info
6788: select deprn_method_code,life_in_months
6789: into h_method_code,h_life_in_months
6790: from fa_mc_books
6791: where book_type_code = h_book_type_code
6792: and asset_id = h_group_asset_id
6793: and date_ineffective is null
6794: and set_of_books_id = p_set_of_books_id;

Line 7197: from FA_MC_BOOKS BK_IN,

7193: BK_OUT.DEPRN_LIMIT_TYPE old_limit_type,
7194: BK_IN.ALLOWED_DEPRN_LIMIT new_deprn_limit,
7195: BK_IN.ALLOWED_DEPRN_LIMIT_AMOUNT old_deprn_limit,
7196: BK_IN.DEPRECIATE_FLAG depreciate_flag
7197: from FA_MC_BOOKS BK_IN,
7198: FA_MC_BOOKS BK_OUT
7199: where BK_IN.book_type_code = h_book_type_code
7200: and BK_IN.asset_id = h_member_asset_id
7201: and BK_IN.transaction_header_id_in = p_transaction_header_id

Line 7198: FA_MC_BOOKS BK_OUT

7194: BK_IN.ALLOWED_DEPRN_LIMIT new_deprn_limit,
7195: BK_IN.ALLOWED_DEPRN_LIMIT_AMOUNT old_deprn_limit,
7196: BK_IN.DEPRECIATE_FLAG depreciate_flag
7197: from FA_MC_BOOKS BK_IN,
7198: FA_MC_BOOKS BK_OUT
7199: where BK_IN.book_type_code = h_book_type_code
7200: and BK_IN.asset_id = h_member_asset_id
7201: and BK_IN.transaction_header_id_in = p_transaction_header_id
7202: and BK_IN.set_of_books_id = h_set_of_books_id

Line 7235: from fa_mc_books bk,

7231: order by ad.asset_number asc;
7232:
7233: cursor ALL_MEMBERS_AT_AMORT_MRC(p_fiscal_year number,p_period_num number) is
7234: select distinct bk.asset_id member_asset_id, ad.asset_number
7235: from fa_mc_books bk,
7236: fa_additions_b ad
7237: where bk.book_type_code = h_book_type_code
7238: and bk.group_asset_id = h_group_asset_id
7239: and bk.depreciate_flag = 'YES'

Line 7267: from fa_mc_books BK_IN

7263: and BK_IN.transaction_header_id_in = p_thid;
7264:
7265: cursor RECLASS_TRANS_CHECK_MRC(p_member_asset_id number,p_thid number) is
7266: select BK_IN.group_asset_id
7267: from fa_mc_books BK_IN
7268: where BK_IN.book_type_code = h_book_type_code
7269: and BK_IN.asset_id = p_member_asset_id
7270: and BK_IN.transaction_header_id_in = p_thid
7271: and BK_IN.set_of_books_id = h_set_of_books_id;

Line 7972: from fa_mc_books bk

7968:
7969: cursor ALL_MEMBERS_MRC is
7970: select bk.asset_id,
7971: bk.group_asset_id
7972: from fa_mc_books bk
7973: where bk.book_type_code = h_book_type_code
7974: and bk.group_asset_id = h_group_asset_id
7975: and bk.date_ineffective is null
7976: and bk.depreciate_flag = 'YES'

Line 8152: Update FA_MC_BOOKS set adjusted_cost = h_adjusted_cost,

8148: fa_debug_pkg.add('fa_track_member_pvt', 'eofy reserve', h_eofy_reserve, p_log_level_rec => p_log_level_rec);
8149: end if;
8150:
8151: -- Update FA_BOOKS table
8152: Update FA_MC_BOOKS set adjusted_cost = h_adjusted_cost,
8153: eofy_reserve = h_eofy_reserve,
8154: last_update_date = sysdate,
8155: last_updated_by = -1
8156: where book_type_code = h_book_type_code

Line 8177: and exists (select /+ index(FA_MC_BOOKS FA_MC_BOOKS_U2) /'reduction rate'

8173: where deprn_source_code = 'DEPRN'
8174: and asset_id = h_member_asset_id
8175: and book_type_code = h_book_type_code
8176: and set_of_books_id = h_set_of_books_id)
8177: and exists (select /*+ index(FA_MC_BOOKS FA_MC_BOOKS_U2) */'reduction rate'
8178: from FA_MC_BOOKS
8179: where asset_id = h_group_asset_id
8180: and book_type_code = h_book_type_code
8181: and transaction_header_id_out is null

Line 8178: from FA_MC_BOOKS

8174: and asset_id = h_member_asset_id
8175: and book_type_code = h_book_type_code
8176: and set_of_books_id = h_set_of_books_id)
8177: and exists (select /*+ index(FA_MC_BOOKS FA_MC_BOOKS_U2) */'reduction rate'
8178: from FA_MC_BOOKS
8179: where asset_id = h_group_asset_id
8180: and book_type_code = h_book_type_code
8181: and transaction_header_id_out is null
8182: and nvl(reduction_rate,0) <> 0

Line 8660: from FA_MC_BOOKS BK,

8656: cursor GET_MEMBER_ASSETS_MRC(p_fiscal_year number,p_period_num number) is
8657: select distinct BK.ASSET_ID, AD.asset_number,
8658: bk_max.transaction_header_id_in as max_trx_id_in_this_group,
8659: bk_other_max.transaction_header_id_in as max_trx_id_in_other_group
8660: from FA_MC_BOOKS BK,
8661: FA_ADDITIONS_B AD,
8662: (
8663: select distinct bk_in.asset_id, bk_in.book_type_code,
8664: first_value(bk_in.transaction_header_id_in)

Line 8667: from fa_mc_books bk_in,

8663: select distinct bk_in.asset_id, bk_in.book_type_code,
8664: first_value(bk_in.transaction_header_id_in)
8665: over (partition by bk_in.asset_id, bk_in.book_type_code
8666: order by bk_in.transaction_header_id_in desc nulls last) as transaction_header_id_in
8667: from fa_mc_books bk_in,
8668: FA_TRANSACTION_HEADERS TH1,
8669: FA_CALENDAR_PERIODS DP1,
8670: FA_FISCAL_YEAR FY
8671: where TH1.book_type_code = BK_in.book_type_code

Line 8690: from fa_mc_books bk_in,

8686: select distinct bk_in.asset_id, bk_in.book_type_code,
8687: first_value(bk_in.transaction_header_id_in)
8688: over (partition by bk_in.asset_id, bk_in.book_type_code
8689: order by bk_in.transaction_header_id_in desc nulls last) as transaction_header_id_in
8690: from fa_mc_books bk_in,
8691: FA_TRANSACTION_HEADERS TH1,
8692: FA_CALENDAR_PERIODS DP1,
8693: FA_FISCAL_YEAR FY
8694: where TH1.book_type_code = BK_in.book_type_code

Line 8709: from fa_mc_books bk_in2,

8705: and bk_in.set_of_books_id = h_set_of_books_id
8706: and (bk_in.asset_id, bk_in.book_type_code) in
8707: (
8708: select distinct bk_in2.asset_id, bk_in2.book_type_code
8709: from fa_mc_books bk_in2,
8710: FA_TRANSACTION_HEADERS TH2,
8711: FA_CALENDAR_PERIODS DP2,
8712: FA_FISCAL_YEAR FY2
8713: where TH2.book_type_code = BK_in2.book_type_code

Line 8757: from fa_mc_books bk

8753: select bk.allocate_to_fully_ret_flag,
8754: bk.allocate_to_fully_rsv_flag,
8755: bk.period_counter_fully_retired,
8756: bk.period_counter_fully_reserved
8757: from fa_mc_books bk
8758: where bk.book_type_code = h_book_type_code
8759: and bk.asset_id = p_asset_id
8760: and bk.date_ineffective is null
8761: and bk.set_of_books_id = h_set_of_books_id;

Line 8817: from FA_MC_BOOKS BK_IN,

8813: BK_IN.DEPRECIATE_FLAG depreciate_flag,
8814: BK_IN.group_Asset_id group_asset_id,
8815: BK_IN.period_counter_fully_retired period_counter_fully_retired,
8816: bk_in.adjusted_cost -nvl(bk_out.adjusted_cost,0) delta_adjusted_cost -- Bug 8484007
8817: from FA_MC_BOOKS BK_IN,
8818: FA_MC_BOOKS BK_OUT
8819: where BK_IN.book_type_code = h_book_type_code
8820: and BK_IN.group_asset_id = h_group_asset_id
8821: and BK_IN.asset_id = h_member_asset_id

Line 8818: FA_MC_BOOKS BK_OUT

8814: BK_IN.group_Asset_id group_asset_id,
8815: BK_IN.period_counter_fully_retired period_counter_fully_retired,
8816: bk_in.adjusted_cost -nvl(bk_out.adjusted_cost,0) delta_adjusted_cost -- Bug 8484007
8817: from FA_MC_BOOKS BK_IN,
8818: FA_MC_BOOKS BK_OUT
8819: where BK_IN.book_type_code = h_book_type_code
8820: and BK_IN.group_asset_id = h_group_asset_id
8821: and BK_IN.asset_id = h_member_asset_id
8822: and BK_IN.transaction_header_id_in = p_transaction_header_id

Line 8968: from FA_MC_BOOKS_SUMMARY

8964: -- EOFY_SALVAGE_VALULE,
8965: EOFY_RESERVE,
8966: SYSTEM_DEPRN_AMOUNT,
8967: SYSTEM_BONUS_DEPRN_AMOUNT
8968: from FA_MC_BOOKS_SUMMARY
8969: where book_type_code = h_book_type_code
8970: and asset_id = h_group_asset_id
8971: and period_counter = p_period_counter
8972: and set_of_books_id = h_set_of_books_id;

Line 8986: from FA_MC_BOOKS_SUMMARY

8982:
8983: cursor GET_GROUP_SYSTEM_INFO_MRC(p_fiscal_year number, p_period_counter_end number) is
8984: select sum(nvl(SYSTEM_DEPRN_AMOUNT,0)),
8985: sum(nvl(SYSTEM_BONUS_DEPRN_AMOUNT,0))
8986: from FA_MC_BOOKS_SUMMARY
8987: where book_type_code = h_book_type_code
8988: and asset_id = h_group_asset_id
8989: and fiscal_year = p_fiscal_year
8990: and period_counter <= p_period_counter_end

Line 9006: from FA_MC_BOOKS_SUMMARY

9002:
9003: cursor GET_GROUP_SALVAGE_MRC(p_fiscal_year number, p_period_num number) is
9004: select SALVAGE_VALUE,
9005: RECOVERABLE_COST
9006: from FA_MC_BOOKS_SUMMARY
9007: where book_type_code = h_book_type_code
9008: and asset_id = h_group_asset_id
9009: and fiscal_year = p_fiscal_year
9010: and period_num = p_period_num

Line 9042: from FA_MC_BOOKS_SUMMARY

9038: BONUS_DEPRN_RESERVE,
9039: YTD_DEPRN,
9040: BONUS_YTD_DEPRN,
9041: EOFY_RESERVE
9042: from FA_MC_BOOKS_SUMMARY
9043: where book_type_code = h_book_type_code
9044: and group_asset_id = h_group_asset_id
9045: and period_counter = h_processing_period_counter -1
9046: and asset_id = h_member_asset_id

Line 9064: from FA_MC_BOOKS BK_IN,

9060: and BK_OUT.transaction_header_id_out(+) = BK_IN.transaction_header_id_in;
9061:
9062: cursor GET_NEW_GROUP_MRC(p_member_asset_id number, p_transaction_header_id number) is
9063: select BK_IN.group_Asset_id group_asset_id
9064: from FA_MC_BOOKS BK_IN,
9065: FA_MC_BOOKS BK_OUT
9066: where BK_IN.book_type_code = h_book_type_code
9067: and BK_IN.asset_id = h_member_asset_id
9068: and BK_IN.transaction_header_id_in = p_transaction_header_id

Line 9065: FA_MC_BOOKS BK_OUT

9061:
9062: cursor GET_NEW_GROUP_MRC(p_member_asset_id number, p_transaction_header_id number) is
9063: select BK_IN.group_Asset_id group_asset_id
9064: from FA_MC_BOOKS BK_IN,
9065: FA_MC_BOOKS BK_OUT
9066: where BK_IN.book_type_code = h_book_type_code
9067: and BK_IN.asset_id = h_member_asset_id
9068: and BK_IN.transaction_header_id_in = p_transaction_header_id
9069: and BK_IN.set_of_books_id = h_set_of_books_id

Line 9207: from fa_mc_books

9203: and set_of_books_id = h_set_of_books_id;
9204:
9205: select exclude_fully_rsv_flag,recognize_gain_loss
9206: into h_exclude_fully_rsv_flag,h_group_recognize_gain_loss
9207: from fa_mc_books
9208: where book_type_code = h_book_type_code
9209: and asset_id = h_group_asset_id
9210: and date_ineffective is null
9211: and set_of_books_id = h_set_of_books_id;

Line 10895: from fa_mc_books

10891: fetch FA_ADJ_RESERVE_MRC into h_adj_reserve;
10892: close FA_ADJ_RESERVE_MRC;
10893:
10894: select eofy_reserve into h_eofy_reserve
10895: from fa_mc_books
10896: where book_type_code = h_book_type_code
10897: and asset_id = h_member_asset_id
10898: and date_ineffective is null
10899: and set_of_books_id = h_set_of_books_id;

Line 11385: MERGE INTO FA_MC_BOOKS_SUMMARY BS

11381: end loop;
11382:
11383: if p_mrc_sob_type_code = 'R' then
11384: forall j in 1..l_tbl_member_asset_id.COUNT
11385: MERGE INTO FA_MC_BOOKS_SUMMARY BS
11386: USING (SELECT
11387: l_tbl_group_asset_id(j) as group_asset_id,
11388: l_tbl_member_asset_id(j) as member_asset_id,
11389: l_tbl_period_counter(j) as period_counter,