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_GAINLOSS_UND_PKG dependencies on FA_DEPRN_PERIODS

Line 138: fa_adjustments faadj, fa_retirements faret, fa_deprn_periods dp

134: DECODE(faadj.debit_credit_flag, 'CR', 'DR', 'CR'),
135: faadj.adjustment_amount,
136: faadj.track_member_flag --Bug8244128
137: FROM
138: fa_adjustments faadj, fa_retirements faret, fa_deprn_periods dp
139: WHERE faadj.transaction_header_id = faret.transaction_header_id_in
140: AND faadj.asset_id = faret.asset_id
141: AND faadj.book_type_Code = faret.book_type_code
142: AND faadj.source_type_code = decode(p_wip_asset, 1, 'CIP RETIREMENT',

Line 165: fa_adjustments faadj, fa_retirements faret, fa_deprn_periods dp

161: DECODE(faadj.debit_credit_flag, 'CR', 'DR', 'CR'),
162: faadj.adjustment_amount,
163: faadj.track_member_flag --Bug8244128
164: FROM
165: fa_adjustments faadj, fa_retirements faret, fa_deprn_periods dp
166: WHERE faadj.transaction_header_id = p_group_thid
167: AND faadj.asset_id = p_group_asset_id
168: AND faadj.book_type_Code = faret.book_type_code
169: AND faadj.source_type_code = decode(p_wip_asset, 1, 'CIP RETIREMENT',

Line 198: fa_deprn_periods dp

194: faadj.track_member_flag --Bug8244128
195: FROM
196: fa_mc_adjustments faadj,
197: fa_mc_retirements faret,
198: fa_deprn_periods dp
199: WHERE faadj.transaction_header_id = faret.transaction_header_id_in
200: AND faadj.asset_id = faret.asset_id
201: AND faadj.set_of_books_id = ret.set_of_books_id
202: AND faadj.book_type_Code = faret.book_type_code

Line 229: fa_deprn_periods dp

225: faadj.track_member_flag --Bug8244128
226: FROM
227: fa_mc_adjustments faadj,
228: fa_mc_retirements faret,
229: fa_deprn_periods dp
230: WHERE faadj.transaction_header_id = p_group_thid
231: AND faadj.asset_id = p_group_asset_id
232: AND faadj.book_type_Code = faret.book_type_code
233: AND faadj.set_of_books_id = ret.set_of_books_id

Line 638: FA_DEPRN_PERIODS DP,

634: h_is_prior_period
635: FROM
636: FA_TRANSACTION_HEADERS TH,
637: FA_BOOK_CONTROLS BC,
638: FA_DEPRN_PERIODS DP,
639: FA_DEPRN_PERIODS DP_NOW
640: WHERE
641: TH.ASSET_ID = h_asset_id AND
642: -- TH.TRANSACTION_TYPE_CODE = 'ADDITION' AND --bug 6129798

Line 639: FA_DEPRN_PERIODS DP_NOW

635: FROM
636: FA_TRANSACTION_HEADERS TH,
637: FA_BOOK_CONTROLS BC,
638: FA_DEPRN_PERIODS DP,
639: FA_DEPRN_PERIODS DP_NOW
640: WHERE
641: TH.ASSET_ID = h_asset_id AND
642: -- TH.TRANSACTION_TYPE_CODE = 'ADDITION' AND --bug 6129798
643: TH.TRANSACTION_TYPE_CODE in ('ADDITION', 'CIP ADDITION') AND --bug 6129798

Line 791: fa_deprn_periods

787:
788: SELECT period_counter
789: into h_cpd_num
790: from
791: fa_deprn_periods
792: where book_type_code = h_book
793: and period_close_date is null;
794:
795: -- We need to move the cost, reserve and reval reserve to the

Line 4455: FROM FA_DEPRN_PERIODS fadp

4451: end if;
4452:
4453: SELECT PERIOD_NUM , PERIOD_NAME, PERIOD_COUNTER
4454: INTO h_rpdnum, h_rpdname, h_pd_counter
4455: FROM FA_DEPRN_PERIODS fadp
4456: WHERE RET.date_effective
4457: between fadp.period_open_date and
4458: nvl(fadp.period_close_date,
4459: RET.date_effective)

Line 4480: FROM fa_deprn_summary fads, fa_deprn_periods fadp

4476: nvl(fads.impairment_reserve, 0)
4477: INTO h_deprn_reserve, h_bonus_deprn_reserve, h_reval_reserve,
4478: h_prior_fy_expense, h_ytd_deprn,
4479: h_impairment_reserve
4480: FROM fa_deprn_summary fads, fa_deprn_periods fadp
4481: WHERE fads.asset_id = h_asset_id
4482: AND fads.book_type_Code = h_book
4483: AND fads.period_counter = fadp.period_counter
4484: AND fadp.period_counter =

Line 4486: FROM FA_DEPRN_PERIODS DP, FA_DEPRN_SUMMARY DS

4482: AND fads.book_type_Code = h_book
4483: AND fads.period_counter = fadp.period_counter
4484: AND fadp.period_counter =
4485: (select MAX(DP.PERIOD_COUNTER)
4486: FROM FA_DEPRN_PERIODS DP, FA_DEPRN_SUMMARY DS
4487: WHERE DP.BOOK_TYPE_CODE = h_book
4488: AND DP.PERIOD_COUNTER = DS.PERIOD_COUNTER
4489: AND DP.PERIOD_COUNTER < h_pd_counter
4490: AND DS.BOOK_TYPE_CODE = h_book

Line 4502: FROM fa_mc_deprn_summary fads, fa_deprn_periods fadp

4498: nvl(fads.impairment_reserve, 0)
4499: INTO h_deprn_reserve, h_bonus_deprn_reserve, h_reval_reserve,
4500: h_prior_fy_expense, h_ytd_deprn,
4501: h_impairment_reserve
4502: FROM fa_mc_deprn_summary fads, fa_deprn_periods fadp
4503: WHERE fads.asset_id = h_asset_id
4504: AND fads.book_type_Code = h_book
4505: AND fads.period_counter = fadp.period_counter
4506: AND fads.set_of_books_id = ret.set_of_books_id

Line 4509: FROM FA_DEPRN_PERIODS DP, FA_MC_DEPRN_SUMMARY DS

4505: AND fads.period_counter = fadp.period_counter
4506: AND fads.set_of_books_id = ret.set_of_books_id
4507: AND fadp.period_counter =
4508: (select MAX(DP.PERIOD_COUNTER)
4509: FROM FA_DEPRN_PERIODS DP, FA_MC_DEPRN_SUMMARY DS
4510: WHERE DP.BOOK_TYPE_CODE = h_book
4511: AND DP.PERIOD_COUNTER = DS.PERIOD_COUNTER
4512: AND DP.PERIOD_COUNTER < h_pd_counter
4513: AND DS.set_of_books_id = ret.set_of_books_id