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 110: from fa_deprn_periods

106:
107: -- cursor to get Period Counter
108: cursor GET_PERIOD_COUNTER is
109: select period_counter
110: from fa_deprn_periods
111: where book_type_code=P_book_type_code
112: and fiscal_year=P_fiscal_year
113: and period_num=P_period_counter;
114:

Line 635: fa_deprn_periods dp,

631: ds.bonus_ytd_deprn
632: from fa_track_members tr,
633: fa_books bk,
634: fa_deprn_summary ds,
635: fa_deprn_periods dp,
636: fa_additions_b ad
637: where tr.group_asset_id = h_group_asset_id
638: and tr.period_counter = h_period_counter
639: and tr.fiscal_year = h_fiscal_year

Line 714: from fa_deprn_periods

710:
711: --* cursor to get period number
712: cursor GET_PERIOD_NUM(p_period_counter number) is
713: select period_num
714: from fa_deprn_periods
715: where book_type_code = h_book_type_code
716: and period_counter = p_period_counter;
717:
718: cursor GET_PERIOD_NUM_MRC(p_period_counter number) is

Line 1589: from fa_deprn_periods

1585: end if;
1586:
1587: -- Check fiscal year of populated deprn summary
1588: select fiscal_year into h_ds_fy
1589: from fa_deprn_periods
1590: where book_type_code = h_book_type_code
1591: and period_counter = mem.period_counter;
1592:
1593: if h_fiscal_year <> h_ds_fy then

Line 3254: from fa_deprn_periods

3250:
3251: --* cursor to get period number
3252: cursor GET_PERIOD_NUM(p_per_counter number) is
3253: select period_num
3254: from fa_deprn_periods
3255: where book_type_code = P_book_type_code
3256: and period_counter = p_per_counter;
3257:
3258: cursor GET_PERIOD_NUM_MRC(p_per_counter number) is

Line 5182: from fa_deprn_periods

5178: else
5179:
5180: -- Check if current fiscal year is same year as populated deprn summary table
5181: select fiscal_year into h_ds_fy
5182: from fa_deprn_periods
5183: where book_type_code = h_book_type_code
5184: and period_counter = member.ds_period_counter;
5185:
5186: if h_ds_fy <> h_fiscal_year then

Line 5389: from fa_deprn_periods

5385: else
5386:
5387: -- Check if current fiscal year is same year as populated deprn summary table
5388: select fiscal_year into h_ds_fy
5389: from fa_deprn_periods
5390: where book_type_code = h_book_type_code
5391: and period_counter = member.ds_period_counter;
5392:
5393: if h_ds_fy <> h_fiscal_year then

Line 6043: from fa_deprn_periods

6039:
6040: -- cursor to get period close date
6041: cursor GET_PERD_CLOSE_DATE is
6042: select nvl(calendar_period_close_date,sysdate)
6043: from fa_deprn_periods
6044: where book_type_code = h_book_type_code
6045: and period_counter = h_loop_period_counter;
6046:
6047: cursor GET_PERD_CLOSE_DATE_MRC is

Line 6109: fa_deprn_periods dp,

6105: ds.bonus_deprn_reserve,
6106: decode(dp1.fiscal_year,h_fiscal_year,ds.bonus_ytd_deprn,0),
6107: dp1.fiscal_year
6108: from fa_books bk,
6109: fa_deprn_periods dp,
6110: fa_deprn_periods dp1,
6111: fa_deprn_summary ds,
6112: fa_additions_b ad
6113: where dp.book_type_code = h_book_type_code

Line 6110: fa_deprn_periods dp1,

6106: decode(dp1.fiscal_year,h_fiscal_year,ds.bonus_ytd_deprn,0),
6107: dp1.fiscal_year
6108: from fa_books bk,
6109: fa_deprn_periods dp,
6110: fa_deprn_periods dp1,
6111: fa_deprn_summary ds,
6112: fa_additions_b ad
6113: where dp.book_type_code = h_book_type_code
6114: and dp.period_counter = h_loop_period_counter

Line 6213: fa_deprn_periods dp,

6209: ds.bonus_deprn_reserve,
6210: ds.bonus_ytd_deprn,
6211: dp.fiscal_year
6212: from fa_books bk,
6213: fa_deprn_periods dp,
6214: fa_deprn_summary ds,
6215: fa_additions_b ad
6216: where dp.book_type_code = h_book_type_code
6217: and dp.period_counter = h_loop_period_counter

Line 6279: fa_deprn_periods dp

