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_DEPRN_PERIODS

Line 83: from fa_deprn_periods

79:
80: -- cursor to get Period Counter
81: cursor GET_PERIOD_COUNTER is
82: select period_counter
83: from fa_deprn_periods
84: where book_type_code=P_book_type_code
85: and fiscal_year=P_fiscal_year
86: and period_num=P_period_counter;
87:

Line 606: fa_deprn_periods dp,

602: ds.bonus_ytd_deprn
603: from fa_track_members tr,
604: fa_books bk,
605: fa_deprn_summary ds,
606: fa_deprn_periods dp,
607: fa_additions_b ad
608: where tr.group_asset_id = h_group_asset_id
609: and tr.period_counter = h_period_counter
610: and tr.fiscal_year = h_fiscal_year

Line 685: from fa_deprn_periods

681:
682: --* cursor to get period number
683: cursor GET_PERIOD_NUM(p_period_counter number) is
684: select period_num
685: from fa_deprn_periods
686: where book_type_code = h_book_type_code
687: and period_counter = p_period_counter;
688:
689: cursor GET_PERIOD_NUM_MRC(p_period_counter number) is

Line 1459: from fa_deprn_periods

1455: end if;
1456:
1457: -- Check fiscal year of populated deprn summary
1458: select fiscal_year into h_ds_fy
1459: from fa_deprn_periods
1460: where book_type_code = h_book_type_code
1461: and period_counter = mem.period_counter;
1462:
1463: if h_fiscal_year <> h_ds_fy then

Line 3101: from fa_deprn_periods

3097:
3098: --* cursor to get period number
3099: cursor GET_PERIOD_NUM(p_per_counter number) is
3100: select period_num
3101: from fa_deprn_periods
3102: where book_type_code = P_book_type_code
3103: and period_counter = p_per_counter;
3104:
3105: cursor GET_PERIOD_NUM_MRC(p_per_counter number) is

Line 5021: from fa_deprn_periods

5017: else
5018:
5019: -- Check if current fiscal year is same year as populated deprn summary table
5020: select fiscal_year into h_ds_fy
5021: from fa_deprn_periods
5022: where book_type_code = h_book_type_code
5023: and period_counter = member.ds_period_counter;
5024:
5025: if h_ds_fy <> h_fiscal_year then

Line 5231: from fa_deprn_periods

5227: else
5228:
5229: -- Check if current fiscal year is same year as populated deprn summary table
5230: select fiscal_year into h_ds_fy
5231: from fa_deprn_periods
5232: where book_type_code = h_book_type_code
5233: and period_counter = member.ds_period_counter;
5234:
5235: if h_ds_fy <> h_fiscal_year then

Line 5882: from fa_deprn_periods

5878:
5879: -- cursor to get period close date
5880: cursor GET_PERD_CLOSE_DATE is
5881: select nvl(calendar_period_close_date,sysdate)
5882: from fa_deprn_periods
5883: where book_type_code = h_book_type_code
5884: and period_counter = h_loop_period_counter;
5885:
5886: cursor GET_PERD_CLOSE_DATE_MRC is

Line 5948: fa_deprn_periods dp,

5944: ds.bonus_deprn_reserve,
5945: decode(dp1.fiscal_year,h_fiscal_year,ds.bonus_ytd_deprn,0),
5946: dp1.fiscal_year
5947: from fa_books bk,
5948: fa_deprn_periods dp,
5949: fa_deprn_periods dp1,
5950: fa_deprn_summary ds,
5951: fa_additions_b ad
5952: where dp.book_type_code = h_book_type_code

Line 5949: fa_deprn_periods dp1,

5945: decode(dp1.fiscal_year,h_fiscal_year,ds.bonus_ytd_deprn,0),
5946: dp1.fiscal_year
5947: from fa_books bk,
5948: fa_deprn_periods dp,
5949: fa_deprn_periods dp1,
5950: fa_deprn_summary ds,
5951: fa_additions_b ad
5952: where dp.book_type_code = h_book_type_code
5953: and dp.period_counter = h_loop_period_counter

Line 6051: fa_deprn_periods dp,

6047: ds.bonus_deprn_reserve,
6048: ds.bonus_ytd_deprn,
6049: dp.fiscal_year
6050: from fa_books bk,
6051: fa_deprn_periods dp,
6052: fa_deprn_summary ds,
6053: fa_additions_b ad
6054: where dp.book_type_code = h_book_type_code
6055: and dp.period_counter = h_loop_period_counter

Line 6117: fa_deprn_periods dp

