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.JA_CN_FA_ACUI_EXPORT_PKG dependencies on FA_DEPRN_PERIODS

Line 275: FROM fa_deprn_periods fdp

271: AND fdh.asset_id = faav.asset_id
272: -- Check legal entity
273: AND EXISTS
274: (SELECT fdp.period_close_date
275: FROM fa_deprn_periods fdp
276: WHERE fdp.book_type_code = fb.book_type_code
277: AND fdp.calendar_period_close_date BETWEEN ld_start_date AND
278: ld_end_date
279: AND fdp.period_close_date IS NOT NULL)

Line 282: FROM fa_deprn_periods fdp

278: ld_end_date
279: AND fdp.period_close_date IS NOT NULL)
280: AND fdh.date_effective <
281: nvl((SELECT MAX(fdp.period_close_date)
282: FROM fa_deprn_periods fdp
283: WHERE fdp.book_type_code = fb.book_type_code
284: AND fdp.calendar_period_close_date <= ld_end_date
285: AND fdp.period_close_date IS NOT NULL),
286: SYSDATE)

Line 289: FROM fa_deprn_periods fdp

285: AND fdp.period_close_date IS NOT NULL),
286: SYSDATE)
287: AND (fdh.date_ineffective >
288: nvl((SELECT MAX(fdp.period_close_date)
289: FROM fa_deprn_periods fdp
290: WHERE fdp.book_type_code = fb.book_type_code
291: AND fdp.calendar_period_close_date <= ld_end_date
292: AND fdp.period_close_date IS NOT NULL),
293: SYSDATE) OR fdh.date_ineffective IS NULL)

Line 312: FROM fa_deprn_periods dp

308: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,
309: least(SYSDATE,
310: dp.calendar_period_close_date)),
311: dp.calendar_period_open_date)
312: FROM fa_deprn_periods dp
313: WHERE fthv.book_type_code = dp.book_type_code
314: AND fthv.date_effective BETWEEN dp.period_open_date AND
315: nvl(dp.period_close_date, SYSDATE)) <= ld_end_date)
316: ORDER BY faav.asset_number;

Line 343: FROM fa_deprn_periods fdp

339: ppf.effective_end_date))
340: -- Check legal entity
341: AND fdh.date_effective <
342: nvl((SELECT MAX(fdp.period_close_date)
343: FROM fa_deprn_periods fdp
344: WHERE fdp.book_type_code = pv_book_type_code
345: AND fdp.calendar_period_close_date <= ld_end_date
346: AND fdp.period_close_date IS NOT NULL),
347: SYSDATE)

Line 350: FROM fa_deprn_periods fdp

346: AND fdp.period_close_date IS NOT NULL),
347: SYSDATE)
348: AND (fdh.date_ineffective >
349: nvl((SELECT MAX(fdp.period_close_date)
350: FROM fa_deprn_periods fdp
351: WHERE fdp.book_type_code = pv_book_type_code
352: AND fdp.calendar_period_close_date <= ld_end_date
353: AND fdp.period_close_date IS NOT NULL),
354: SYSDATE) OR fdh.date_ineffective IS NULL)

Line 382: FROM fa_deprn_periods fdp

378: AND fdh.asset_id = pv_asset_id
379: -- Check legal entity
380: AND fdh.date_effective <
381: nvl((SELECT MAX(fdp.period_close_date)
382: FROM fa_deprn_periods fdp
383: WHERE fdp.book_type_code = pv_book_type_code
384: AND fdp.calendar_period_close_date <= ld_end_date
385: AND fdp.period_close_date IS NOT NULL),
386: SYSDATE)

Line 389: FROM fa_deprn_periods fdp

385: AND fdp.period_close_date IS NOT NULL),
386: SYSDATE)
387: AND (fdh.date_ineffective >
388: nvl((SELECT MAX(fdp.period_close_date)
389: FROM fa_deprn_periods fdp
390: WHERE fdp.book_type_code = pv_book_type_code
391: AND fdp.calendar_period_close_date <= ld_end_date
392: AND fdp.period_close_date IS NOT NULL),
393: SYSDATE) OR fdh.date_ineffective IS NULL)

Line 505: FROM fa_deprn_periods dp

501: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,
502: least(SYSDATE,
503: dp.calendar_period_close_date)),
504: dp.calendar_period_open_date)
505: FROM fa_deprn_periods dp
506: WHERE fthv.book_type_code = dp.book_type_code
507: AND fthv.date_effective BETWEEN dp.period_open_date AND
508: nvl(dp.period_close_date, SYSDATE)) <= ld_end_date);
509: IF (ln_full_retirement_count <> 0) THEN

Line 522: FROM fa_deprn_periods dp

518: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,
519: least(SYSDATE,
520: dp.calendar_period_close_date)),
521: dp.calendar_period_open_date)
522: FROM fa_deprn_periods dp
523: WHERE fthv.book_type_code = dp.book_type_code
524: AND fthv.date_effective BETWEEN dp.period_open_date AND
525: nvl(dp.period_close_date, SYSDATE)) <= ld_end_date);
526: IF (ln_reinstate_count = 0) THEN

Line 540: FROM fa_deprn_periods dp

536: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,
537: least(SYSDATE,
538: dp.calendar_period_close_date)),
539: dp.calendar_period_open_date)
540: FROM fa_deprn_periods dp
541: WHERE fthv.book_type_code = dp.book_type_code
542: AND fthv.date_effective BETWEEN dp.period_open_date AND
543: nvl(dp.period_close_date, SYSDATE)) <=
544: ld_end_date);

Line 556: FROM fa_deprn_periods dp

552: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,
553: least(SYSDATE,
554: dp.calendar_period_close_date)),
555: dp.calendar_period_open_date)
556: FROM fa_deprn_periods dp
557: WHERE fthv.book_type_code = dp.book_type_code
558: AND fthv.date_effective BETWEEN dp.period_open_date AND
559: nvl(dp.period_close_date, SYSDATE)) <=
560: ld_end_date);

Line 588: FROM fa_deprn_periods dp, fa_transaction_history_trx_v thv

584: --check if the asset is unit adjusted after the to_date.
585: BEGIN
586: SELECT MIN(thv.transaction_header_id)
587: INTO ln_transaction_header_id
588: FROM fa_deprn_periods dp, fa_transaction_history_trx_v thv
589: WHERE asset_id = lv_asset_id
590: AND transaction_type_code = 'UNIT ADJUSTMENT'
591: AND thv.date_effective BETWEEN dp.period_open_date AND
592: nvl(dp.period_close_date, sysdate)