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

Line 254: FROM fa_deprn_periods fdp

250: AND fdh.asset_id = faav.asset_id
251: -- Check legal entity
252: AND EXISTS(
253: SELECT fdp.period_close_date
254: FROM fa_deprn_periods fdp
255: WHERE fdp.book_type_code = fb.book_type_code
256: AND fdp.calendar_period_close_date
257: BETWEEN ld_start_date
258: AND ld_end_date

Line 263: FROM fa_deprn_periods fdp

259: AND fdp.period_close_date IS NOT NULL
260: )
261: AND fdh.date_effective < nvl(
262: (SELECT MAX(fdp.period_close_date)
263: FROM fa_deprn_periods fdp
264: WHERE fdp.book_type_code = fb.book_type_code
265: AND fdp.calendar_period_close_date <= ld_end_date
266: AND fdp.period_close_date IS NOT NULL
267: ), SYSDATE)

Line 270: FROM fa_deprn_periods fdp

266: AND fdp.period_close_date IS NOT NULL
267: ), SYSDATE)
268: AND (fdh.date_ineffective > nvl(
269: (SELECT MAX(fdp.period_close_date)
270: FROM fa_deprn_periods fdp
271: WHERE fdp.book_type_code = fb.book_type_code
272: AND fdp.calendar_period_close_date <= ld_end_date
273: AND fdp.period_close_date IS NOT NULL
274: ), SYSDATE)

Line 293: FROM fa_deprn_periods dp

289: AND
290: ((SELECT greatest(greatest(dp.calendar_period_open_date,
291: least(SYSDATE, dp.calendar_period_close_date)),
292: dp.calendar_period_open_date)
293: FROM fa_deprn_periods dp
294: WHERE fthv.book_type_code = dp.book_type_code
295: AND fthv.date_effective BETWEEN dp.period_open_date AND
296: nvl(dp.period_close_date, SYSDATE)) <= ld_end_date)
297: ORDER BY faav.asset_number;

Line 338: FROM fa_deprn_periods fdp

334: )
335: -- Check legal entity
336: AND fdh.date_effective < nvl((
337: SELECT MAX(fdp.period_close_date)
338: FROM fa_deprn_periods fdp
339: WHERE fdp.book_type_code = pv_book_type_code
340: AND fdp.calendar_period_close_date <= ld_end_date
341: AND fdp.period_close_date IS NOT NULL), SYSDATE
342: )

Line 346: FROM fa_deprn_periods fdp

342: )
343: AND (
344: fdh.date_ineffective > nvl((
345: SELECT MAX(fdp.period_close_date)
346: FROM fa_deprn_periods fdp
347: WHERE fdp.book_type_code = pv_book_type_code
348: AND fdp.calendar_period_close_date <= ld_end_date
349: AND fdp.period_close_date IS NOT NULL), SYSDATE
350: )

Line 385: FROM fa_deprn_periods fdp

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

Line 392: FROM fa_deprn_periods fdp

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

Line 523: FROM fa_deprn_periods dp

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

Line 539: FROM fa_deprn_periods dp

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

Line 557: FROM fa_deprn_periods dp

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

Line 571: FROM fa_deprn_periods dp

567: AND fthv.transaction_type_code = 'REINSTATEMENT'
568: AND ((SELECT greatest(greatest(dp.calendar_period_open_date,
569: least(SYSDATE, dp.calendar_period_close_date)),
570: dp.calendar_period_open_date)
571: FROM fa_deprn_periods dp
572: WHERE fthv.book_type_code = dp.book_type_code
573: AND fthv.date_effective
574: BETWEEN dp.period_open_date
575: AND nvl(dp.period_close_date, SYSDATE)) <= ld_end_date);

Line 608: fa_deprn_periods dp

604: MIN(thv.transaction_header_id)
605: INTO
606: ln_transaction_header_id
607: FROM
608: fa_deprn_periods dp
609: , fa_transaction_history_trx_v thv
610: WHERE asset_id = lv_asset_id
611: AND transaction_type_code = 'UNIT ADJUSTMENT'
612: AND thv.date_effective BETWEEN dp.period_open_date