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_DEPRN_PERIODS

Line 117: from fa_mc_deprn_periods

113: and period_num=P_period_counter;
114:
115: cursor GET_PERIOD_COUNTER_MRC is
116: select period_counter
117: from fa_mc_deprn_periods
118: where book_type_code=P_book_type_code
119: and fiscal_year=P_fiscal_year
120: and period_num=P_period_counter
121: and set_of_books_id = p_set_of_books_id;

Line 670: fa_mc_deprn_periods dp,

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
673: and tr.period_counter = h_period_counter
674: and tr.fiscal_year = h_fiscal_year

Line 720: from fa_mc_deprn_periods

716: and period_counter = p_period_counter;
717:
718: cursor GET_PERIOD_NUM_MRC(p_period_counter number) is
719: select period_num
720: from fa_mc_deprn_periods
721: where book_type_code = h_book_type_code
722: and period_counter = p_period_counter
723: and nvl(set_of_books_id,-99) = nvl(p_set_of_books_id,-99);
724:

Line 1749: from fa_mc_deprn_periods

1745: end if;
1746:
1747: -- Check fiscal year of populated deprn summary
1748: select fiscal_year into h_ds_fy
1749: from fa_mc_deprn_periods
1750: where book_type_code = h_book_type_code
1751: and period_counter = mem.period_counter
1752: and set_of_books_id = p_set_of_books_id;
1753:

Line 3260: from fa_mc_deprn_periods

3256: and period_counter = p_per_counter;
3257:
3258: cursor GET_PERIOD_NUM_MRC(p_per_counter number) is
3259: select period_num
3260: from fa_mc_deprn_periods
3261: where book_type_code = P_book_type_code
3262: and period_counter = p_per_counter
3263: and nvl(set_of_books_id,-99) = nvl(p_set_of_books_id,-99);
3264:

Line 6049: from fa_mc_deprn_periods

6045: and period_counter = h_loop_period_counter;
6046:
6047: cursor GET_PERD_CLOSE_DATE_MRC is
6048: select nvl(calendar_period_close_date,sysdate)
6049: from fa_mc_deprn_periods
6050: where book_type_code = h_book_type_code
6051: and period_counter = h_loop_period_counter
6052: and set_of_books_id = p_set_of_books_id;
6053:

Line 6158: fa_mc_deprn_periods dp,

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
6162: where dp.book_type_code = h_book_type_code

Line 6159: fa_mc_deprn_periods dp1,

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
6162: where dp.book_type_code = h_book_type_code
6163: and dp.period_counter = h_loop_period_counter

Line 6251: fa_mc_deprn_periods dp,

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
6255: and dp.period_counter = h_loop_period_counter

Line 6294: fa_mc_deprn_periods dp

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
6298: and bk.date_effective <= nvl(dp.period_close_date,sysdate)