6113: cursor MEMBER_START_PERIOD is
6114: select bk.recoverable_cost,
6115: bk.salvage_value
6116: from fa_books bk,
6117: fa_deprn_periods dp
6118: where bk.book_type_code = h_book_type_code
6119: and bk.group_asset_id = h_member_asset_id
6120: and bk.date_effective <= nvl(dp.period_close_date,sysdate)
6121: and nvl(bk.date_ineffective,sysdate) >= nvl(dp.period_close_date,sysdate)

Line 6124: and dp.period_num = (select max(period_num) from fa_deprn_periods dp1

6120: and bk.date_effective <= nvl(dp.period_close_date,sysdate)
6121: and nvl(bk.date_ineffective,sysdate) >= nvl(dp.period_close_date,sysdate)
6122: and dp.book_type_code = bk.book_type_code
6123: and dp.fiscal_year = h_fiscal_year - 1
6124: and dp.period_num = (select max(period_num) from fa_deprn_periods dp1
6125: where dp1.book_type_code = h_book_type_code
6126: and dp1.fiscal_year = h_fiscal_year - 1);
6127:
6128: cursor MEMBER_START_PERIOD_MRC is

Line 6148: from fa_deprn_periods

6144: and dp.set_of_books_id = h_set_of_books_id;
6145:
6146: cursor GET_PERIOD is
6147: select period_counter + 1
6148: from fa_deprn_periods
6149: where book_type_code = h_book_type_code
6150: and fiscal_year = h_loop_end_year
6151: and period_num = h_loop_end_period;
6152:

Line 6170: fa_deprn_periods dp1,

6166: and ret.asset_id = h_member_asset_id
6167: and exists
6168: (select th1.transaction_header_id
6169: from fa_transaction_headers th1,
6170: fa_deprn_periods dp1,
6171: fa_deprn_periods dp3
6172: where th1.asset_id = ret.asset_id
6173: and dp1.book_type_code = h_book_type_code
6174: and dp1.fiscal_year =

Line 6171: fa_deprn_periods dp3

6167: and exists
6168: (select th1.transaction_header_id
6169: from fa_transaction_headers th1,
6170: fa_deprn_periods dp1,
6171: fa_deprn_periods dp3
6172: where th1.asset_id = ret.asset_id
6173: and dp1.book_type_code = h_book_type_code
6174: and dp1.fiscal_year =
6175: (select dp2.fiscal_year

Line 6176: from fa_deprn_periods dp2

6172: where th1.asset_id = ret.asset_id
6173: and dp1.book_type_code = h_book_type_code
6174: and dp1.fiscal_year =
6175: (select dp2.fiscal_year
6176: from fa_deprn_periods dp2
6177: where dp2.book_type_code = dp1.book_type_code
6178: and dp2.period_Counter = h_period_counter - 1)
6179: and dp1.period_num = 1
6180: and dp3.book_type_code = dp1.book_type_code

Line 6196: fa_deprn_periods dp1,

6192: and ret.set_of_books_id = h_set_of_books_id
6193: and exists
6194: (select th1.transaction_header_id
6195: from fa_transaction_headers th1,
6196: fa_deprn_periods dp1,
6197: fa_deprn_periods dp3
6198: where th1.asset_id = ret.asset_id
6199: and dp1.book_type_code = h_book_type_code
6200: and dp1.fiscal_year =

Line 6197: fa_deprn_periods dp3

6193: and exists
6194: (select th1.transaction_header_id
6195: from fa_transaction_headers th1,
6196: fa_deprn_periods dp1,
6197: fa_deprn_periods dp3
6198: where th1.asset_id = ret.asset_id
6199: and dp1.book_type_code = h_book_type_code
6200: and dp1.fiscal_year =
6201: (select dp2.fiscal_year

Line 6202: from fa_deprn_periods dp2

6198: where th1.asset_id = ret.asset_id
6199: and dp1.book_type_code = h_book_type_code
6200: and dp1.fiscal_year =
6201: (select dp2.fiscal_year
6202: from fa_deprn_periods dp2
6203: where dp2.book_type_code = dp1.book_type_code
6204: and dp2.period_Counter = h_period_counter - 1)
6205: and dp1.period_num = 1
6206: and dp3.book_type_code = dp1.book_type_code

Line 6225: from fa_deprn_periods dp1,

6221: and adj.source_type_code = 'ADJUSTMENT'
6222: and nvl(adj.track_member_flag, 'N') = 'N' -- ENERGY
6223: and adj.period_counter_adjusted in
6224: (select dp2.period_counter
6225: from fa_deprn_periods dp1,
6226: fa_deprn_periods dp2
6227: where dp1.book_type_code = adj.book_type_code
6228: and dp1.period_counter = h_period_counter - 1
6229: and dp2.book_type_code = dp1.book_type_code

Line 6226: fa_deprn_periods dp2

6222: and nvl(adj.track_member_flag, 'N') = 'N' -- ENERGY
6223: and adj.period_counter_adjusted in
6224: (select dp2.period_counter
6225: from fa_deprn_periods dp1,
6226: fa_deprn_periods dp2
6227: where dp1.book_type_code = adj.book_type_code
6228: and dp1.period_counter = h_period_counter - 1
6229: and dp2.book_type_code = dp1.book_type_code
6230: and dp2.fiscal_year = dp1.fiscal_year

Line 7765: from fa_deprn_periods

7761:
7762: -- cursor to get period_counter
7763: cursor GET_PERIOD_COUNTER is
7764: select period_counter
7765: from fa_deprn_periods
7766: where book_type_code = h_book_type_code
7767: and fiscal_year = h_fiscal_year
7768: and period_num = h_period_num;
7769:

Line 8021: from fa_deprn_periods

8017:
8018: -- cursor to get period_counter
8019: cursor GET_PERIOD_COUNTER is
8020: select period_counter
8021: from fa_deprn_periods
8022: where book_type_code = h_book_type_code
8023: and fiscal_year = h_fiscal_year
8024: and period_num = h_period_num;
8025:

Line 8890: from fa_deprn_periods

8886: h_set_of_books_id := FA_CACHE_PKG.fazcbc_record.set_of_books_id;
8887:
8888: select period_counter
8889: into h_cur_period_Counter
8890: from fa_deprn_periods
8891: where book_type_Code = h_book_type_code
8892: and period_close_date is null;
8893:
8894: select exclude_fully_rsv_flag,recognize_gain_loss

Line 8908: from fa_deprn_periods_mrc_v

8904: FA_CACHE_PKG.fazcbc_record.set_of_books_id);
8905:
8906: select period_counter
8907: into h_cur_period_Counter
8908: from fa_deprn_periods_mrc_v
8909: where book_type_Code = h_book_type_code
8910: and period_close_date is null;
8911:
8912: select exclude_fully_rsv_flag,recognize_gain_loss

Line 10330: from fa_deprn_periods

10326:
10327: --* Cursor to get current open period
10328: cursor GET_CUR_PERIOD is
10329: select period_counter, fiscal_year, period_num
10330: from fa_deprn_periods
10331: where book_type_code = h_book_type_code
10332: and period_close_date is null;
10333:
10334: cursor GET_CUR_PERIOD_MRC is

Line 10336: from fa_deprn_periods_mrc_v

10332: and period_close_date is null;
10333:
10334: cursor GET_CUR_PERIOD_MRC is
10335: select period_counter, fiscal_year, period_num
10336: from fa_deprn_periods_mrc_v
10337: where book_type_code = h_book_type_code
10338: and period_close_date is null;
10339:
10340: cursor MEM_EXP_RESERVE is

Line 10343: fa_deprn_periods dp1

10339:
10340: cursor MEM_EXP_RESERVE is
10341: select ds1.deprn_reserve,ds1.ytd_deprn,dp1.fiscal_year
10342: from fa_deprn_summary ds1,
10343: fa_deprn_periods dp1
10344: where ds1.book_type_code = h_book_type_code
10345: and ds1.asset_id = h_member_asset_id
10346: and dp1.book_type_code = ds1.book_type_Code
10347: and dp1.period_counter = ds1.period_counter

Line 10358: fa_deprn_periods_mrc_v dp1

10354:
10355: cursor MEM_EXP_RESERVE_MRC is
10356: select ds1.deprn_reserve,ds1.ytd_deprn,dp1.fiscal_year
10357: from fa_deprn_summary_mrc_v ds1,
10358: fa_deprn_periods_mrc_v dp1
10359: where ds1.book_type_code = h_book_type_code
10360: and ds1.asset_id = h_member_asset_id
10361: and dp1.book_type_code = ds1.book_type_Code
10362: and dp1.period_counter = ds1.period_counter

Line 10379: fa_deprn_periods dp1,

10375: and ret.asset_id = h_member_asset_id
10376: and exists
10377: (select th1.transaction_header_id
10378: from fa_transaction_headers th1,
10379: fa_deprn_periods dp1,
10380: fa_deprn_periods dp3
10381: where th1.asset_id = ret.asset_id
10382: and dp1.book_type_code = h_book_type_code
10383: and dp1.fiscal_year =

Line 10380: fa_deprn_periods dp3

10376: and exists
10377: (select th1.transaction_header_id
10378: from fa_transaction_headers th1,
10379: fa_deprn_periods dp1,
10380: fa_deprn_periods dp3
10381: where th1.asset_id = ret.asset_id
10382: and dp1.book_type_code = h_book_type_code
10383: and dp1.fiscal_year =
10384: (select dp2.fiscal_year

Line 10385: from fa_deprn_periods dp2

10381: where th1.asset_id = ret.asset_id
10382: and dp1.book_type_code = h_book_type_code
10383: and dp1.fiscal_year =
10384: (select dp2.fiscal_year
10385: from fa_deprn_periods dp2
10386: where dp2.book_type_code = dp1.book_type_code
10387: and dp2.period_Counter = h_period_counter - 1)
10388: and dp1.period_num = 1
10389: and dp3.book_type_code = dp1.book_type_code

Line 10404: fa_deprn_periods_mrc_v dp1,

10400: and ret.asset_id = h_member_asset_id
10401: and exists
10402: (select th1.transaction_header_id
10403: from fa_transaction_headers th1,
10404: fa_deprn_periods_mrc_v dp1,
10405: fa_deprn_periods_mrc_v dp3
10406: where th1.asset_id = ret.asset_id
10407: and dp1.book_type_code = h_book_type_code
10408: and dp1.fiscal_year =

Line 10405: fa_deprn_periods_mrc_v dp3

10401: and exists
10402: (select th1.transaction_header_id
10403: from fa_transaction_headers th1,
10404: fa_deprn_periods_mrc_v dp1,
10405: fa_deprn_periods_mrc_v dp3
10406: where th1.asset_id = ret.asset_id
10407: and dp1.book_type_code = h_book_type_code
10408: and dp1.fiscal_year =
10409: (select dp2.fiscal_year

Line 10410: from fa_deprn_periods_mrc_v dp2

10406: where th1.asset_id = ret.asset_id
10407: and dp1.book_type_code = h_book_type_code
10408: and dp1.fiscal_year =
10409: (select dp2.fiscal_year
10410: from fa_deprn_periods_mrc_v dp2
10411: where dp2.book_type_code = dp1.book_type_code
10412: and dp2.period_Counter = h_period_counter - 1)
10413: and dp1.period_num = 1
10414: and dp3.book_type_code = dp1.book_type_code

Line 10433: from fa_deprn_periods dp1,

10429: and nvl(adj.track_member_flag, 'N') = 'N' -- ENERGY
10430: and adj.source_type_code = 'ADJUSTMENT'
10431: and exists
10432: (select dp2.period_counter
10433: from fa_deprn_periods dp1,
10434: fa_deprn_periods dp2
10435: where dp1.book_type_code = adj.book_type_code
10436: and dp1.period_counter = h_period_counter - 1
10437: and dp2.book_type_code = dp1.book_type_code

Line 10434: fa_deprn_periods dp2

10430: and adj.source_type_code = 'ADJUSTMENT'
10431: and exists
10432: (select dp2.period_counter
10433: from fa_deprn_periods dp1,
10434: fa_deprn_periods dp2
10435: where dp1.book_type_code = adj.book_type_code
10436: and dp1.period_counter = h_period_counter - 1
10437: and dp2.book_type_code = dp1.book_type_code
10438: and dp2.fiscal_year = dp1.fiscal_year

Line 10454: from fa_deprn_periods_mrc_v dp1,

10450: and nvl(adj.track_member_flag, 'N') = 'N' -- ENERGY
10451: and adj.source_type_code = 'ADJUSTMENT'
10452: and exists
10453: (select dp2.period_counter
10454: from fa_deprn_periods_mrc_v dp1,
10455: fa_deprn_periods_mrc_v dp2
10456: where dp1.book_type_code = adj.book_type_code
10457: and dp1.period_counter = h_period_counter - 1
10458: and dp2.book_type_code = dp1.book_type_code

Line 10455: fa_deprn_periods_mrc_v dp2

10451: and adj.source_type_code = 'ADJUSTMENT'
10452: and exists
10453: (select dp2.period_counter
10454: from fa_deprn_periods_mrc_v dp1,
10455: fa_deprn_periods_mrc_v dp2
10456: where dp1.book_type_code = adj.book_type_code
10457: and dp1.period_counter = h_period_counter - 1
10458: and dp2.book_type_code = dp1.book_type_code
10459: and dp2.fiscal_year = dp1.fiscal_year