6275: cursor MEMBER_START_PERIOD is
6276: select bk.recoverable_cost,
6277: bk.salvage_value
6278: from fa_books bk,
6279: fa_deprn_periods dp
6280: where bk.book_type_code = h_book_type_code
6281: and bk.group_asset_id = h_member_asset_id
6282: and bk.date_effective <= nvl(dp.period_close_date,sysdate)
6283: and nvl(bk.date_ineffective,sysdate) >= nvl(dp.period_close_date,sysdate)

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

6282: and bk.date_effective <= nvl(dp.period_close_date,sysdate)
6283: and nvl(bk.date_ineffective,sysdate) >= nvl(dp.period_close_date,sysdate)
6284: and dp.book_type_code = bk.book_type_code
6285: and dp.fiscal_year = h_fiscal_year - 1
6286: and dp.period_num = (select max(period_num) from fa_deprn_periods dp1
6287: where dp1.book_type_code = h_book_type_code
6288: and dp1.fiscal_year = h_fiscal_year - 1);
6289:
6290: cursor MEMBER_START_PERIOD_MRC is

Line 6310: from fa_deprn_periods

6306: and dp.set_of_books_id = p_set_of_books_id;
6307:
6308: cursor GET_PERIOD is
6309: select period_counter + 1
6310: from fa_deprn_periods
6311: where book_type_code = h_book_type_code
6312: and fiscal_year = h_loop_end_year
6313: and period_num = h_loop_end_period;
6314:

Line 6332: fa_deprn_periods dp1,