Line 6302: and dp.period_num = (select max(period_num) from fa_mc_deprn_periods dp1

6298: and bk.date_effective <= nvl(dp.period_close_date,sysdate)
6299: and nvl(bk.date_ineffective,sysdate) >= nvl(dp.period_close_date,sysdate)
6300: and dp.book_type_code = bk.book_type_code
6301: and dp.fiscal_year = h_fiscal_year - 1
6302: and dp.period_num = (select max(period_num) from fa_mc_deprn_periods dp1
6303: where dp1.book_type_code = h_book_type_code
6304: and dp1.fiscal_year = h_fiscal_year - 1
6305: and dp1.set_of_books_id = p_set_of_books_id)
6306: and dp.set_of_books_id = p_set_of_books_id;

Line 6317: from fa_mc_deprn_periods

6313: and period_num = h_loop_end_period;
6314:
6315: cursor GET_PERIOD_MRC is
6316: select period_counter + 1
6317: from fa_mc_deprn_periods
6318: where book_type_code = h_book_type_code
6319: and fiscal_year = h_loop_end_year
6320: and period_num = h_loop_end_period
6321: and set_of_books_id = p_set_of_books_id;

Line 6408: from fa_mc_deprn_periods dp1,

6404: and adj.set_of_books_id = p_set_of_books_id
6405: and nvl(adj.track_member_flag, 'N') = 'N' -- ENERGY
6406: and adj.period_counter_adjusted in
6407: (select dp2.period_counter
6408: from fa_mc_deprn_periods dp1,
6409: fa_mc_deprn_periods dp2
6410: where dp1.book_type_code = adj.book_type_code
6411: and dp1.period_counter = h_period_counter - 1
6412: and dp1.set_of_books_id = p_set_of_books_id

Line 6409: fa_mc_deprn_periods dp2

6405: and nvl(adj.track_member_flag, 'N') = 'N' -- ENERGY
6406: and adj.period_counter_adjusted in
6407: (select dp2.period_counter
6408: from fa_mc_deprn_periods dp1,
6409: fa_mc_deprn_periods dp2
6410: where dp1.book_type_code = adj.book_type_code
6411: and dp1.period_counter = h_period_counter - 1
6412: and dp1.set_of_books_id = p_set_of_books_id
6413: and dp2.book_type_code = dp1.book_type_code

Line 7951: from fa_mc_deprn_periods

7947: and period_num = h_period_num;
7948:
7949: cursor GET_PERIOD_COUNTER_MRC is
7950: select period_counter
7951: from fa_mc_deprn_periods
7952: where book_type_code = h_book_type_code
7953: and fiscal_year = h_fiscal_year
7954: and period_num = h_period_num
7955: and set_of_books_id = h_set_of_books_id;

Line 8254: from fa_mc_deprn_periods

8250: and period_num = h_period_num;
8251:
8252: cursor GET_PERIOD_COUNTER_MRC is
8253: select period_counter
8254: from fa_mc_deprn_periods
8255: where book_type_code = h_book_type_code
8256: and fiscal_year = h_fiscal_year
8257: and period_num = h_period_num
8258: and set_of_books_id = h_set_of_books_id;

Line 9200: from fa_mc_deprn_periods

9196: else -- Reporting Book
9197:
9198: select period_counter
9199: into h_cur_period_Counter
9200: from fa_mc_deprn_periods
9201: where book_type_Code = h_book_type_code
9202: and period_close_date is null
9203: and set_of_books_id = h_set_of_books_id;
9204:

Line 10661: from fa_mc_deprn_periods

10657: and period_close_date is null;
10658:
10659: cursor GET_CUR_PERIOD_MRC is
10660: select period_counter, fiscal_year, period_num
10661: from fa_mc_deprn_periods
10662: where book_type_code = h_book_type_code
10663: and period_close_date is null
10664: and set_of_books_id = h_set_of_books_id;
10665:

Line 10684: fa_mc_deprn_periods dp1

10680:
10681: cursor MEM_EXP_RESERVE_MRC is
10682: select ds1.deprn_reserve,ds1.ytd_deprn,dp1.fiscal_year
10683: from fa_mc_deprn_summary ds1,
10684: fa_mc_deprn_periods dp1
10685: where ds1.book_type_code = h_book_type_code
10686: and ds1.asset_id = h_member_asset_id
10687: and ds1.set_of_books_id = h_set_of_books_id
10688: and dp1.book_type_code = ds1.book_type_Code

Line 10734: fa_mc_deprn_periods dp1,

10730: and ret.set_of_books_id = h_set_of_books_id
10731: and exists
10732: (select th1.transaction_header_id
10733: from fa_transaction_headers th1,
10734: fa_mc_deprn_periods dp1,
10735: fa_mc_deprn_periods dp3
10736: where th1.asset_id = ret.asset_id
10737: and dp1.book_type_code = h_book_type_code
10738: and dp1.fiscal_year =

Line 10735: fa_mc_deprn_periods dp3

10731: and exists
10732: (select th1.transaction_header_id
10733: from fa_transaction_headers th1,
10734: fa_mc_deprn_periods dp1,
10735: fa_mc_deprn_periods dp3
10736: where th1.asset_id = ret.asset_id
10737: and dp1.book_type_code = h_book_type_code
10738: and dp1.fiscal_year =
10739: (select dp2.fiscal_year

Line 10740: from fa_mc_deprn_periods dp2

10736: where th1.asset_id = ret.asset_id
10737: and dp1.book_type_code = h_book_type_code
10738: and dp1.fiscal_year =
10739: (select dp2.fiscal_year
10740: from fa_mc_deprn_periods dp2
10741: where dp2.book_type_code = dp1.book_type_code
10742: and dp2.period_Counter = h_period_counter - 1
10743: and dp2.set_of_books_id = h_set_of_books_id
10744: and dp2.set_of_books_id = h_set_of_books_id)

Line 10789: from fa_mc_deprn_periods dp1,

10785: and adj.source_type_code = 'ADJUSTMENT'
10786: and adj.set_of_books_id = h_set_of_books_id
10787: and exists
10788: (select dp2.period_counter
10789: from fa_mc_deprn_periods dp1,
10790: fa_mc_deprn_periods dp2
10791: where dp1.book_type_code = adj.book_type_code
10792: and dp1.period_counter = h_period_counter - 1
10793: and dp2.book_type_code = dp1.book_type_code

Line 10790: fa_mc_deprn_periods dp2

10786: and adj.set_of_books_id = h_set_of_books_id
10787: and exists
10788: (select dp2.period_counter
10789: from fa_mc_deprn_periods dp1,
10790: fa_mc_deprn_periods dp2
10791: where dp1.book_type_code = adj.book_type_code
10792: and dp1.period_counter = h_period_counter - 1
10793: and dp2.book_type_code = dp1.book_type_code
10794: and dp2.fiscal_year = dp1.fiscal_year