6328: and ret.asset_id = h_member_asset_id
6329: and exists
6330: (select th1.transaction_header_id
6331: from fa_transaction_headers th1,
6332: fa_deprn_periods dp1,
6333: fa_deprn_periods dp3
6334: where th1.asset_id = ret.asset_id
6335: and dp1.book_type_code = h_book_type_code
6336: and dp1.fiscal_year =

Line 6333: fa_deprn_periods dp3

6329: and exists
6330: (select th1.transaction_header_id
6331: from fa_transaction_headers th1,
6332: fa_deprn_periods dp1,
6333: fa_deprn_periods dp3
6334: where th1.asset_id = ret.asset_id
6335: and dp1.book_type_code = h_book_type_code
6336: and dp1.fiscal_year =
6337: (select dp2.fiscal_year

Line 6338: from fa_deprn_periods dp2

6334: where th1.asset_id = ret.asset_id
6335: and dp1.book_type_code = h_book_type_code
6336: and dp1.fiscal_year =
6337: (select dp2.fiscal_year
6338: from fa_deprn_periods dp2
6339: where dp2.book_type_code = dp1.book_type_code
6340: and dp2.period_Counter = h_period_counter - 1)
6341: and dp1.period_num = 1
6342: and dp3.book_type_code = dp1.book_type_code

Line 6358: fa_deprn_periods dp1,

6354: and ret.set_of_books_id = p_set_of_books_id
6355: and exists
6356: (select th1.transaction_header_id
6357: from fa_transaction_headers th1,
6358: fa_deprn_periods dp1,
6359: fa_deprn_periods dp3
6360: where th1.asset_id = ret.asset_id
6361: and dp1.book_type_code = h_book_type_code
6362: and dp1.fiscal_year =

Line 6359: fa_deprn_periods dp3

6355: and exists
6356: (select th1.transaction_header_id
6357: from fa_transaction_headers th1,
6358: fa_deprn_periods dp1,
6359: fa_deprn_periods dp3
6360: where th1.asset_id = ret.asset_id
6361: and dp1.book_type_code = h_book_type_code
6362: and dp1.fiscal_year =
6363: (select dp2.fiscal_year

Line 6364: from fa_deprn_periods dp2

6360: where th1.asset_id = ret.asset_id
6361: and dp1.book_type_code = h_book_type_code
6362: and dp1.fiscal_year =
6363: (select dp2.fiscal_year
6364: from fa_deprn_periods dp2
6365: where dp2.book_type_code = dp1.book_type_code
6366: and dp2.period_Counter = h_period_counter - 1)
6367: and dp1.period_num = 1
6368: and dp3.book_type_code = dp1.book_type_code

Line 6387: from fa_deprn_periods dp1,

6383: and adj.source_type_code = 'ADJUSTMENT'
6384: and nvl(adj.track_member_flag, 'N') = 'N' -- ENERGY
6385: and adj.period_counter_adjusted in
6386: (select dp2.period_counter
6387: from fa_deprn_periods dp1,
6388: fa_deprn_periods dp2
6389: where dp1.book_type_code = adj.book_type_code
6390: and dp1.period_counter = h_period_counter - 1
6391: and dp2.book_type_code = dp1.book_type_code

Line 6388: fa_deprn_periods dp2

6384: and nvl(adj.track_member_flag, 'N') = 'N' -- ENERGY
6385: and adj.period_counter_adjusted in
6386: (select dp2.period_counter
6387: from fa_deprn_periods dp1,
6388: fa_deprn_periods dp2
6389: where dp1.book_type_code = adj.book_type_code
6390: and dp1.period_counter = h_period_counter - 1
6391: and dp2.book_type_code = dp1.book_type_code
6392: and dp2.fiscal_year = dp1.fiscal_year

Line 7944: from fa_deprn_periods

7940:
7941: -- cursor to get period_counter
7942: cursor GET_PERIOD_COUNTER is
7943: select period_counter
7944: from fa_deprn_periods
7945: where book_type_code = h_book_type_code
7946: and fiscal_year = h_fiscal_year
7947: and period_num = h_period_num;
7948:

Line 8247: from fa_deprn_periods

8243:
8244: -- cursor to get period_counter
8245: cursor GET_PERIOD_COUNTER is
8246: select period_counter
8247: from fa_deprn_periods
8248: where book_type_code = h_book_type_code
8249: and fiscal_year = h_fiscal_year
8250: and period_num = h_period_num;
8251:

Line 9185: from fa_deprn_periods

9181: if p_mrc_sob_type_code <> 'R' then
9182:
9183: select period_counter
9184: into h_cur_period_Counter
9185: from fa_deprn_periods
9186: where book_type_Code = h_book_type_code
9187: and period_close_date is null;
9188:
9189: select exclude_fully_rsv_flag,recognize_gain_loss

Line 10655: from fa_deprn_periods

10651:
10652: --* Cursor to get current open period
10653: cursor GET_CUR_PERIOD is
10654: select period_counter, fiscal_year, period_num
10655: from fa_deprn_periods
10656: where book_type_code = h_book_type_code
10657: and period_close_date is null;
10658:
10659: cursor GET_CUR_PERIOD_MRC is

Line 10669: fa_deprn_periods dp1

10665:
10666: cursor MEM_EXP_RESERVE is
10667: select ds1.deprn_reserve,ds1.ytd_deprn,dp1.fiscal_year
10668: from fa_deprn_summary ds1,
10669: fa_deprn_periods dp1
10670: where ds1.book_type_code = h_book_type_code
10671: and ds1.asset_id = h_member_asset_id
10672: and dp1.book_type_code = ds1.book_type_Code
10673: and dp1.period_counter = ds1.period_counter

Line 10708: fa_deprn_periods dp1,

10704: and ret.asset_id = h_member_asset_id
10705: and exists
10706: (select th1.transaction_header_id
10707: from fa_transaction_headers th1,
10708: fa_deprn_periods dp1,
10709: fa_deprn_periods dp3
10710: where th1.asset_id = ret.asset_id
10711: and dp1.book_type_code = h_book_type_code
10712: and dp1.fiscal_year =

Line 10709: fa_deprn_periods dp3

10705: and exists
10706: (select th1.transaction_header_id
10707: from fa_transaction_headers th1,
10708: fa_deprn_periods dp1,
10709: fa_deprn_periods dp3
10710: where th1.asset_id = ret.asset_id
10711: and dp1.book_type_code = h_book_type_code
10712: and dp1.fiscal_year =
10713: (select dp2.fiscal_year

Line 10714: from fa_deprn_periods dp2

10710: where th1.asset_id = ret.asset_id
10711: and dp1.book_type_code = h_book_type_code
10712: and dp1.fiscal_year =
10713: (select dp2.fiscal_year
10714: from fa_deprn_periods dp2
10715: where dp2.book_type_code = dp1.book_type_code
10716: and dp2.period_Counter = h_period_counter - 1)
10717: and dp1.period_num = 1
10718: and dp3.book_type_code = dp1.book_type_code

Line 10767: from fa_deprn_periods dp1,

10763: and nvl(adj.track_member_flag, 'N') = 'N' -- ENERGY
10764: and adj.source_type_code = 'ADJUSTMENT'
10765: and exists
10766: (select dp2.period_counter
10767: from fa_deprn_periods dp1,
10768: fa_deprn_periods dp2
10769: where dp1.book_type_code = adj.book_type_code
10770: and dp1.period_counter = h_period_counter - 1
10771: and dp2.book_type_code = dp1.book_type_code

Line 10768: fa_deprn_periods dp2

10764: and adj.source_type_code = 'ADJUSTMENT'
10765: and exists
10766: (select dp2.period_counter
10767: from fa_deprn_periods dp1,
10768: fa_deprn_periods dp2
10769: where dp1.book_type_code = adj.book_type_code
10770: and dp1.period_counter = h_period_counter - 1
10771: and dp2.book_type_code = dp1.book_type_code
10772: and dp2.fiscal_year = dp1.fiscal_year